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?

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?

On Jan 20, 10:59*am, 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?

Use a list instead, unless you are using 2007 then you woudl use a
table. Both are done the same way. Highlight the information that
you want and then click Ctrl + L. this will put your information into
a list and at the top of each column will be a heading. You can use
the pull down and tell it to only show blanks. This was not available
earlier than 2003.

Jay

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?

On Jan 20, 11:27*am, spaanstb
wrote:
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?- Hide quoted text -

- Show quoted text -

Check out teh List. Ctrl + L. You can tell it to show only blanks
for each column.