First check
When you get a spreadsheet, open and check the following:
Control + G to see if
Check:
No empty rows or columns.
All text Arial 12pt except for headings and subheadings (Arial 16 bold
All tables are marked up (except pivot tables).
Control G to check all tables have meaningful names
If not, mark up all tables (highight If no, go through every table, mark them up and give them table names - highlight table, control + T, OK, use Table design to remove colour and on Data tab remove filters)
Give tables meaningful names by cutting and pasting table titles into Word and replacing gaps with underscores.
Make all text on all worksheets Arial heading 1.
Format heading 1, heading 2 and Normal style.
If there are any merged cells remove them using strategies listed here
As you go:
- left align first column and right align all the other columns, including the heading text
- ensure large numbers have thousands comma
Redo control + G to check the tables are all marked up and named.
Note: I don't think pivot tables can be marked up.
Then -
Cosmetic changes
Every sheet must have a title Name every worksheet in heading 1 in cell A1. Sub-headings in heading 2. Text in Normal.
Drag lines (and bottom align text) to create space.
...
.
In cell A2 put the stock phrase 'This worksheet contains one table'.
Front page – probably doesn't have a table but might have lots of text.
Any other headings are heading 2 and space created by dragging cell border lines.
Normal text is arial 12pt.
Remove all empty rows or columns.
Remove white background fill or boxes.
Apply GDS style, namely spell out acronyms on first appearance, spell out abbreviations, remove unnecessary bold. Italics can stay for species names.
Final review
Control + G again.
Use Control + Page down to scroll through the spreadsheet checking that:
- cursor is in cell A1 on every worksheet
- cell A2 reads 'This worksheet contains one table'
...
- no empty rows or columns
- table separated from text above by dragging cell border down a little
- column headers in bold
- data columns are all right aligned