| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when trying to insert columns: "Nonblanc cells"
Hi all; we are experiencing an error when trying to insert a column in a
spreadsheet: error states: "cannot shift nonblank cells off the worksheet". We have cleared and deleted all the content in the area that we want to insert a new column and in the area to the right of the content without any success. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when trying to insert columns: "Nonblanc cells"
Check if you have some data in the column IV (the last column)
"ketil" wrote in message ... Hi all; we are experiencing an error when trying to insert a column in a spreadsheet: error states: "cannot shift nonblank cells off the worksheet". We have cleared and deleted all the content in the area that we want to insert a new column and in the area to the right of the content without any success. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert row/column error "Cannot shift object off sheet" | Excel Discussion (Misc queries) | |||
| cannot insert rows -error message "cannot shift object off sheet" | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
