Condensing Rows Automatically
Hello all.
I'm trying to condense rows on an Excel sheet to remove blank lines. I need to to pull two columns worth of information from another sheet first, this will create some blank rows. After I pull these rows I want to remove the blank lines such that the page will print nicely. A problem I fear is that the page that contains the blanks lines uses formulas to pull the information. E.g. Bob 12 Sam 11 Ted 10 Sue 9 Red 8 Would become: Bob 12 Sam 11 Ted 10 Sue 9 Red 8 |
Condensing Rows Automatically
This may work for you...
Select all the cells, use edit/goto... click Special, click Formulas & OK, then Edit/Copy, then click somewhere (B1?) and press enter. You'll have all the data together as values & no blank rows. Bob Umlas Excel MVP " wrote in message ups.com... Hello all. I'm trying to condense rows on an Excel sheet to remove blank lines. I need to to pull two columns worth of information from another sheet first, this will create some blank rows. After I pull these rows I want to remove the blank lines such that the page will print nicely. A problem I fear is that the page that contains the blanks lines uses formulas to pull the information. E.g. Bob 12 Sam 11 Ted 10 Sue 9 Red 8 Would become: Bob 12 Sam 11 Ted 10 Sue 9 Red 8 |
Condensing Rows Automatically
Select the data
Data-Filter-AutoFilter Use the filter option (NonBlanks) This will hide all rows with a blank entry. " wrote: Hello all. I'm trying to condense rows on an Excel sheet to remove blank lines. I need to to pull two columns worth of information from another sheet first, this will create some blank rows. After I pull these rows I want to remove the blank lines such that the page will print nicely. A problem I fear is that the page that contains the blanks lines uses formulas to pull the information. E.g. Bob 12 Sam 11 Ted 10 Sue 9 Red 8 Would become: Bob 12 Sam 11 Ted 10 Sue 9 Red 8 |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com