I only want to hide certain columns and then only show the cells in the
column when I use that particular row to avoid the page looking busy, help!
I only want to hide certain columns and then only show the cells in the
column when I use that particular row to avoid the page looking busy, help!
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks