| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can not insert Columns
I get this message when I try to insert a column anywhere in my excel sheet.
Screen shot : http://img40.imageshack.us/img40/8320/52370335.png Why is that? There is no data in the last column i still have a lot of columns left and they are empty. Could it be because of froozen cells on top? Thank You, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can not insert Columns
hi
excel has lost it's reference to used range. this happens now and then and is easy to reset. see this site http://www.contextures.com/xlfaqApp.html#Unused note that is some of the older versions of excel, you may have to close excel for the new setting to take. Regards FSt1 "Damian" wrote: I get this message when I try to insert a column anywhere in my excel sheet. Screen shot : http://img40.imageshack.us/img40/8320/52370335.png Why is that? There is no data in the last column i still have a lot of columns left and they are empty. Could it be because of froozen cells on top? Thank You, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can not insert Columns
Great. Thank You. It worked.
"FSt1" wrote: hi excel has lost it's reference to used range. this happens now and then and is easy to reset. see this site http://www.contextures.com/xlfaqApp.html#Unused note that is some of the older versions of excel, you may have to close excel for the new setting to take. Regards FSt1 "Damian" wrote: I get this message when I try to insert a column anywhere in my excel sheet. Screen shot : http://img40.imageshack.us/img40/8320/52370335.png Why is that? There is no data in the last column i still have a lot of columns left and they are empty. Could it be because of froozen cells on top? Thank You, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can not insert Columns
thnks for the feed back.
regards FSt1 "Damian" wrote: Great. Thank You. It worked. "FSt1" wrote: hi excel has lost it's reference to used range. this happens now and then and is easy to reset. see this site http://www.contextures.com/xlfaqApp.html#Unused note that is some of the older versions of excel, you may have to close excel for the new setting to take. Regards FSt1 "Damian" wrote: I get this message when I try to insert a column anywhere in my excel sheet. Screen shot : http://img40.imageshack.us/img40/8320/52370335.png Why is that? There is no data in the last column i still have a lot of columns left and they are empty. Could it be because of froozen cells on top? Thank You, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert columns of dates in between exsisting columns of | Excel Discussion (Misc queries) | |||
| can no longer insert new columns & unhide hidden columns | Excel Worksheet Functions | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
| XL won't let me insert columns | Excel Discussion (Misc queries) | |||
| insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
Linear Mode
