| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unable to add columns
I need to add 3 or 4 columns in particular places and it is saying that I am
unable to do that because it cannot shift nonblank cells off the worksheet. Not sure what to do at this point. The file might be shared, not sure if this makes difference. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unable to add columns
That error means that there is some type of data in one or more cells
of the last 3 or 4 columns of the spreadsheet. ChristyR wrote: I need to add 3 or 4 columns in particular places and it is saying that I am unable to do that because it cannot shift nonblank cells off the worksheet. Not sure what to do at this point. The file might be shared, not sure if this makes difference. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unable to add columns
Thanks. That worked.
"JW" wrote: That error means that there is some type of data in one or more cells of the last 3 or 4 columns of the spreadsheet. ChristyR wrote: I need to add 3 or 4 columns in particular places and it is saying that I am unable to do that because it cannot shift nonblank cells off the worksheet. Not sure what to do at this point. The file might be shared, not sure if this makes difference. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to access unprotected columns on a protected sheet....somet | Excel Discussion (Misc queries) | |||
| Unable to line up decimal points in some columns. | Excel Discussion (Misc queries) | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
| unable to hide columns -"can not shift objects off sheet" shows | Excel Worksheet Functions | |||
| Unable to group rows or columns on an excel worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
