CANNOT INSERT COLUMN AFTER DELETING ALL BLANK CELLS

R

rel

I am Editing multiple worksheets that were created previously. I entered
formulas (every 3rd row) in the final "TOTAL" column, & set the Print Area
just for my active cells. I got the message about CTRL+END...& Delete Blank
Cells...bla bla bla. I did this & on one smaller worksheet it worked
great!!!! Yet on this larger sheet CTRL+END places the cursor in the correct
spot (my last active cell G143), BUT I still get the same error message when
I attempt to insert a COLUMN!!!!!!!
HELPPPPPPPP
 
W

Wigi

Check out the last few columns.

Are there shapes in that region? Do you have values in the last few columns?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Cannot delete empty cells/rows 4
Insert row after blank cell encountered 6
Excel 2002 : Problem in moving along blank cells 10
Insert Row also adds formulas and moves cursor 2
unable to insert a column 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Macro: insert rows anywhere in the sheet 4
Insert blank row after change in cell value not working. 1

Top