Hi Zygy,

Selecting the whole worksheet can be done in a couple of ways:
* Click the grey square which appears at the intersection of the row &
column headers at the top left of the screen, or
* select any cell and press [ctrl + a] (hold the control key & press
the letter A).

You can then apply the formatting as you normally would.

However, this may lead to quite an increase in your file size. My
preferred option is to just apply the formatting to the used range (but
this may be a nusiance if you are regularly adding more data to the
bottom/side of your spreadsheet. To just apply the formatting to the
used range press:
[ctrl + home], then press [ctrl + shift + end], and apply the
formatting.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=537119