Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default CANNOT SHIFT OBJECTS IN SHEET

hi, I have been able to work around problem in past.
where I have many columns: thru IL (of IV) 10 cols left.

I have been able to insert columns with as little as 5 cols left.
1 trick I used was to increase the column width of the empty columns to the
right.

this seemed to allow space for adding/ inserting cols.
I cannot seem to delete a single, or multiple empty columns, to simulate the
same thing.

is there a way to zero some setting out. had col at width 250, 255 worked,
20 does not. reduce 1 col to smallest 180 seems to work. a second col to
250 does not. - deleting 180 col does not work.

changing the last 10 columns in use to: 100 seems to allow to insert a
column, but now I am stuck with a mess at the end of my sheet.

Is there some terminator or setting that needs to be fixed?
thanks.
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
cannot shift objects off sheet abubakr kamal Excel Discussion (Misc queries) 1 May 4th 09 05:29 PM
Cannot shift objects off sheet kurlisue Excel Discussion (Misc queries) 7 August 19th 08 10:38 AM
Cannot shift objects off sheet? Al Excel Discussion (Misc queries) 2 June 11th 08 03:44 PM
Cannot shift objects off sheet Seltz Excel Worksheet Functions 2 March 18th 08 01:03 PM
Cannot Shift Objects off sheet Norman Jones Excel Worksheet Functions 0 January 26th 06 12:45 AM


All times are GMT +1. The time now is 03:26 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"