Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
condensing an email list | Excel Discussion (Misc queries) | |||
Condensing Formula | Excel Discussion (Misc queries) | |||
Condensing my worksheet | Excel Worksheet Functions | |||
Condensing lists | Excel Worksheet Functions | |||
condensing information onto one worksheet | Excel Worksheet Functions |