insert columns

matmich · Apr 22, 2004

Hey guys,
For some reason I have a worksheet that I cant insert a column into.

Any reason why?? It gives me an error message:

"to prevent loss of data excel cannot shift nonblank cells of
worksheet....."

but Idon't know what to do to fix it and why is it giving me this?

Frank Kabel · Apr 22, 2004

Hi
try re-setting the used range. See
http://www.contextures.com/xlfaqApp.html#Unused

Gord Dibben · Apr 22, 2004

mat

Have a read at this KB article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;211769

Gord Dibben Excel MVP

Unable to Insert Columns	5	Dec 11, 2008
Excel Error Help	1	Mar 13, 2009
Adding more than 65,536 rows in Excel 2007	5	Jan 14, 2008
How to add columns to the end of a spreadsheet--(last col is IV)?	2	Jan 6, 2010
Error message "cannot shift nonblank cells off the worksheet"	2	Jun 13, 2009
troubleshoot inserting columns in a spreadsheet	3	Nov 3, 2005
Getting error message when I try to insert rows.	1	Apr 13, 2006
insert row problem	3	Jun 30, 2005

insert columns

matmich

Frank Kabel

Gord Dibben

Ask a Question

Similar Threads