| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column mysteriously shifts up/down
Twice in this week, on 2 different computers, Ive had a column of data shift
one row up or down, misaligning the data in the column with the appropriate row. Has this happened to anyone? Am I doing something while scrolling that could accidentally cause this? Is there a way I can shift the column one row up/down in the opposite direction to get my data realligned? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column mysteriously shifts up/down
Select a cell in that column and either DeleteShift cells up or InsertShift
cells down. The "mysterious" shifting up or down could very well be user-generated but no way of knowing how. I have not experienced Excel doing this on its own but maybe lucky<g Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 09:59:00 -0700, Robin wrote: Twice in this week, on 2 different computers, Ive had a column of data shift one row up or down, misaligning the data in the column with the appropriate row. Has this happened to anyone? Am I doing something while scrolling that could accidentally cause this? Is there a way I can shift the column one row up/down in the opposite direction to get my data realligned? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More column shifts ... | Excel Discussion (Misc queries) | |||
| Mysteriously Shifting Lines and Text Boxes | Charts and Charting in Excel | |||
| date changes mysteriously when copied | Excel Discussion (Misc queries) | |||
| what command shifts all cells in a column up or down? | New Users to Excel | |||
| Problem with pasting dates - year mysteriously changes | Excel Worksheet Functions | |||
Linear Mode
