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

How to filter rows data based on background color of individual cells 1
How to calculate fixed rows in Excel ( Sum of every 7 rows for i.. 7
Few snags in making excel template for statistical analysis 3
How can I find multiple items on a sheet?? 1
Excel 2007 / MS Query - editing existing query to another sheet 0
Testing if data already imported 3
Converting a column of information into a row of information 3
I have a pricelist. How can i link my quote sheet with it? 3

Top