Excel Tricks I Guarantee You Didn't Know!

Great tip for Excel if you need to move data around. Dragging alone will move any cells you select. But if you hold the Ctrl button, a copy of your cells will be made. Holding the shift key will insert your selected cells in wherever you drop them. #excel #workhacks | Spreadsheet Nation

How to Move Rows and Columns in Excel (The Best and Fastest Way) Select the row that you want to move. Hold the Shift Key from your keyboard. Move your cursor to the edge of the selection. It would display the move icon (a four directional arrow icon). Click on the edge (with left mouse button) while still holding the shift key. Move it to the row where you want this row to be shifted Leave the mouse button when you see a bold line right below the row where you want to move this row. Leave the S

Microsoft Excel - Advanced Excel Formulas & Functions