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
Have you ever spent a lot of time putting information into a worksheet, only to realize that you should have put it in the opposite order? Here are a couple of great ways to reverse the order of the rows and columns in you worksheet.

   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
Want to easily move information from one cell to another? A quick way to do it is to simply drag and drop using the mouse.

   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.

   Quickly Transposing Cells
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.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.