View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Billns Billns is offline
external usenet poster
 
Posts: 84
Default Columns Problem?

On 4/29/2010 9:47 AM, MrBill wrote:
I have made use of most all of the columns available thru IV, minus aprox 10
cols.

with minus 5 cols, at one time was able to expand 1 column size (to trick
xl? column space available so I can: cut / past / insert columns).

Error getting: cannot shift objects off sheet.
I now have difficulty inserting, etc. with 15 cols expanded / cannot reduce
size of columns. (turning into a mess)

is it some kind of terminator problem where number vs size of columns, can
be fixed? thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


One approach is to upgrade to Excel 2007 which has many more columns
available.

Another approach is to consider redesign of your spreadsheet so that you
are not always bumping into column IV. Put some of your information on a
second or third worksheet in the same workbook.

I try to keep my worksheets completely visible in one window or at least
only need to scroll down.

Bill