MS Excel Chapter 4: Tables
- Daniel LaGrow
- 1 Instructions
- 1.1 Section 4.1: Table Formats
- 1.1.1 Rule 1: Every table should have a clear title.
- 1.1.2 Rule 2: There Should Only be One table Per Worksheet
- 1.1.3 Rule 3: If Multiple Tables are Placed in the Same Worksheet, There Should Only be One Row of Separation.
- 1.1.4 Rule 4: All Tables Must Have Headers, and Must Have Meaningful Names
- 1.1.5 Rule 5: Each Table Can Only Have One Header Row and/or One Header Column
- 1.1.6 Rule 6: Complex Tables Must be Broken Down into Simple Tables
- 1.1.7 Rule 7: Table Headers and the Data Itself Must Not be Separated by Blank Rows or Columns
- 1.1.8 Rule 8: No Merged Cells. Instead, Write the Same Data in Multiple Cells.
- 1.1.9 Rule 9: If Conditional Formatting is Used, the Same Information Must be Available to Read in Text Format.
- 1.1 Section 4.1: Table Formats
- 2 Related articles
Instructions
Section 4.1: Table Formats
When creating a table in Microsoft Excel, you always want to be sure that your table has a clean format. A clean format shows that the data is organized, easy to read, and easy to understand.
To create a standard table format, highlight the rows and columns you want formatted into a table.
Go to the Insert Tab and click the Table Button.
In the Create Table Box, click “My Table has Headers”, then click OK. Your standard table will be created. You can expand it or shrink it as much as you want. Also, you can write out the text in each cell then format it as a table by doing the same steps.
Rule 1: Every table should have a clear title.
This table has no title. Anyone who reads this table will want to know that the table is about. While the data will help give hints, it simply is not enough. Always include a title.
A title is included above the table. All readers will now know what the table and data is about.
Rule 2: There Should Only be One table Per Worksheet
This spreadsheet has two tables. This is unnecessary, and one of these tables has to be moved to another spreadsheet. Seeing two tables would confuse the screen readers in how to give the information to the readers.