Columns Problem?
in [General]
|
From: MrBill on 29 Apr 2010 12:47 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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.excel.misc
From: Luke M on 29 Apr 2010 13:29 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" <MrBill(a)discussions.microsoft.com> wrote in message news:1248EDB5-67A3-444E-A332-25C6ADD1A28A(a)microsoft.com... >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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.excel.misc
From: Gary Brown on 29 Apr 2010 13:47 Run this. It might help. The explanation is longer than the macro :O> ... '/=================================/ ' Sub Purpose: change all shapes to 'Move and Size' ' to stop error message when hiding columns. ' The 'Cannot shift objects off sheet.' error is usually ' caused by Comments that have the object positioning ' property set to 'Dont move or size with cells'. ' By changing this to 'xlMoveAndSize', columns/rows ' can be hidden without generating an error ' 'from MSKB article # 211769 'Cannot shift objects off sheet" error message when you hide ' columns in Excel ' ' http://support.microsoft.com/default.aspx?scid=kb;en-us;211769 '/=================================/ ' Public Sub Change_All_Shape_Properties2MoveAndSize() Dim shp As Shape On Error Resume Next For Each shp In ActiveSheet.Shapes shp.Placement = xlMoveAndSize Next shp End Sub '/=================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.excel.misc
From: Billns on 30 Apr 2010 19:51 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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.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
From: MrBill on 3 May 2010 20:17 thanks, that worked. did not think would find answer.. and took while to try, thought would be destructive by resizing (but did not change my comment sizes). "Gary Brown" wrote: > Run this. It might help. The explanation is longer than the macro :O> ... > > '/=================================/ > ' Sub Purpose: change all shapes to 'Move and Size' > ' to stop error message when hiding columns. > ' The 'Cannot shift objects off sheet.' error is usually > ' caused by Comments that have the object positioning > ' property set to 'Dont move or size with cells'. > ' By changing this to 'xlMoveAndSize', columns/rows > ' can be hidden without generating an error > ' > 'from MSKB article # 211769 > 'Cannot shift objects off sheet" error message when you hide > ' columns in Excel ' > ' http://support.microsoft.com/default.aspx?scid=kb;en-us;211769 > '/=================================/ > ' > Public Sub Change_All_Shape_Properties2MoveAndSize() > Dim shp As Shape > > On Error Resume Next > > For Each shp In ActiveSheet.Shapes > shp.Placement = xlMoveAndSize > Next shp > > End Sub > '/=================================/ > > -- > Hope this helps. > If it does, please click the Yes button. > Thanks in advance for your feedback. > Gary Brown > > > > "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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.excel.misc
|
Next
|
Last
Pages: 1 2 Prev: auto complete only for one row down? Next: Grouping difference between 2003 and 2007 |