Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING A HUGE AMOUNT OF BLANKS ROWS
I tried to use "F5, Special, Blank, okay, Edit, Delete, Entire Row" but it
tells me " Selection to large" and stops. With the blank rows going every other one, the file is 15850 rows long, only 3 columns wide. Is there a formula that will handle such a large amount of rows? mePenny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING A HUGE AMOUNT OF BLANKS ROWS
Seems easiest to just highlight the workbook and sort by a column. Then,
blank rows would be at bottom and you can delete in one fell swoop. Is that an optin for you? "mePenny" wrote: I tried to use "F5, Special, Blank, okay, Edit, Delete, Entire Row" but it tells me " Selection to large" and stops. With the blank rows going every other one, the file is 15850 rows long, only 3 columns wide. Is there a formula that will handle such a large amount of rows? mePenny |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING A HUGE AMOUNT OF BLANKS ROWS
Sean,
You've made my afternoon, thank you kindly.. I've gone from 15850 to 2746. mePenny "Sean Timmons" wrote: Seems easiest to just highlight the workbook and sort by a column. Then, blank rows would be at bottom and you can delete in one fell swoop. Is that an optin for you? "mePenny" wrote: I tried to use "F5, Special, Blank, okay, Edit, Delete, Entire Row" but it tells me " Selection to large" and stops. With the blank rows going every other one, the file is 15850 rows long, only 3 columns wide. Is there a formula that will handle such a large amount of rows? mePenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing blanks | Excel Discussion (Misc queries) | |||
Removing Blanks | Excel Worksheet Functions | |||
Removing Blanks | Excel Worksheet Functions | |||
Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) | |||
huge amount of text in merge cell - want undone! | Excel Discussion (Misc queries) |