| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide column and show only in row in use
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide column and show only in row in use
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
| hide column and rows | Excel Discussion (Misc queries) | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
| hide column but show chart | Charts and Charting in Excel | |||
Hybrid Mode
