View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Format data Sheet size?

Not got 2007, but does this actually remove the columns ?
Are you saying when you open it afterwards it actually has less the the
default columns/rows ?

On Sun, 23 Jul 2006 23:04:11 +0100, Alan wrote:

Not sure about Excel 2007 but try hitting Ctrl and End to find the last
used
cell. then delete (not clear contents, delete) all the columns to the
right
of the last used column and all the rows below the last used row. Save,
exit
and re-open,
Regards,
Alan.
"pippin" wrote in message
...
I am working in Excel 2007 (beta)
I have created my sheet and was able to remove sheets 2 & 3 which I
don't
need.
I would like to trim the size of the sheet and only print the contents
of
my
data but do not know how to remove the excess columns/rows which mae up
a
full Excel sheet.
Is there a way of saving my sheet with only the cells I have data in
compacting my sheet for future reference without the extra cells?






--
Steve (3)