Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell problem | Excel Discussion (Misc queries) | |||
Cell Underline problem underlines across width of cell | Excel Worksheet Functions | |||
Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
Cell problem | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |