Hi Kylie,
Set up your page with the appropriate columns hidden then press
[alt+v+v] & [add] to set up a custom view eg "what I want to see"
(details in Excel help). I also set up one with nothing hidden which I
refer to as "show all info", & this allows for quick flicking b/n 2 or
more views.

The macro provided at the link below won't help your page look "less
busy" but it will draw your attention to the row you are on by
highlighting it yellow & could be adapted for highlighting columns.
http://www.mcgimpsey.com/excel/highl...iteRetainColor

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=502782