Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Right click your worksheet tab at the bottom of the screen.

    There are three worksheet labels with the Income Worksheet highlighted in green.Image RemovedThere are three worksheet labels with the Income Worksheet highlighted in green.Image Added
  2. In the pop-up menu click Delete. The spreadsheet is gone.

    Expenses to the left and the highlighted sheet Income to the right.Image Modified

Section 2.4: Removing and Marking Blanks

When creating a spreadsheet, it is best to avoid blank rows, columns, and cells. Screen readers may think a blank cell is the end of the table or spreadsheets and skip important information. A good way to avoid this is to include information in all necessary cells and to leave a single blank row between tables. A good way to clear unneeded rows and columns is to delete them.

  1. Create two tables

    Two tables about the population of countries. The top 5 biggest counties are at the top, the top 5 smallest countries are at the bottom.Image Modified
  2. Click the numbers of the rows you want to delete.

    Rows 8 and 9 are highlighted.Image Modified
  3. Right click, select delete rows or columns. Now you have a much more organized spreadsheet.

    Two tables on country population with only one row of separation between them.Image Modified

For tables that have blanks in them, just type in simple words or abbreviations. Examples of these include, N/A, or “No Data.”

...

  1. Create a blank spreadsheet in Excel.

  2. Add a few more spread sheets by clicking the plus symbol at the bottom of the screen. Name the first sheet “Index”, then give appropriate names to the rest of the spreadsheets.

    The Worksheet section of Excel with Worksheets named Index, January, February, and March.
  3. In the Index Spreadsheet, type in the names of your spreadsheets. One name per cell.

    The Index Spreadsheet with the names of each spreadsheet in their own cell.Image Modified
  4. Right click your first spreadsheet name. In the dropdown menu, click Link. In the Insert Hyperlink box, click “Place in This Document”. Click the name of the spreadsheet you want the link to connect to. It is possible that your Text to Display may have a syntax code in it. Delete it and type in a name that suits your spreadsheet. Click OK.

    Insert Hyperlink box with the text to display as January. Link to is Place in this Document.
  5. Your link is made. Click on it and you will be taken to the spreadsheet it is linked to.

...