How do I delete columns and rows in Excel, not just hide them
Eddie,
A worksheet has, and always has, 256 columns, 65536 rows. So, if you delete
any columns or rows, empty ones get tagged on the end to replace the deleted
ones.
In summary, you cannot reduce file size in that way. It doesn't really
matter though, because as I understand it, Excel keeps pointers to the data,
and only stores that. What you see is just presentation, it doesn't store
thousands of empty cells with the workbook.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Eddie" wrote in message
...
I'm trying to use excel to annotate images (by inserting the image as the
background and then using the comment tool). However, this causes the
image
to tile endlessly and although I can hide the unwanted rows and columns,
I'm
still left with a huge file size. There doesn't seem to be any way of
deleting the unwanted columns to reduce the file size... is there?
|