Few rows on my excell sheet have shifted down. How can I restore?

R

RebecaMelanie

One of our excell spreadsheets with colums from a to p, few rows, starting
from colum g till p have shifted down messing the order of the data.
Does anyone knows what can be done to fix this issue?
Thanks for your help,
Rebeca
 
S

Sheeloo

Select the range with the extra rows (Col G to P only)
Right Click
Choose Delete
Choose Shift Cells UP

Save a copy...

You can also select the first blank row, do the above and then keep pressing
F4...
 
A

andy62

It sounds like some cells got inserted near the top of columns g - p. If you
select those all extra cells (you didn't say whether things were shifted down
by one row or more than one row) and go to Edit >> Delete >> Shift Cells Up,
you should be back where you want.

HTH
 

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

"cannot shift objects off sheet" error 8
How do I insert a row without the formula changing? 1
Working on birthday "book" for my wife and having layout/editing trouble 0
How do I shift cells down in Excel? 1
How to filter rows data based on background color of individual cells 3
Access 2003 and excel 0
can I take info in rows to another sheet as row headings? 0
copy rows from one Data sheet to another sheet based on cell conte 2

Top