[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 129
  • Last Modified:

i would like to insert row in excel 2007 and i receiving the following attach printscreen error

please advice how to solve this error and to be able to insert new row
the sheet is not protected

thanks
gvilbis
screenshot-tony.png
0
gvilbis
Asked:
gvilbis
  • 2
1 Solution
 
Randy PooleCommented:
Did you do what it said in reference to shift E and follow the instructions?
0
 
gvilbisAuthor Commented:
i am not sure i undestand the meaning of the instractions
i tried to delete several rows and then insert and its not work
i tried to go to the end of the spreadsheet and delete from there rows data and then insert unsuccessfully

can you please advice the meaning?

thanks
gvilbis
0
 
Randy PooleCommented:
Open your sheet, Press Ctrl+End this will take you to the last row which it thinks is blank
Highlight all rows/cells from there up to where you think is blank and then press delete and then try your insert again.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now