Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Louise
 
Posts: n/a
Default In Excel is it possible to hide a row condtional upon a cell val..

In Excel is it possible to hide a row condtional upon a cell value?
  #2   Report Post  
paul
 
Posts: n/a
Default

with a macro yes,or you could format white text and all values would disapear.
--
paul
remove nospam for email addy!



"Louise" wrote:

In Excel is it possible to hide a row condtional upon a cell value?

  #3   Report Post  
Bob the Builder
 
Posts: n/a
Default

The white text makes the text disappear, but not the entire row or column of
cells. With a macro, is it possible to make the cells automatically unhide
then if the data becomes relevant again due to changes?

"paul" wrote:

with a macro yes,or you could format white text and all values would disapear.
--
paul
remove nospam for email addy!



"Louise" wrote:

In Excel is it possible to hide a row condtional upon a cell value?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Excel 2003 Hide PivotItems Lee Excel Worksheet Functions 1 January 21st 05 08:41 PM
Excel - hide erroer values Kathrine J Wathne Excel Discussion (Misc queries) 1 January 10th 05 10:13 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"