Drag-and-Drop Fun in Excel

In Excel, drag-and-drop spreadsheet editing is most effective in two situations: when you not only need to move or copy a range of cells to a new (blank) place in the worksheet, but also when you want to insert the cells into an existing table of data. To do this kind of insert moving or copying, you must hold down the Shift key as you drag the cell selection to its new position. Excel indicates where the selected data will be inserted at the time you drop it by displaying an I-beam-type indicator in front of the mouse pointer:

• When the I-beam pointer runs horizontally between rows, you know that the selection will be inserted as a new row in the existing table of data.
• When it runs vertically between columns, you know that the selection will be inserted as a new column in the table.

For more Microsoft Excel tricks get Excel Timesaving Techniques For Dummies

[tags]computer tips, MS Office, Excel, spreadsheets[/tags]