Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Moving and Selecting Rows Some people may find it helpful to move down a row, and then select that entire row. This would allow them to easily move one row at a time through a worksheet, rather than one cell at a time. This tip explains how you can use two easy shortcut keys to achieve the desired movement and selection, or a couple of macros that automate the process even more. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Moving Cells Using the Mouse Moving cells in an Excel worksheet without using cut and paste. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)