Unveiling the Magic of Keyboard Shortcuts in Excel

Microsoft Excel is a powerful tool that helps analyze, organize, and visualize data. However, this dynamic tool can seem overwhelming at times, and an important question to ask is, “How do you make Excel work for you?”

One hidden feature about Excel is that it incorporates keyboard shortcuts to expedite your workflow. Keyboard shortcuts in Excel are combinations of keys that, when pressed in order or at the same time, trigger a specific function or command. A comma sign (,) in a shortcut means you need to press the keys in order.  A plus sign (+) between the keys indicates the need to press multiple keys at the same time.

Understanding and utilizing these quick and easy shortcuts can significantly reduce time spent in repetitive tasks and maintain your sanity. For instance, the Alt+O+A shortcut selects all cells within a range and offers instant formatting options. Below you will find a list of 25 more Excel shortcuts to save you time.

25 EXCEL SHORTCUTS FOR WINDOWS

Ctrl + A	Select all data
Ctrl + E	Flash Fill
Ctrl +T	Insert table
Alt + =	Autosum
Ctrl + Shift + +	Add row
Ctrl + –	Delete row
Alt + ;	View hidden columns/rows
Ctrl + 0	Hide columns
Ctrl + 9	Hide rows
Ctrl + N	Open new workbook
Shift + Space	Select entire row
Ctrl + Space	Select entire column
Ctrl + Home	Go to top left cell
Ctrl + End	Go to bottom right cell
Shift + ←↑↓→	Multiselect columns/rows
Ctrl + Shift + ←↑↓→	Select across table/range
Alt, H, O, I	Autofit column width
Alt, H, O, A	Autofit row height
Alt, O, A	Format data
Ctrl + Q	Quick Analysis toolbar
Ctrl + Pg Up	Toggle right tabs
Ctrl + Pg Dn	Toggle left tabs
F4	Absolute/relative reference
F9	Refresh
Ctrl + ;	Current date

Did you enjoy this Quick Tip? Enroll in our Excel text communication to receive more useful Excel tips and tricks by scanning the QR code with your smartphone below or texting the word “basics” to (844) 905-2792.

-Megan

Click Here for Printable Version

About the Author

Covenant Health

Headquartered in Knoxville, Tennessee, Covenant Health is a community-owned, healthcare enterprise committed to providing the right care at the right time and place. Covenant Health is the area’s largest employer and has more than 11,000 compassionate caregivers, expert clinicians, and dedicated employees and volunteers.