Toggle Between Relative and Absolute References

Use the function key F4 to toggle a reference between relative and absolute references while editing a formula. Repeatedly pressing F4 will cycle through the 4 different options in this order: A1, $A$1, A$1, $A1.

Quickly Fill Multiple Cells with a Value or Formula

Use the keyboard shortcut Ctrl+Enter to quickly fill multiple cells with a value or formula.

Switching Between Different Tabs / Worksheets

One of the keyboard shortcuts I use all the time in Excel is the one for switching between tabs or worksheets within a workbook: Ctrl+PageUp or Ctrl+PageDown.

Keyboard Shortcut - Choosing a Font

I've come to really like a new excel keyboard shortcut - one that allows you to easily choose a font for a cell. This shortcut even works for portions of text within a cell. It also works in Microsoft Word. The process for editing the font is:

Keyboard Shortcuts to Insert Special Symbols in Excel

The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feature. Typing (c), (tm), or (r) will accomplish this. The other way to enter special symbols in Excel is by going to Insert > Symbol.

Insert a New Row or Column - Excel Keyboard Shortcut

Lately, I have been trying to use as many Excel keyboard shortcuts as I can (not only for productivity, but for ergonomic reasons). There is a quick two-step process that is very convenient for inserting or deleting a row or column: