You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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 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.

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.

Underneath each worksheet titles, in B1, write 'This worksheet contains one table'.



  • No labels