| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically hide empty columns in Excel?
I have a spreadsheet which is prepared each month with approximately 167
columns, importing data from our application's database. Each month, a large number of the columns of the spreadsheet contain no data, so other than the column heading row, there is no data in the column. However, all columns are necessary, as there may be data for any given month. Is there a way to set up the spreadsheet to automatically hide the columns that contain NO data, so only those columns containing data appear (making the spreadsheet more user friendly)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically hide columns? | Excel Discussion (Misc queries) | |||
| Hide empty rows in pivot table Excel 2003 | Excel Discussion (Misc queries) | |||
| Automatically hide/unhide columns | Excel Discussion (Misc queries) | |||
| Is there a way to automatically hide empty rows? | Excel Worksheet Functions | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Threaded Mode
