1 / 10

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:. Hide and unhide rows and columns. Freeze and unfreeze rows and columns. Move between worksheets in a workbook. Add and delete worksheets in a workbook. Create three-dimensional formulas. Link workbooks. Hiding and Unhiding Rows and Columns.

oakley
Download Presentation

After completing this lesson, you will be able to:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. After completing this lesson, you will be able to: • Hide and unhide rows and columns. • Freeze and unfreeze rows and columns. • Move between worksheets in a workbook. • Add and delete worksheets in a workbook. • Create three-dimensional formulas. • Link workbooks.

  2. Hiding and UnhidingRows and Columns To hide a row or column • Click the selector for the row or column to hide. • On the Format menu, point to Row or Column and then click Hide.

  3. Hiding and UnhidingRows and Columns To unhide a row or column • Select the rows or columns on both sides of the hidden row or column. • On the Format menu, point to Row or Column and then click Unhide.

  4. Freezing and UnfreezingRows and Columns To freeze rows and columns • Click a cell underneath the bottom row that you want to freeze and to the right of the rightmost column that you want to freeze. • On the Windows menu, click Freeze Panes.

  5. Freezing and UnfreezingRows and Columns To unfreeze rows and columns • On the Windows menu, click Unfreeze Panes.

  6. Navigating Between Worksheets in a Workbook To navigate between worksheets in a workbook • Click on the sheet tab of the worksheet that you want to display.

  7. Adding and Deleting Worksheets in a Workbook To add a worksheet to a workbook • On the Insert menu, click Worksheet.

  8. Adding and Deleting Worksheets in a Workbook To delete a worksheet in a workbook • In your workbook, click the sheet tab for the worksheet that you want to delete. • On the Edit menu, click Delete Sheet.

  9. Creating a Three-dimensional Formula To create a three-dimensional formula • Click the cell where you want to insert the formula. • Type the formula using the appropriate worksheet and cell references. • Press Enter.

  10. Linking Workbooks To link workbooks • Open the workbooks that you want to link. • On the Windows menu, click Arrange and then click OK. • Click the cell where you want to insert a formula and write the formula using the appropriate workbook and cell references. • Press Enter and save the linked workbooks.

More Related