Excel Error Help

A

admin1

Can anyone help me to understand what this error means? It happens when i
try to insert a row in a specific worksheet.

-To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet. Try to locate the last nonblank cell by
pressing CTRL+END, and delete or clear all cells between the last cell and
the end of your data. Then select cell A1 and save your workbook to reset
the last cell used. Or, you can move the data to a new location and try
again.

This error does not make sense to me because the entire worksheet is not
'full'.
 
S

Sheeloo

The message means that Excel is picking up the wrong 'nonblank cells' on your
worksheet...

Go to the row after your last row... SHIFT-CTRL-END to select all rows below
and delete them... Save your file...

If you try SHIFT-CTRL-END again it should take you UP ...
The error should go away...
 

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

Top