Setting Up a Workbook

To open a workbook

  1. Click the Microsoft Office Button and then click Open.

  2. Navigate to the folder that contains the workbook you want to open.

  3. Click the workbook.

  4. Click Open.

To create a new workbook

  1. Click the Microsoft Office Button.

  2. Click New.

  3. Click Blank Workbook.

To save a workbook

  1. On the Quick Access Toolbar, click the Save button.

  2. Type a name for the file.

  3. Click Save.

To set file properties

  1. Open the file for which you want to assign property values.

  2. Click the Microsoft Office Button.

  3. Point to Finish and then click Properties.

  4. Add information describing your file.

To define custom properties

  1. Open the file for which you want to assign property values.

  2. Click the Microsoft Office Button.

  3. Point to Finish and then click Properties.

  4. Click the Property Views and Options down arrow.

  5. Click Advanced.

  6. Click the Custom tab.

  7. Type a property name.

  8. Select the type of data contained in the property.

  9. Type a value for the property.

  10. Click Add.

  11. Click OK.

To display a worksheet

  • Click the sheet tab of the worksheet you want to display.

To create a new worksheet

  1. Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet.

  2. Choose Insert from the shortcut menu.

  3. Double-click Worksheet.

To rename a worksheet

  1. Double-click the sheet tab of the worksheet you want to rename.

  2. Type the new name of the worksheet and press Enter.

To copy a worksheet to another workbook

  1. Open the workbook that will receive the new worksheets.

  2. 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.

  3. Right-click the selection.

  4. Choose Move Or Copy from the shortcut menu.

  5. Select the Create A Copy check box.

  6. Click the To Book down arrow.

  7. Click the workbook to which you want the worksheet(s) copied.

  8. Click OK.

To change the order of worksheets in a workbook

  • Drag the sheet tab of the worksheet you want to move.

To hide a worksheet

  1. Hold down the key and click the sheet tabs of the worksheets you want to hide.

  2. Right-click any selected worksheet tab and then choose the Hide command.

To unhide a worksheet

  1. Right-click any worksheet tab.

  2. Click Unhide.

  3. Click the worksheet you want to unhide.

  4. Click OK.

To delete a worksheet

  1. Hold down the key and click the sheet tabs of the worksheets you want to delete.

  2. Right-click the selection.

  3. Choose Delete from the shortcut menu.

To change a row’s height or column’s width

  1. Select the rows and columns you want to resize.

  2. Drag a row or column border until it is the desired size.

To insert a column or row

  1. Right-click the column header to the right of, or the row header below, where you want the new column or row to appear.

  2. Choose Insert from the shortcut menu.

To delete a column or row

  1. Select the row or column you want to delete.

  2. Right-click the selection and choose Delete from the shortcut menu.

To hide a column or row

  1. Select the rows or columns you want to hide.

  2. Right-click a row or column header in the selection and choose Hide from the shortcut menu.

To unhide a column or row

  1. 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.

  2. 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.

  3. Right-click the selection and choose Unhide from the shortcut menu.

To insert a cell

  1. Select the cells in the spot where you want to insert new cells.

  2. Click the Home tab.

  3. In the Cells group, click the Insert button’s down arrow.

  4. Click Insert Cells.

  5. Select the option button representing how you want to move the existing cells to make room for the inserted cells.

  6. Click OK.

To delete a cell

  1. Select the cells you want to delete.

  2. Click the Home tab.

  3. In the Cells group, click the Delete button’s down arrow.

  4. Click Delete Cells.

  5. Select the option button representing how you want the remaining cells to fill in the deleted space.

  6. Click OK.

To move a group of cells to a new location

  1. Select the cells you want to move.

  2. Move the mouse pointer over the outline of the selected cells.

  3. Drag the cells to the desired location.

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, shown in the figure, to the left to zoom out, or to the right to zoom in.

To zoom in or out to a specific zoom level

  1. On the View tab, in the Zoom group, click Zoom.

  2. Select the Custom option.

  3. Type a new zoom level in the Custom field.

  4. Click OK.

To change to another open workbook

  1. On the View tab, in the Window group, click Switch Windows.

  2. Click the name of the workbook you want to display.

To arrange all open workbooks in the program window

  1. On the View tab, in the Window group, click Arrange All.

  2. Select the desired arrangement.

  3. Click OK.

To add a button to the Quick Access Toolbar

  1. Click the Customize Quick Access Toolbar button.

  2. Click More Commands.

  3. Click the Choose Commands From down arrow.

  4. Click the category from which you want to choose the command.

  5. Click the command you want to add.

  6. Click Add.

  7. Click OK.

To move a button on the Quick Access Toolbar

  1. Click the Customize Quick Access Toolbar button.

  2. Click More Commands.

  3. Click the command you want to move.

  4. Click the Move Up button or the Move Down button.

To remove a button from the Quick Access Toolbar

  1. Right-click the button you want to remove.

  2. Click Remove from Quick Access Toolbar.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.143.207