| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I hide rows in Excel 2002 using a formula in a cell?
Hello, I would like to know whether it is possible to hide either rows or
columns by writing a command in a cell? Overall, I would like rows and columns to be created, deleted, or hidden under specific conditions. Is this possible? If so, how? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I hide rows in Excel 2002 using a formula in a cell?
Not using formulas.
But maybe using macros and worksheet events. Marc wrote: Hello, I would like to know whether it is possible to hide either rows or columns by writing a command in a cell? Overall, I would like rows and columns to be created, deleted, or hidden under specific conditions. Is this possible? If so, how? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I hide rows in Excel 2002 using a formula in a cell?
Thanks Dave
"Dave Peterson" wrote:chrome://ietab/content/reloaded.html?url= Not using formulas. But maybe using macros and worksheet events. Marc wrote: Hello, I would like to know whether it is possible to hide either rows or columns by writing a command in a cell? Overall, I would like rows and columns to be created, deleted, or hidden under specific conditions. Is this possible? If so, how? Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I hide rows in Excel 2002 using a formula in a cell?
You can change the FORMAT of any cell or groupl of cells by referring
to a formula or condition in other cells with ConditionalFormatting. You can "hide" the contents of the cells by changing the font color to white, or the "Pattern" to match the font color, or just Black. You can apply the formatting to the entire row or column. ed |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I hide rows in Excel 2002 using a formula in a cell?
You can change the FORMAT of any cell or groupl of cells by referring
to a formula or condition in other cells with ConditionalFormatting. You can "hide" the contents of the cells by changing the font color to white, or the "Pattern" to match the font color, or just Black. You can apply the formatting to the entire row or column. ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
