ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Error when trying to insert columns: "Nonblanc cells" (https://www.excelbanter.com/excel-worksheet-functions/190633-error-when-trying-insert-columns-nonblanc-cells.html)

ketil

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.


Gaurav[_3_]

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.





All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com