Versions Compared

Old Version 20

changes.mady.by.user Daniel LaGrow

Saved on

compared with

New Version 21

changes.mady.by.user Daniel LaGrow

Saved on

Key

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

...

The names of Cells in Excel make it easier to understand the purpose of the cell. It also helps with navigating the workbook.

To name your table,

  1. Highlight your full table.

    A table called Sales Totals fully highlighted.Image Added

  2. Go to the Table Design Tab.

    The Table Design tab in Microsoft ExcelImage Added

  3. In the Table Name box, type in the name of your table. Make sure the table name starts with a letter or underscore, does not include a space or character that is not allowed or conflict with an existing name.

    The Table Name box with the name SalesTotals.Image Added
Warning

The name of the current cell selected is A2. To make things easier for readers, we should change the name of the cell to the information within the cell.

Sales Totals table with Month and Year header highlighted. The cell name is A2.Image RemovedA table with no name.Image Added
Tip

Now the table has its name.

Sales Totals Table named Sales_Totals_2018_TableImage RemovedA table named SalesTotals.Image Added

Section 10.7: Protecting and Locking

...