Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dford
 
Posts: n/a
Default Hide rows if cells = 0.00

I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell
in column D = 0.00 than hide the row containing that cell.
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Hide rows if cells = 0.00

Highlight your data, then from the menu bar select Data Filter
Autofilter. Select the drop-down in column D and choose Custom. Use the
drop-downs to set your selection to read 'does not equal' '0.00', then click
OK. Those rows with 0.00 in column D should now be filtered out (they're
still in your data, just not visible).
--Bruce

"dford" wrote:

I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell
in column D = 0.00 than hide the row containing that cell.

  #3   Report Post  
Posted to microsoft.public.excel.misc
dford
 
Posts: n/a
Default Hide rows if cells = 0.00

Thanks Bruce. That is what I was looking for.

"bpeltzer" wrote:

Highlight your data, then from the menu bar select Data Filter
Autofilter. Select the drop-down in column D and choose Custom. Use the
drop-downs to set your selection to read 'does not equal' '0.00', then click
OK. Those rows with 0.00 in column D should now be filtered out (they're
still in your data, just not visible).
--Bruce

"dford" wrote:

I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell
in column D = 0.00 than hide the row containing that cell.

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
macro to hide rows across several worksheets fails SandyR Excel Discussion (Misc queries) 5 October 3rd 05 09:04 PM
macro to hide rows if cell is blank Shooter Excel Worksheet Functions 3 September 28th 05 10:55 PM
Want to auto hide rows in excel when no data in a certain column. Tim Excel Discussion (Misc queries) 3 June 30th 05 12:52 AM
can you hide rows with a formula? david Excel Discussion (Misc queries) 2 April 8th 05 03:21 PM
How to determine which rows contain slected cells in a multiple c. Paul Excel Worksheet Functions 2 April 5th 05 05:07 PM


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

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

About Us

"It's about Microsoft Excel"