| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding/Unhiding Columns
My spreadsheet has numerous sections all with period numbers 1-12 showing in
columns on line 6. Line 6 also contains some blank cells and text cells. Cell D1 contains the current period number. I want to be able to hide any columns where the number in line 6 is greater than the value in cell D1 ie if D1 is 4, then any columns in the spreadsheet that contain a number greater than 4 in line 6 would be hidden. Can anyone help please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
