Archive | February, 2018

Tame your computer – top 10 tips for Excel

24 Feb

What I often hear from my course participants is that they came away with new tricks, tips and shortcuts that they never would have found on their own.

Here are your favourite, most commented on Excel shortcuts, with links to the relevant tips. I hope you enjoy them!

1 ALT + ENTER Insert line breaks
2 ALT + 7 Create a bulleted list
3 CTRL + ; Insert today’s date
4 CTRL + A twice Select the entire table, including the table headers
5 CTRL + down arrow Move to end of a range of cells in a column
6 CTRL + G Display the Go To dialog box
7 CTRL + T Format as table, enabling filtering
8 F11 Create a chart in a separate sheet
9 F2 Switch to Edit mode
10 F4 Repeat your last action

By the way, CTRL + G also works in Word and Outlook and F4 in Word and PowerPoint.

Finally, see http://www.roem.co.uk/inc/shortcut_archive.pdf for a list of all the shortcuts published since March 2013 when we launched the ‘shortcut of the week’ on our home page.

Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I drip feed a new shortcut weekly, to help you to boost productivity without reaching for your mouse.

Tame your computer – crafty conversions

9 Feb

In the first tip of this year I wrote how to use the drag and drop technique to move or copy cells. (It’s here if you missed it.)

The disadvantage of this method is that the Paste Options button won’t be displayed, so you won’t be able to perform special copy and paste operations “on the fly”, (such as converting columns to rows and rows to columns). That said, it still offers a great trick if you want to paste values, not formulas.

Here’s how:

  1. Select the cell(s) that contain the formula.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination upward-pointing arrow and four-headed arrow.
  3. Press and hold down the right mouse buttondrag the cell(s) to the new location and release the mouse button.
  4. Select Copy Here as Values Only.

 

Related tips:

Move or copy cells using drag and drop

Display the Auto Fill Options on the fly

Keep the column width when pasting

How to quickly change columns to rows or rows to columns