View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jac Tremblay[_3_] Jac Tremblay[_3_] is offline
external usenet poster
 
Posts: 30
Default Last cell problem

Hi everyone,

I'm trying to make a workbook smaller by deleting all the rows and columns
that do not really contain data. I use Ctrl + End to go to the last cell and
then delete all the empty rows and columns making sure I select them by
clicking on the number or letter that identify them. Then, I save the
workbook and check if it worked. Normally, it works fine but I found some
worksheets that do not want to obey...

In one sheet, the last cell is J50 (let's say). All the columns to the right
of J have been masked (width = 0 from column K to IV). When I display the
columns to the right, the last cell is IV50. If I delete all those columns
(from K to IV) in the same manner, the last cell remains the same, IV50.

What could be the problem with that sheet?

Thanks to anyone who can help.
--
Jac Tremblay