Excel Training – Page 55 – STL

I love shortcuts, they save me loads of time by using a couple of keystrokes instead of going to different tabs and menus.

Here are my 10 favourite Excel shortcuts to speed up data entry in Excel.

To undo the last action – use Control + Z no matter what program you are using, this shortcut undoes the last action. Love it!
To add today’s date – use Control + ;
To add the current time – use Control + Shift + :
To edit a cell – use F2
To select a column – use Control + spacebar
To select a row – use Shift + spacebar
To get to the last active cell in your Excel sheet – use Control + End
To move to the first active cell – use Control + Home
To move to the next worksheet – Control + page down
To move to the previous worksheet – use Control + page up

For more time-saving shortcuts and techniques, Excel training can help give you the edge https://www.stl-training.co.uk/excel-2007-introduction.php

You can save yourself time scrolling across your Excel documents by wrapping text in column headings.

It’s easy to do, takes a few seconds and improves the way you can move through and use your Excel worksheet.

Here is a worksheet where better use of column format could help.

long-headings-excel-powerpoint-courses — Long headings use loads of space and make it harder for you to navigate around your document.

I have used autofit to make the titles fit into the columns, but the titles are taking up lots of space. There has to be a better way…oh, now wait…there is! I can wrap the text in the column headings, so the focus is on the contents in the cell, not on the width of the column.

I select the entire row A1, and right click. I then select format cells, and click Wrap Text.

Under Text alignment, select the Vertical text box and select Top.

format-text-excel-powerpoint-courses — Format cells options.

Now, for each column I can amend the column width and height manually using click and drag.

Wrap-text-excel-powerpoint-courses — Tidy!

Simple touches, like improving the look of and Excel worksheet, makes it easier to use. If you add Excel worksheets within a Powerpoint presentation, making sure that the column headings are readable is key. Using the wrap text option can help you do this. You can get more out of Excel and Powerpoint, take a look at what more you can do with https://www.stl-training.co.uk/microsoft/excel-training-london.php

Blog Categories