|
cannot shift objects off sheet
I tried all the suggestions already posted but still get the error 'cannot
shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? |
Including this one?
http://support.microsoft.com?kbid=170081 XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns -- HTH RP (remove nothere from the email address if mailing direct) "AAA" wrote in message ... I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? |
Yes, I tried that one. I don't have any comments...don't think that is the
issue "Bob Phillips" wrote: Including this one? http://support.microsoft.com?kbid=170081 XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns -- HTH RP (remove nothere from the email address if mailing direct) "AAA" wrote in message ... I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? |
If you press Ctrl+End, what cell is selected? Way past the cells that
contain data? If you reset the used range, it may solve the problem. There are instructions he http://www.contextures.com/xlfaqApp.html#Unused AAA wrote: I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thanks Debra but I already tried that. Ctrl+End takes me to the last cell
with data in it, but I still get the error "Debra Dalgleish" wrote: If you press Ctrl+End, what cell is selected? Way past the cells that contain data? If you reset the used range, it may solve the problem. There are instructions he http://www.contextures.com/xlfaqApp.html#Unused AAA wrote: I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Perhaps William's suggestion in the following posting will help:
http://groups.google.ca/groups?hl=en...%40tkmsftngp09 He wrote: '======================= "if you have a button on your worksheet, right click on the button, select "Format Control", select "Properties" and then select "Move and Size with cells" '======================== AAA wrote: Thanks Debra but I already tried that. Ctrl+End takes me to the last cell with data in it, but I still get the error "Debra Dalgleish" wrote: If you press Ctrl+End, what cell is selected? Way past the cells that contain data? If you reset the used range, it may solve the problem. There are instructions he http://www.contextures.com/xlfaqApp.html#Unused AAA wrote: I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
there appears to be some maximum # of cells that can be hidden...anyone know
if this is true "AAA" wrote: Thanks Debra but I already tried that. Ctrl+End takes me to the last cell with data in it, but I still get the error "Debra Dalgleish" wrote: If you press Ctrl+End, what cell is selected? Way past the cells that contain data? If you reset the used range, it may solve the problem. There are instructions he http://www.contextures.com/xlfaqApp.html#Unused AAA wrote: I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thanks but that doesn't help either...
"Debra Dalgleish" wrote: Perhaps William's suggestion in the following posting will help: http://groups.google.ca/groups?hl=en...%40tkmsftngp09 He wrote: '======================= "if you have a button on your worksheet, right click on the button, select "Format Control", select "Properties" and then select "Move and Size with cells" '======================== AAA wrote: Thanks Debra but I already tried that. Ctrl+End takes me to the last cell with data in it, but I still get the error "Debra Dalgleish" wrote: If you press Ctrl+End, what cell is selected? Way past the cells that contain data? If you reset the used range, it may solve the problem. There are instructions he http://www.contextures.com/xlfaqApp.html#Unused AAA wrote: I tried all the suggestions already posted but still get the error 'cannot shift objects off sheet', when I tried to hide one of my columns. Anyone know any workarounds? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com