I should have been more clear the data looks like the following:

A B C D E
1 2 3 4 5
2 3 3 4 6
4 6 2
2 4 6

I want to hide the entire row if the cell in column A is blank. So if A is
blank I want to hide the whole row even though there is data in columns B
through E. So in my above example I would like to hide all of the rows
except for the top 2, but there are sections of data througout the spreasheet
similar to this so I can not use the filter function as I will lose all of my
formatting. Any suggestions?

"Ms-Exl-Learner" wrote:

Place the cursor in the column which is having the blank cells and data. Now
select the range of data and blank cells and press
Cntrl+GSpecialBlanksOk. Now the blank cells will be getting selected.

Excel 2003
FormatRowH

The below mentioned Keyboard shortcut is common for 2003 & 2007:-
Alt+O+R+H

Now the selected blank cells row will be hidden.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"spaanstb" wrote:

I have a spreadsheet with a lot of formatting that I want to hide rows if the
value is blank in certain sections. I can not us a filter on the worksheet
because there is a lot of formatting that I do not want to lose. If I filter
out the blanks all my formatting is lost. Is there a function that I can
apply to ranges of rows in a spreadsheet to hide if a value comes up blank?
There are approximately 12 different ranges that I want to run this function
and the filter fuction only lets me filter 1 section in a spreadsheet. Any
suggestions?