Donate SIGN UP

Where Is It?

Avatar Image
lynbrown | 17:44 Tue 22nd Jul 2014 | Technology
6 Answers
I am putting together spreadsheet for first time in years. How do I shade the different columns in different shades of grey?
Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by lynbrown. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
You've not told us which program you're using, so I'll have to assume that it's Excel.

See here:
http://office.microsoft.com/en-gb/excel-help/apply-or-remove-cell-shading-HP005202607.aspx
Hiya, Highlight the section you want, then at the top toolbar there is a 'Bucket' symbol which looks like it is tipping. Click on this, select your colour & hey presto :o)
You're looking for the "format cell" edit menu option.
What version of office?

Latter version then the option to format as a table will be your friend...
I highlight the column of cells, then click on the Theme Colour button (on my version of Excel) and click on the one I want.
Question Author
thanks all, as ever, very helpful

1 to 6 of 6rss feed

Do you know the answer?

Where Is It?

Answer Question >>