![]() |
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 |
All times are GMT +1. The time now is 02:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com