Simple Sales Ledger in Excel III

To finish off this simple spreadsheet, it might be helpful to make it look slightly more presentable.Select Row 1 (by clicking on the 1) and then bring up the Format Cells dialog box (either by Menu|Format, keyboard shortcut or right mouse button menu) and then you can make the text bold (Font tab), colour in the background (Patterns tab), select borders (Borders tab) or alternatively using the icons shortcuts (on the toolbar menu) or by using keyboard shortcuts.

So, for example:

  • To make the font bold, by highlighting the entire row, selecting (Menu|Format|Cells) and the font tab and selecting Bold in the font style
  • To make give the cells a firm outline (or border), click on the Border tab and then click on both the outside and inside presets near the top
  • To shade the cells, click on the Patterns tab and then click on the colour of your choice from the color section near the top.

Also, adjust the column widths to suit.  This can be done by selecting the column and then choosing Menu|Format|Column|Width and adjusting the number in the little dialog box.  You could also choose the auto-fit selection.

You might also wish to “wrap” the text, if you want narrower columns.  Do this by highlighting Row A selecting (Menu|Format|Cells) and the Alignment tab and check the wrap text box.  Doing this will enable you to make columns narrower whilst still enabling you to read the column title.  (Probably especially relevant for columns B, G, H, I and J)

Finally, freeze the top row to make the spreadsheet easier to use once there’s a lot of entries on it, by:

  • select cell A2
  • from the menu bar: menu|window|freeze panes

Or to freeze the top row and the first two columns, instead of just the top row:

  • select cell C2
  • from the menu bar: menu|window|freeze panes

As with the Simple Purchase Ledger in Excel, none of the formatting is essential; the spreadsheet will work just as well without, it just makes the spreadsheet easier to use.


Comments are closed.