![]() |
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 |
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 |
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