Tuesday, September 02, 2014

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: