Tuesday, August 10, 2010

BUSINESS TIPS - Computer Shortcuts - Part 3

BUSINESS TIPS – Computer Shortcuts – Part 3


By Nikki Viljoen – Viljoen Consulting CC August 2010

Another fabulously positive responsive week I got last week. Seems I am not the only one who doesn’t know all the shortcuts and tips. Here are the next lot.

Next Up – Excel Shortcut Keys
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check specific text and/or document
F11 Create Chart
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shit + F1 Insert new worksheet
Shift + F3 Open the Excel formula window
Shift + F5 Bring up search box
Ctrl + A Select all contents of worksheet
Ctrl + B Bold highlighted section
Ctrl + I Italicize highlighted section
Ctrl + C Copy selected text
Ctrl + V Paste
Ctrl + D Fill
Ctrl + K Insert link
Ctrl + F Open, find and replace options
Ctrl + G Open go-to links
Ctrl + U Underline highlighted section
Ctrl + Y Underline selected text
Ctrl + 5 Strike through highlighted selection
Ctrl + O Open options
Ctrl + N Open new document
Ctrl + P Open print dialogue box
Ctrl + S Save
Ctrl + Z Undo last action
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize current window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + Page up & down Move between Excel worksheets in the same document
Ctrl + Tab Move between two or more open Excel files
Alt + = Create formula to sum all of above cells
Control * Insert value of above cell into current cell
Ctrl + Shift + ! Format number in comma format
Ctrl + Shift + $ Format number in currency format
Ctrl + Shift + # Format number in date format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ^ Format number in scientific format
Ctrl + Shift + @ Format number in time format
Ctrl + -> Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + W Close document

Again I knew one or two of these, but certainly not the majority and now of course I will also have to irritate the heck out of my IT guy by asking all the ‘what does . . . . . mean?”.

More next week.

Nikki is an Internal Auditor and Business Administration Specialist who can be contacted on 083 702 8849 or nikki@viljoenconsulting.co.za or http://www.viljoenconsulting.co.za

No comments: