View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default reduce excel file size by deleting blank rows and columns??

After the delete, you'll need to save, then close & reopen the spreadsheet.
--
David Biddulph

Delta007bhd wrote:
Hi,

I have a 34MB excel file. How can I reduce the size of it? I have
blank rows from row 110-65536 and blank columns from col V-IV which I
want to delete. I tried selecting the last row, then CTRL+SHIFT
+DOWNARROW followed by DEL but it doesn't seem to work since the
scroll bar at the right is still tiny which means that there are
endless rows below. Why can't I simply delete them? Do I need a
retinal scan from the president??

Thanks in advance for your help