Hide rows function

S

spaanstb

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?
 
M

Ms-Exl-Learner

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+G>>Special>>Blanks>>Ok. Now the blank cells will be getting selected.

Excel 2003
Format>>Row>>H

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!
 
J

jlclyde

I have a spreadsheet with a lot of formatting that I want to hide rows ifthe
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
 
S

spaanstb

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?
 
J

jlclyde

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?









- Show quoted text -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top