Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden
rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
In vwrsions earlier than 2007 Excel worksheets have 65536 rows.
No more, no less. You can hide the ones you don't want to see but you cannot get rid of them. To reduce your file size, select the row below your last data and SHIFT + End + DownArrow. EditDeleteEntire Rows. Same for columns to the right of your data. NOW IMPORTANT step..................Save the workbook. In some older versions of Excel you had to Save/Close and re-open. The rows and columns won't be gone, but they will be cleared and count nothing towards the file size. Gord Dibben MS Excel MVP On Sun, 27 Apr 2008 12:10:01 -0700, Raymond L wrote: My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
I thank Gord Dibben very much for his interest in solving a problem to a
fellow Microsoft Excel user. If I understood him well those rows with unuseful information contained in between rows of the sheet cannot deleted. Although it is very hard the hidden rows can be unhide and therefore deleted, it is a solution. What I wanted was a more practical way to do it. "Raymond L" wrote: My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
Think you could try copying only the visible rows over to a new sheet
(achieves the same purpose) Press F5 Special Visible Cells only Then right click to copy the selection In a new sheet, right-click on A1 Paste special values Delete the original sheet (optional) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Raymond L" wrote: My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
Just posted an alternative for you ..
----------- Think you could try copying only the visible rows over to a new sheet (achieves the same purpose) Press F5 Special Visible Cells only Then right click to copy the selection In a new sheet, right-click on A1 Paste special values Delete the original sheet (optional) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
Unhide the rows and delete them?
Tyro "Raymond L" wrote in message ... My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
I want to thank Max very very much for his response. It really worked and
save me a lot of hard working hours. That was amazing Max. Please pay attention, I will post another question, this time about a formula to manage a column data. "Raymond L" wrote: My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
Thank you Tyro. We need to keep trying to help others. Please read what Max
wrote. "Tyro" wrote: Unhide the rows and delete them? Tyro "Raymond L" wrote in message ... My excel spread sheet contains 20,000 (20K) rows, it is large. The hidden rows 18,500 (18.5K) I have no use for them. How can I get rid of them and have a document with useful information? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can hidden rows from an excel spreadsheet be deleted?
Welcome, Raymond. Glad it helped.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Raymond L" wrote in message ... I want to thank Max very very much for his response. It really worked and save me a lot of hard working hours. That was amazing Max. Please pay attention, I will post another question, this time about a formula to manage a column data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows in a spreadsheet, but I don't want to count hidden r | Excel Discussion (Misc queries) | |||
Emailing Spreadsheet with Hidden Rows | Excel Discussion (Misc queries) | |||
Protecting only Hidden Rows on a Spreadsheet | Excel Worksheet Functions | |||
I deleted information in an Excel spreadsheet and need to recover | Excel Discussion (Misc queries) | |||
Hidden rows automatically unhide when I open Excel Spreadsheet. | Excel Discussion (Misc queries) |