The Excel Interface: The Workbook Window

    11001131 VIEW 2 0

The Workbook Window: In Excel 2013 and above, when you open up a new workbook it now contains only 1 worksheet There can be a max of 1,048,576 rows and 16,384 columns in an excel work sheet

  • The Worksheet Excel files are called workbooks. Each workbook holds one or more worksheets (also known as "spreadsheets"). Whenever you create a new Excel workbook, it will contain one worksheet named Sheet1.   A worksheet is a grid of columns and rows where columns are designated by letters running across the top of the worksheet and rows are designated by numbers running down the left side of the worksheet.
    • To rename a worksheet Whenever you create a new Excel workbook, it will contain oneworksheet named Sheet1.

 

  • Type the desired name for the worksheet.

  • Click anywhere outside of the worksheet, or press Enter on your keyboard. The worksheet will be renamed.
  • To insert a new worksheet
    •  Locate and select the New sheet button.

  • A new, blank worksheet will appear.
  • To delate worksheet
    • Right-click the worksheet you wish to delete, then select Delete from the worksheet menu.

  •  The worksheet will be deleted from your workbook.

To copy a worksheet If you need to duplicate the content of one worksheet to another, Excel allows you to copy an existing worksheet.

  • Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.

  • The Move or Copy dialog box will appear. Choose where the sheet will appear in theBefore sheet: field. In our example, we'll choose (move to end) to place the worksheet to the right of the existing worksheet.
  • Check the box next to Create a copy, then click OK.
  • To copy a worksheet: If you need to duplicate the content of one worksheet to another, Excel allows you to copy an existing worksheet.
  1. Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.
  2. The Move or Copy dialog box will appear. Choose where the sheet will appear in the Before sheet: field. In our example, we'll choose (move to end) to place the worksheet to the right of the existing worksheet.
  3. Check the box next to Create a copy, then click OK.
  • To move a worksheet: Sometimes you may want to move a worksheet to rearrange your workbook.
    • Select the worksheet you wish to move. The cursor will become a small worksheet icon.
    • Hold and drag the mouse until a small black arrow appears above the desired location.
  • To change the worksheet color: You can change a worksheet's color to help organize your worksheets and make your workbook easier to navigate.
    • Right-click the desired worksheet, and hover the mouse over Tab Color. The Color menu will appear.
    • Select the desired color. A live preview of the new worksheet color will appear as you hover the mouse over different options. In our example, we'll choose Red.
    • The worksheet color will be changed.

The Scrolling Buttons: These buttons scroll the display of sheet tabs one at a time or to display the first and last grouping of sheet
tabs and are located to the left of the sheet tabs


The Scroll Bars: Your spreadsheet may frequently have more data than you can see on the screen at once. Click, hold
and drag the vertical or horizontal scroll bar depending on what part of the page you want to see