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

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

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

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...
"RebecaMelanie" wrote:

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

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

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

"RebecaMelanie" wrote:

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