Monday, February 14, 2005

More formatting tricks in Excel

I like to use a soft gray colour for borders around cells that need to be boxed. Eg a table.
First I turn the view gridlines off (Tools | Options).
Then I select the area to be boxed.
Then I use Format | Cells | Borders and select the grey colour, select the line weight and then click Inside and Outside.
After clicking OK I can then use the format painter to copy this selection anywhere else its needed.
Now I can use the black colour to create contrasting underlines where needed.

Example in the picture.