Elon Technology Blog

Office Shortcuts Part 2

Moving and Copying Cells in Excel

Probably the most useful yet completely undiscoverable feature in Excel is the ability to move and copy cells by dragging selection borders. The selection border is the black line that outlines a cell when it is clicked.

So, in the example above, we are trying to insert Row 4, the row with the name “Boris,” in between Rows 1 and 2. So,

1. Click the number next to the row you want to copy (in this case, the number 4). This will select the whole row.
2. Place your mouse over the black line (where the red circle is in this example).
3. Hold down the shift key and click.
4. Drag your mouse to the space in between Rows 1 and 2.
5. Release the mouse and the shift key.

The end result is the entirety of Row 4 is now in Row 2, and the rest of the Rows have shifted down to compensate.

In order to copy a row, follow the same process, but instead of holding the shift key, hold the Ctrl key. This will copy the existing row into the desired row, but be careful! If you copy the data into a Row with data in it, it will overwrite that data.

And one more really quick tip:

Clearing formatting in Word

To remove formatting from selected text, press Ctrl + Spacebar. This removes all formatting, including bold, italics, underlining, coloring, and styles. All text will revert back to normal text.

That’s all for this week. Until next week,
The elite Program

 

Comments are closed.