Excel has 256 columns. If you "insert" columns, an equal number of columns
are deleted from the far right of the spreadsheet. If you have anything (or
once had anything) in the columns to be deleted, Excel makes you clear out
those columns manually, so that no data is accidentally deleted.

Tim C

"Nicole L." wrote:

I have a worksheet, albeit a very full/big worksheet, with lots of formulas
referencing cells and ranges in an adjacent worksheet. I need to insert a
couple columns but when I do a copy and an Insert Copied Columns, it won't
do
it and gives me an error about losing data if I do that... etc. It also
says
something about Blank cells... It mentions clearing out/emptying the
columns
to the right, but I obviously can't do that and maintain all my formulas,
etc.

I've searched the Microsoft help pages to no avail.

Any ideas?
Do I have too many columns, or something?