Hi all,
My spreadsheet is too big for my data and i would like to remove all columns after the last column used and all rows beneath the last row used.
Having tried many of the suggestions that have been previously recorded in this and other forums, I'm at a loose end.
I have made sure that there are no cells with data in the area I am trying to delete.
I am only learning hands on and would normally try to work it out myself but hours of trying have not prevailed........Help.
You cannot just remove unused rows/columns. The size of worksheet is always the same. but if they are empty (no data, no formatting) they shall not influence the size of your workbook on disk.
You could (if you wish have a limited fragment of worksheet visible) just hide all unwanted rows/columns. See attached workbook which has sheet1 being just 20rows x 8columns. But of course it's normal sheet with just most columns and rows hidden. Is it the effect you are looking for?
Best Regards,
Kaper
Hi and thx for such a quick reply.
If having completed your suggestion, can I then zoom in so that the part with data on can be full screen. If yes, then it fits my requirements exactly. if not its much closer to what I want.
Regards John
As for zooming in - you can select all cells, and use "Zoom to selection" action from: ribbon "View", group "Zoom".
many thanks, most helpful.
Glad to hear so
and thanks for reputation.
Would be a good idea to mark thread as Solved. Above your first post you will find Thread Tools to do it.
Remove Columns or Rows
To do so, select the rows or columns you wish to delete using your mouse. Then, click the "Home" tab in the ribbon menu and click "Insert." Click "Delete Sheet Rows" to delete a set of selected rows or "Delete Sheet Columns" to delete a set of columns.
Regards,
Tony
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks