I apologize, but that is awful. I hope it is not your Favorite. I could not get it to work from sheet to sheet where as typing a comma while in/using a formula like SUM works great or just hold control while on one sheet. =SUM(L10:L16,Sheet2!H7:H12,Sheet1!P9:P14) If you need Shift + F8 to grab 82 sections in one sheet, great! But you have other issues.
I reprogramed my mouse to replace the most used keyboard keys and combinations.
I get my efficiency because I am able to eliminate the time to go from mouse to board and back, but also I need to minimize the use of the Shift/Ctrl key due to serious injuries to my left hand. My mouse has:
Ctrl+C Ctrl+V Ctrl+Enter (SQL Query in SQL Developer) Enter Down Left Click Right click Scroll up/down one line at a time (sometimes very important in excel)
Name a table. Not technically a keyboard shortcut, but a shortcut in time saving for sure. Name a table in order to refer to that table within your formula instead of clicking to another sheet, selecting the table, hitting F4, going back to the sheet with your formula, etc... For vlookups. Instead of: =VLOOKUP($F$1,Sheet2!$A$1:$C$3,1) Use: =VLOOKUP($F$1,QRef1,1)
Rename an Excel table - Office - Microsoft "googl" it - Or simply select the table and type in QRef1, Qref2, etc.. in the Name Box Also great because as you type in QRe- it will display Qref1, QRef2 etc and you can choose and hit tab to auto fill.
On the topic of important, copying and pasting the formatting to another cell can be a huge time saver. It is the % symbol on the list of paste options.
Ctrl + R - Copy from cell to the left, like Ctrl + D is to the cell above
5
u/by-the-numbers Jan 02 '15
F2
Edit the active cell.
4
u/by-the-numbers May 19 '15
Ctrl+Alt+V
Paste Special menu.
So, for example, Ctrl+Alt+V, V, Enter will paste the clipboard as values.
3
u/by-the-numbers May 19 '15
Ctrl+;
Paste today's date to the active cell.
3
u/sledgehammer7 Feb 16 '15
F4 on a cell reference in a formula turns it into an absolute reference. Such a time saver.
2
u/by-the-numbers Jan 02 '15
Alt-=
Autosum: Automatically select a nearby range of numbers and insert an "=SUM()" call in the active cell.
2
u/by-the-numbers Jan 02 '15
Ctrl-T
Create formatted table. Shortcut for "Insert" ribbon -> "Table" function.
2
u/by-the-numbers May 19 '15
F5
'Go To' menu.
2
u/by-the-numbers May 19 '15
Ctrl+G, Alt+S
or F5, Alt+S
'Go To: Special' menu
2
u/by-the-numbers May 19 '15
Ctrl+1
'Format Cell' menu
2
u/by-the-numbers May 19 '15
Ctrl+'
Copy formula in above cell to active cell.
1
u/by-the-numbers Jan 02 '15
Application.Onkey
Use VBA to define your own keyboard shortcuts and link to macros.
1
u/by-the-numbers Feb 16 '15
Shift-F8
For selecting non-contiguous ranges using only the keyboard.
For example, say you want to select A1:A3 and C3:C4 --
3
u/FTOracleDBA Feb 16 '15
Name a table. Not technically a keyboard shortcut, but a shortcut in time saving for sure. Name a table in order to refer to that table within your formula instead of clicking to another sheet, selecting the table, hitting F4, going back to the sheet with your formula, etc... For vlookups. Instead of: =VLOOKUP($F$1,Sheet2!$A$1:$C$3,1) Use: =VLOOKUP($F$1,QRef1,1)
Rename an Excel table - Office - Microsoft "googl" it - Or simply select the table and type in QRef1, Qref2, etc.. in the Name Box Also great because as you type in QRe- it will display Qref1, QRef2 etc and you can choose and hit tab to auto fill.
3
u/Bubba89 Feb 16 '15
Technically two but the distinction is important:
Ctrl+" - Copy the contents of the above cell
Ctrl + D - Copy the contents AND FORMATTING of the above cell
3
u/FTOracleDBA Feb 16 '15
Ctrl + Pageup/PageDown This goes to sheet left and right.
I use this in combination with Ctrl + Home so I can quickly see what is on each sheet. Hold Ctrl and toggle between Home and Pagedown/Pageup.