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

  • Thread starter Thread starter RebecaMelanie
  • Start date Start date
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
 
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...
 
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
 
Back
Top