Moving Data

Tips, Tricks, and Answers

The following articles are available for the 'Moving Data' topic. Click the article's title (shown in bold) to see the associated article.

Flipping Data
How to reverse the order of rows in a table.

Moving and Selecting Rows
If you need to move down a row and then select that row, you may wonder if there is a shortcut to handle such a navigation task. There isn't, but you can create one.

Moving Cells Using the Mouse
Moving cells in an Excel worksheet without using cut and paste.

Pasting Without Updating References
Do you need to paste formulas without updating the references in whatever you are pasting? You can accomplish this, depending on what you are pasting and where you are pasting it.

Transposing Your Data
If you want to turn a range of cells by 90 degrees within a worksheet, you need to understand how Excel can handle the transposition for you. This tip discusses your options.