Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 131
29 October 2005

Start each week with a free tip

To subscribe, please type your email address in the box below:

Quickly insert moved or copied rows or columns between existing rows (Microsoft Excel)

Doesn't time fly? It's been two weeks since I last landed in your inbox! OK, I never intended to skip the weekly tip (especially as I only recently said I wouldn't) but I had the chance to go walking in Derbyshire for three days and just couldn't resist. So I hope you used the sudden free time to go on a hunt through the ever-growing tip-archive (http://www.roem.co.uk/hints.html) ;-) Anyway, this week's tip is based on a question that came up during last week's Excel with Excel seminar ... is there a quick way to insert moved or copied rows between existing rows without first having to insert blank rows or risking replacing existing ones. Well, yeah.

Here's how:

  1. Select the row(s) that contain the data you want to move or copy by clicking (and dragging) over their row number(s).
  2. Right-click over the selected row(s) and click Cut or Copy.
  3. Right-click over the row immediately below where you want to place the cut or copied row.
  4. Select Insert Cut Cells or Insert Copied Cells from the shortcut menu.

Similarly, you can move or copy columns between existing columns. Oh, and if, after you finish copying, you want to cancel that annoying moving border ( called a "marquee" by anoraks ;-) ) simply press the ESC key on your keyboard.

By the way, the seminar was a success and I'm planning to run another one in March or April next year. (Early bird bookings will be taken soon.) But if you cannot wait that long ... you can buy the (204-page!) handout with practice material on a CD for just GBP35 (RRP 65 pounds). The handout is designed in a step-by-step format that is suitable for self-study and has been approved by the Microsoft Office Specialist Program ensuring the courseware is among the finest available for learning Microsoft Excel. Phone or email support can be arranged to provide guidance, answer questions, and assist with problems. Simply reply to this email if you wish to order and I will invoice you or your organisation accordingly.

Until next week.

Email this page to a friend

Enter recipient's email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
October 2005