Insert Rows

S

sree

Hi,
I have a simple excel sheet which is saved in eencrypted format. I am unable
to insert rows in the same. Whenever I try, it says, 'To prevent possible
loss of data, Excel cannot shift non-blank cells off the document...'. Could
find what the real problem is.
 
G

Gord Dibben

Check by using CTRL + End and see where Excel takes you.

Could be Excel thinks you have data in the bottom row of the worlsheet so it
won't shify cells down for inserting a row.

If CTRL + End takes you to bottom of sheet, delete unused rows then save the
workbook.


Gord Dibben MS Excel MVP
 

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

Adding more than 65,536 rows in Excel 2007 5
Insert Row-First time user 3
Getting error message when I try to insert rows. 1
Problem in inserting rows 1
inserting rows? 2
Unable to Insert Columns 5
Excel Limitation - Inserting Colums - Help 1
Can't insert new columns into worksheet 1

Top