To open a workbook
On the Office menu, click Open.
Navigate to the workbook you want to open, and then click Open.
To create a new workbook
On the Office menu, click New, and then click Blank Workbook.
To save a workbook
On the Quick Access Toolbar, click the Save button.
Type a name for the file, and then click Save.
To set file properties
On the Office menu, point to Finish, and then click Properties.
Add information describing your file.
To define custom properties
On the Office menu, point to Finish, and then click Properties.
In the Property Views and Options list, click Advanced.
On the Custom tab, type a property name, select the type of data contained in the property, and type a value for the property.
Click Add, and then click OK.
To display a worksheet
Click the sheet tab of the worksheet you want to display.
To create a new worksheet
Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet, click Insert, and then double-click Worksheet.
To change the order of worksheets in a workbook
Drag the sheet tab of the worksheet you want to move.
To copy a worksheet to another workbook
Open the target workbook,and then switch to the source workbook..
Hold down the
key, and click the sheet tabs of the worksheets you want to copy.Right-click the selection, and then click Move Or Copy.
Select the Create A Copy check box. In the To Book list, click the workbook to which you want to copy the worksheet(s). Then click OK.
To rename a worksheet
To hide a worksheet
To unhide a worksheet
Right-click any worksheet tab, and then click Unhide.
Click the worksheet you want to unhide, and then click OK.
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, and then click Insert.
To delete a selected column or row
Right-click the column or row, and then click Delete.
To hide a selected column or row
Right-click the column or row, and then click Hide.
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 then click Unhide.
To insert a cell
Select the cells in the location where you want to insert new cells.
On the Home tab, in the Cells group, click the Insert arrow, and then in the list, click Insert Cells.
Click the option representing how you want to move the existing cells to make room for the inserted cells, and then click OK.
To delete selected cells
On the Home tab, in the Cells group, in the Delete list, click Delete Cells.
Click the option representing how you want the remaining cells to fill the deleted space, and then click OK.
To zoom in or out on a worksheet
Click the Zoom In control to make your window's contents 10 percent larger per click.
Click the Zoom Out control to make your window's contents 10 percent smaller per click.
Drag the Zoom slider control to the left to zoom out, or to the right to zoom in.
To zoom in or out to a specific zoom level
On the View tab, in the Zoom group, click Zoom.
Click Custom, type a new zoom level in the Custom field, and then 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
On the View tab, in the Window group, click Arrange All.
Select the arrangement you want, and then click OK.
To remove a button from the Quick Access Toolbar
Right-click the button, and then click Remove from Quick Access Toolbar.
To add a button to the Quick Access Toolbar
Click the Customize Quick Access Toolbar button, and then click More Commands.
In the Choose Commands From list, click the command category you want.
Click the command you want to add, click Add, and then click OK.
To move a button on the Quick Access Toolbar
Click the Customize Quick Access Toolbar button, and then click More Commands.
Click the command you want to move.
Click the Move Up button or the Move Down button.