I don’t know how many Microsoft Excel users take advantage of all its features or even know such features exist. Probably very few ones. Although I have used this software a lot, for many years, I still discover new things everyday.
I put together here a list of shortcuts which proved very useful to me, especially when my projects required more time than I had available. I saved plenty of time working mostly from the keyboard, instead of wandering with the mouse all over the place. If you find it useful, feel free to use it and give me a big smile!
Ctrl + S = save
Ctrl + W = save and exit
Ctrl + Q = exit without saving
Ctrl + O = open file
Ctrl + N = opens a new document
Ctrl + P = print
Ctrl + F = find
Ctrl + H = replace
Ctrl + Z = undo
Ctrl + Y = redo
Ctrl + U = underline the content of the selected cell
Ctrl + B = bold the content of the selected cell
Ctrl + I = italicize the content of the selected cell
Ctrl + A = selects an area which includes all non-blank cells neighbouring the current one
Ctrl + A pressed when the current cell neighbours only with blank cells = select all
Ctrl + C = copy
Ctrl + V = paste (if you press ENTER after the copy of cut commands, is has the same effect)
Ctrl + X = cut
Ctrl + ‘ or Ctrl + D = copy the content of cell above into the current cell
Ctrl + ; = inserts the current date into the current cell
Ctrl + Shift + ; = inserts the time into the current cell
Double click on the edge of a cell within a table = moves the cursor in that direction to the first non blank cell.
F2 = enter the editing mode, with the cursor at the end of the content
Home, pressed in Editing mode = moves cursor at the beginning of the content
Ctrl + PageDown = goes to the next worksheet
Ctrl + PageUp = goes to the previous worksheet
Ctrl + L = creates a list from the data in range
Ctrl + K = insert hyperlink
Ctrl + 1 = opens the format cells dialog box
Ctrl + 7 = toggles off/on the icons menu
Ctrl + 9 = hide current row
Ctrl + 0 = hide current column
Alt + F4 = quit
Shift + right arrow = selects cells to right of the current one
Shift + left arrow = selects cells to right of the current one
If you are interested in more resources, you can find some great ones here.
One Comment
Thanks for this article, it was very useful for me.
15 Trackbacks
[...] here is a list from alltipsandtricks.com [...]
[...] The hidden face of MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] Other articles: Pivot table data field settings in MS Excel Data validation in MSExcel The hidden face of MS Excel Get more productivity with Windows XP How to write faster in MS Word How to use macros in MS Excel [...]
[...] Other articles: Dr. Jekyll or Mr. Hyde? It depends on perspective The invisible web revealed Data validation in MSExcel The hidden face of MS Excel Get more productivity with Windows XP How to write faster in MS Word How to use macros in MS Excel [...]
[...] Other articles: Dr. Jekyll or Mr. Hyde? It depends on perspective The invisible web revealed Data validation in MSExcel The hidden face of MS Excel Get more productivity with Windows XP How to write faster in MS Word How to use macros in MS Excel [...]
[...] The hidden face of MS Excel [...]
[...] Other articles: Dr. Jekyll or Mr. Hyde? It depends on perspective The invisible web revealed Data validation in MSExcel The hidden face of MS Excel Get more productivity with Windows XP How to write faster in MS Word How to use macros in MS Excel [...]
[...] 10 reasons why you shouldn’t go for psychic readings Browser shortcuts common to IE and Firefox The hidden face of Microsoft Excel How to use macros in Microsoft Excel The invisible web revealed The three problems of a modern woman Myers-Briggs personality types and relationship assessment How to get longlasting traffic for your blog Blood types and nutrition Stereograms and eyesight improvement [...]
[...] positive feedback on my other posts regarding productivity using computer software (Windows XP and Microsoft Excel), I am now continuing the series with a collection of Microsoft Word shortcuts which are saving me [...]
[...] it for now with Windows XP, you can check my other articles, with most useful shortcut keys for Microsoft Word and Excel. submit_url = ‘http://www.alltipsandtricks.com/115417518130959322/'; This entry was [...]