Tame your computer – take the easy way in Excel

5 Feb

In Excel, there are various ways of inserting moved or copied rows or columns between existing cells. There are no Rights or Wrongs, Shoulds or Shouldn’ts – but Hard or Easy exists!

So if you want to move or copy a row or a column between existing cells and you are still in the habit of first inserting a blank row, worried that the cells you’ve copied are replacing the existing cells, there is an easy way.

Here’s how:

  1. Select the row or the column that you want to move or copy.
  2. Move or Copy the cells, as normal. (CTRL+X or CTRL+C, anyone?)
  3. Click anywhere in the row below or column to the right of where the information is to appear.
  4. Click on the Insert button (not on the down arrow below the button) in the Cells group on the Home tab.

If you insert entire rows or columns, the surrounding rows and columns are shifted down and to the left.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: