Tame your computer - take the easy way in Excel

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.


PS I'm committed to sharing the best of what I know with others so  please don't keep these tips a secret. If you enjoyed today's tip,  please forward it to anyone you feel may benefit or reprint it  (with full copyright and subscription information) in your  newsletters and message boards. Got a tip to share? Submit it by  emailing karen@roem.co.uk - if your tip is selected, I'll publish  it along with your name; the bragging rights will last a lifetime.


4 February  2014

Karen Roem offers software training and support through her  company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or  visit her website at http://www.roem.co.uk

Please note: Cambridge Network and Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.
____________________________________________