ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Columns Problem? (https://www.excelbanter.com/excel-discussion-misc-queries/262750-columns-problem.html)

mrbill

Columns Problem?
 
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

Luke M[_4_]

Columns Problem?
 
Make sure there isn't something in the last column (data, specific
formatting, etc). The easiest way is probably to select column IV, delete it
(not just clear contents) and then insert a column where desired.

--
Best Regards,

Luke M
"MrBill" wrote in message
...
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




Billns

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


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com