Formatting Worksheets

You can format multiple worksheets at the same time in Excel. To do this you must first group the worksheets together.

To Group and Format Worksheets:

• Click the first sheet tab you would like to format.
• Press and hold the Shift key on your keyboard.
• Click the last sheet tab you would like to format.
  
  For example, if you have a workbook with three worksheets labeled 2005, 2006, and 2007, respectively, you would click the 2005 tab, press and hold the Shift key, and then click the 2007 tab. Both sheet tabs you clicked, and any in between, will be highlighted.

• Edit one of the worksheets.

• Open the Monthly Budget spreadsheet.
• Group the three sheet tabs.
• Add a column to the right of July.
• Type August in the column heading.
• Save and close the spreadsheet.

Applying and Modifying Cell Formats

You may want to modify the appearance of your spreadsheet to make it more visually appealing. Excel allows you to make cosmetic changes to cell formatting.

To Apply and Modify Cell Formats:

• Use your mouse to select the cells you want to modify.
• Select Format Cells from the main menu. The Format Cells dialog box will appear.
• Decide how you want to format the cells.
• Select the tabs that allow you to make the desired changes.
• Use the Format Cells drop-down menus and tools to make the desired changes.
• Click OK.
  

In the Format Cells Dialog Box You Can Change:

• Number Formatting
• Alignment Formatting
• Font Formatting
• Border Formatting
• And More!

• Open the Employee Sales spreadsheet.
• Modify the font to be Verdana.
• Change the font size to 14.
• Make the column headings blue.
• Continue to format the cells until you are comfortable using the Number, Alignment, Font, Border, and Patterns tabs in the Format Cells dialog box.
• Save and close the spreadsheet.

Creating New Workbooks Using Templates

Excel allows your to create new workbooks using templates, or a predefined pattern. Several templates are preloaded in Excel and others are located on Microsoft Office Online.

To Create New Workbooks Using Templates On Your Computer:

• Open Excel.
• Select New from the menu. The New Workbook dialog box will appear.
• File New from the main menu. The New Workbook task pane will appear.
• Click On my computer... in the Templates section of the New Workbook task pane. The Templates dialog box will appear.
• Select the Spreadsheet Solutions tab.
• Select the template you wish to use.
• Click OK.

To Create New Workbooks Using Templates on Office Online:

• Open Excel.
• Select FileNew from the main menu. The New Workbook task pane will appear.
• Click Templates on Office Online in the Templates section of the New Workbook task pane. Office Online will open in a new browser window.
• Browse the template categories and click the link of the category you wish to view.
• Click a template link.
• Click Download Now to download the template.

• Open Excel.
• Select FileNew from the main menu.
• View the templates on your computer.
• Click Templates on Office Online.
• View several of the template categories on Office Online.
• Select a template.
• Download the template.
• Enter your data into the template.
• Save and close Excel.