Posted to microsoft.public.excel.worksheet.functions

CINDY

external usenet poster

Posts: 130

How can I HIDE a row if all cell values are zero?

I have hidden the zero values, but I would like to hide the entire row if all
cell values are 0. This keeps a list that is 25 lines long, visually, to say
3-4 lines long for printing.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Sumproduct issues	SteveDB1	Excel Worksheet Functions	25	June 3rd 09 04:58 PM
Using an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
How to take a cell that has 3 values and make 2 more new lines	Phil	Excel Worksheet Functions	4	October 23rd 05 10:53 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 04:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us