To open a workbook
Click the Microsoft Office Button and then click Open.
Navigate to the folder that contains the workbook you want to open.
Click the workbook.
Click Open.
To create a new workbook
To save a workbook
To set file properties
Open the file for which you want to assign property values.
Click the Microsoft Office Button.
Point to Finish and then click Properties.
Add information describing your file.
To define custom properties
Open the file for which you want to assign property values.
Click the Microsoft Office Button.
Point to Finish and then click Properties.
Click the Property Views and Options down arrow.
Click Advanced.
Click the Custom tab.
Type a property name.
Select the type of data contained in the property.
Type a value for the property.
Click Add.
Click OK.
To display a worksheet
To create a new worksheet
Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet.
Choose Insert from the shortcut menu.
Double-click Worksheet.
To rename a worksheet
Double-click the sheet tab of the worksheet you want to rename.
Type the new name of the worksheet and press Enter.
To copy a worksheet to another workbook
Open the workbook that will receive the new worksheets.
Switch to the workbook that contains the worksheets you want to copy, hold down the Ctrl key, and click the sheet tabs of the worksheets you want to copy.
Right-click the selection.
Choose Move Or Copy from the shortcut menu.
Select the Create A Copy check box.
Click the To Book down arrow.
Click the workbook to which you want the worksheet(s) copied.
Click OK.
To change the order of worksheets in a workbook
To hide a worksheet
To unhide a worksheet
To delete a worksheet
To change a row’s height or column’s width
Select the rows and columns you want to resize.
Drag a row or column border until it is the desired size.
To insert a column or row
Right-click the column header to the right of, or the row header below, where you want the new column or row to appear.
Choose Insert from the shortcut menu.
To delete a column or row
Select the row or column you want to delete.
Right-click the selection and choose Delete from the shortcut menu.
To hide a column or row
Select the rows or columns you want to hide.
Right-click a row or column header in the selection and choose Hide from the shortcut menu.
To unhide a column or row
Click the row or column header of the row above or the column to the left of the rows or columns you want to unhide.
Hold down the key and click the row or column header of the row or column below or to the right of the rows or columns you want to unhide.
Right-click the selection and choose Unhide from the shortcut menu.
To insert a cell
Select the cells in the spot where you want to insert new cells.
Click the Home tab.
In the Cells group, click the Insert button’s down arrow.
Click Insert Cells.
Select the option button representing how you want to move the existing cells to make room for the inserted cells.
Click OK.
To delete a cell
Select the cells you want to delete.
Click the Home tab.
In the Cells group, click the Delete button’s down arrow.
Click Delete Cells.
Select the option button representing how you want the remaining cells to fill in the deleted space.
Click OK.
To move a group of cells to a new location
Select the cells you want to move.
Move the mouse pointer over the outline of the selected cells.
Drag the cells to the desired location.
To zoom in or out on a worksheet
To zoom in or out to a specific zoom level
On the View tab, in the Zoom group, click Zoom.
Select the Custom option.
Type a new zoom level in the Custom field.
Click OK.
To change to another open workbook
On the View tab, in the Window group, click Switch Windows.
Click the name of the workbook you want to display.
To arrange all open workbooks in the program window
To add a button to the Quick Access Toolbar
Click the Customize Quick Access Toolbar button.
Click More Commands.
Click the Choose Commands From down arrow.
Click the category from which you want to choose the command.
Click the command you want to add.
Click Add.
Click OK.
To move a button on the Quick Access Toolbar
Click the Customize Quick Access Toolbar button.
Click More Commands.
Click the command you want to move.
Click the Move Up button or the Move Down button.
To remove a button from the Quick Access Toolbar