Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell spread sheet: reinstate number of rows to 50 | New Users to Excel | |||
Highlighting Has Shifted on Rows | Excel Discussion (Misc queries) | |||
How do I restore my menu and tool bars in Excell? | Excel Discussion (Misc queries) | |||
In Excell sheet i want to insert more than 65,536 rows how i can . | Excel Worksheet Functions | |||
How do I restore accidently deleted excell spreadsheet? | Excel Discussion (Misc queries) |