• Quest Computer Skills

My best Shortcut keys in Microsoft Excel

Use short cuts in Microsoft Excel to work more effective. A productive way to work in Excel is to keep your hands on the keyboard. You loose time everytime that you lift your hand from the keyboard to use the mouse.


Ctrl Home: goto cell A1

Ctrl End: goto last captured data

Esc key: to undo your changes whilst still in a cell

Shift + Arrow Keys: to select a range of cells


F2 Cell Changes to Edit mode (works lovely if you are editing email addresses)

F4 Repeats last function (try it a few times to get the feel for it, does not always work the first time)

F11 Quick Chart (just select area to be charted and press F11, pretty useless, but it impresses people)

F12 Save As

Ctrl x = cut, Crtl c = copy, Ctrl v = paste

Ctrl s = save as, Crtl p = print


My favourite short cut: Ctrl ~ shows the formulas in your Excel spreadsheet. Press Ctrl ~ to switch back.



13 views0 comments

Recent Posts

See All

JOB TIPS >> How to reset your password on INTERNET JOB SITES: 1) Open the job site 2) Click on log in 3) Type in your e-mail address 4) Then it will allow you to type in your password 5) Click on for

ABOUT JOBS What is an aptitude test? A lot of companies ask candidates to write an aptitude test, when they are applying for a new position. The test lasts from 10 minutes to an hour. The company is t