| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Rows or Coloumns using formulas
Hi All
Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Rows or Coloumns using formulas
Well, the answer is NO - a formula cannot hide a row or a column.
Pete On Aug 7, 11:12*am, Milind Keer wrote: Hi All Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Rows or Coloumns using formulas
oooppppsss!!!
in dat case i guess i need to write macro... anywayz thanks pete!! cheers!! milind "Pete_UK" wrote: Well, the answer is NO - a formula cannot hide a row or a column. Pete On Aug 7, 11:12 am, Milind Keer wrote: Hi All Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Rows or Coloumns using formulas
Have you thought of using data|filter|autofilter (xl2003 menus)?
Milind Keer wrote: Hi All Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Rows or Coloumns using formulas
Use one worksheet per month?
Milind Keer wrote: Hi All Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Rows or Coloumns using formulas
not really... i wrote a macro...
"Dave Peterson" wrote: Have you thought of using data|filter|autofilter (xl2003 menus)? Milind Keer wrote: Hi All Is there any way to hide rows or coloumns using formulas E.g. I have a data for all 12 months and i want XL to display data for only selected month Like if i select Feb-08 it should display only Feb-08 data and should hide rest of the coloumns I dont want to manually hide my data or use outline view. Please advise Thanks and Regards Milind Keer -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data entered in each coloumns of one sheet to be extracted with r. | Excel Discussion (Misc queries) | |||
| unable to get expected results while anding two coloumns | Excel Discussion (Misc queries) | |||
| FILTER applied to many coloumns | Excel Discussion (Misc queries) | |||
| Text to Coloumns, by consecutive capital letters | Excel Worksheet Functions | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
![Milind Keer[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
