View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
beata beata is offline
external usenet poster
 
Posts: 19
Default Deleting rows to resize workspace

Hi. I'm using a workbook that someone else created from a download. It has
23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it
appear that it's only 10% from the top.
In the past I've deleted all of the rows - going down to the full million -
and then gone back to A1 and hit "save". Usually that refreshes the space.
It's not working. I can delete them. And go to A1 and save - even tried
resaving with another name.. but it (Excel) still thinks it's bigger than it
is. Any ideas?