Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print problem with columns | New Users to Excel | |||
Problem in hiding columns | Excel Discussion (Misc queries) | |||
Text to Columns Problem | Excel Discussion (Misc queries) | |||
Excel Columns Problem | New Users to Excel | |||
Problem with Grouping Columns | Excel Discussion (Misc queries) |