Archive | February, 2014

Tame your computer – easy path to a new order

11 Feb

If you’ve used Word’s built-in heading styles you can easily jump to the different sections using Word’s navigation pane. (See tip 209 if you missed this, although it was called ‘Document map’ back then.) The Navigation Pane is still a fantastic feature for moving between sections, but even more useful is its ability to change the order of your headings and sub-headings (and your content!)

Here’s how:

  1. If necessary, display the Navigation Pane. (Select the View tab and tick the Navigation Pane check box in the Show group. Or simply press CTRL+F.)
  2. Click on any heading in the navigation pane and drag it to its new position. (A black line shows where it will be placed.)
  3. Release the mouse button and jump up and down with joy. (I do; Word 2010 has revolutionised the way I write and tweak my training material.)

You can also right-click any of the headings and select options such as Select Heading and Content, one of my favourites when I want to copy only part of the document in a new document. (Simply press CTRL+C, CTRL+N and CTRL+V 😉

By the way, since March last year I’ve been drip-feeding my favourite shortcuts – one a week – to help you boost productivity without reaching for your mouse. Every week a new shortcut appears on our home page, but by popular request I’ve created an archive that you can print and download – and keep next to your keyboard at home or at work; or stick it on your company’s message board.  A link has been made available within the ‘Shortcut of the week’ box; alternatively click here to download the latest copy. If you are unsure about any of the shortcuts, please do not hesitate to get in touch.

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.