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.
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.