Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
Whenever a colleague updates a spreadsheet I've created it comes back
10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
Selecting all the rows below your actual data. Right-click, delete cells.
(this is different than simply pressing the delete key). Save your workbook. This should reset the used range of your worksheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ICTag" wrote: Whenever a colleague updates a spreadsheet I've created it comes back 10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
Many thanks. This certainly helped. There's no "delete cells" menu but the "delete" in the context menu reduced the size from 8MB to 1.5MB. There are still over 65000 empty rows but when I tried repeating the operation it didn't reduce the size any further. "Luke M" wrote: Selecting all the rows below your actual data. Right-click, delete cells. (this is different than simply pressing the delete key). Save your workbook. This should reset the used range of your worksheet. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ICTag" wrote: Whenever a colleague updates a spreadsheet I've created it comes back 10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
ICTag wrote:
Whenever a colleague updates a spreadsheet I've created it comes back 10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom What is your colleague doing to update the sheet? I would suggest going through his update process step by step (saving and checking size at each step) to see where the extra rows are being created. If you can't figure it out then post the process here and maybe someone can spot the error. gls858 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
Hi,
1. Click the first row number you want removed 2. Press Shift+Ctrl+Down Arrow 3. Press Ctrl+- (control minus) I would also consider doing this for columns, in which case step 2 would be Ctrl+Shift+Right Arrow All worksheets in 2003 and earlier contain 65,536 rows and 256 columns whether they have anything in them or not. The menu command for Deleting rows or columns is Edti, Delete (not Edit, Clear,...) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ICTag" wrote: Whenever a colleague updates a spreadsheet I've created it comes back 10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 - deleting trailing empty rows
Thanks Shane.
That's a cool way of selecting the lines but it doesn't shrink after deleting. I'll have to find our what he does. Tom "Shane Devenshire" wrote: Hi, 1. Click the first row number you want removed 2. Press Shift+Ctrl+Down Arrow 3. Press Ctrl+- (control minus) I would also consider doing this for columns, in which case step 2 would be Ctrl+Shift+Right Arrow All worksheets in 2003 and earlier contain 65,536 rows and 256 columns whether they have anything in them or not. The menu command for Deleting rows or columns is Edti, Delete (not Edit, Clear,...) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ICTag" wrote: Whenever a colleague updates a spreadsheet I've created it comes back 10MBytes large whereas it was originally only 50KBytes. It looks to me as if the colleague accidentally adds tens or hundreds of thousands of empty rows. How can I delete all rows below a certain row. Delete does not work. Copying the real rows into a new worksheet loses the formatting. When I apply the formatting from the big spreadsheet (paste formatting) I end up with hundreds of thousands of rows again :-( Any suggestions? Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting empty rows | New Users to Excel | |||
Deleting Rows Between Empty Cells | Excel Worksheet Functions | |||
deleting empty rows | Excel Discussion (Misc queries) | |||
Deleting All Empty Rows | Excel Discussion (Misc queries) | |||
Deleting unwanted and empty rows... | Excel Discussion (Misc queries) |