Loading
Excel.Tips.Net ExcelTips (Menu Interface)

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.

 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.