Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell problem Techman Excel Discussion (Misc queries) 1 August 26th 08 07:14 PM
Cell Underline problem underlines across width of cell tshoop7 Excel Worksheet Functions 1 July 24th 08 12:18 AM
Very Basic Problem - Merged Cell Equals Contents of a Single Cell jollynicechap Excel Worksheet Functions 3 December 29th 06 08:16 PM
Cell problem Patrick Excel Worksheet Functions 3 March 29th 05 03:33 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. [email protected] Excel Worksheet Functions 2 December 11th 04 12:05 AM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"