Hide rows function
 

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 rows function
 

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 rows function
 

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

Hide rows function
 

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 rows function
 

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.