Insert Rows
in [General]
|
From: sree on 13 Apr 2010 08:42 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.
From: Russell Dawson on 13 Apr 2010 11:22 It's probably formatted cells that extend beyond the data in your w/sheet. You may have coloured whole rows/columns. Figure out the last row of data you're using and delete all of the formatting and data in rows below. Then try again. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "sree" wrote: > 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.
From: Gord Dibben on 13 Apr 2010 12:28 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 On Tue, 13 Apr 2010 05:42:04 -0700, sree <sree(a)discussions.microsoft.com> wrote: >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.
|
Pages: 1 Prev: Data validation issue with multiple columns Next: Count function not working in one workbook |