29 Excel shortcuts you didn't know you needed

‍

Busy Season is upon us. Working papers everywhere and deadlines to be met!

‍

As auditors and accountants, Microsoft Excel is our life. I know some people who plan out anything and everything on Excel. Knowing these secrets, I want to help you, letting you in on some helpful Excel and other MS Office shortcuts.

Hopefully, this will make your life easier when drafting or reviewing those working papers.

And yes, some of you reading this may know these shortcuts!

But there is undoubtedly some poor soul out there who needs this right now.

General  Shortcuts – applicable to all MS Office applications

‍

CTRL + N - Open new workbook / document

CTRL + P - Print the workbook / document

CTRL + A - Select all details in the current workbook /  document

CTRL + C - Copy the selected cells / information

CTRL + X - Cut the selected cells / information

CTRL + V - Paste the copied cells / information

CTRL + Z - Undo last action

CTRL + Y - Redo last action

CTRL + F - Open the Find panel to search in the document

CTRL + H - Open the Replace panel to replace words, numbers  or characters in the document

CTRL + Arrow Keys - Move to far ends of a table

‍

General Shortcuts – applicable to Excel only

‍

CTRL "+" - Add rows

CTRL "-" - +Delete rows

CTRL + 9 - Hide rows (make a selection)

CTRL + SHIFT + 9 - Unhide rows (over a selection)

CTRL + Arrow Keys - Move to far ends of a table

F2 - Edit the selected cell

ALT + Enter - Enter function in an open cell

‍

‍
Formatting Shortcuts – can be applied to multiple cells

‍

CTRL + 1 - Open Formatting panel

CTRL + B or CTRL 2 - Bold the selected cells

CTRL + I or CTRL 3 - Italics the selected cells

CTRL + U or CTRL 4 - Underline the selected cells

CTRL + SHIFT + $ - Apply Currency formatting to selected cells

CTRL + SHIFT + % - Apply Percentage formatting to selected cells

CTRL + SHIFT + # - Apply Date formatting to selected cells

CTRL + SHIFT + ~ - Apply Number formatting to selected cells

ALT + = - Autosum the selected cells

CTRL + ; - Enter the current date (only one cell at a time)

‍

‍

‍