Steal Over 150
Shortcuts & Secrets
THE BEST EXCEL SHORTCUTS GUIDE
FOR PROFESSIONALS & BUSINESS OWNERS LOOKING
TO SAVE TIME & ELEVATE THEIR CAREER
@Excelbychris
ABOUT ME
Hey there! I’m Christian,
founder of Excel Skool. Not too
long ago, I was an operations
manager drowning in data,
spending hours each day trying
to make sense of endless
spreadsheets.
But after figuring out a smarter
way to master Excel, everything
changed.... Excel became my
secret weapon for efficiency
and life got a whole lot easier.
In 2024, I took the leap, leaving
my job to focus full-time on
helping others conquer Excel
like pros. that’s me!
Now, with millions of followers
and hundreds of clients worldwide, I’m
here to show you how to turn Excel from a
headache into your greatest asset.
Let’s make it happen!
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
WELCOME
Introducing ***Drumroll***
The Ultimate Excel Guide for Shortcut Masters.
Yes, you heard it right!
For all shortcut enthusiasts, time-savers
and efficiency aficionados...
This guide is your holy grail.
Are you the type who likes to do as little as
possible to achieve maximum results?
Do you find yourself daydreaming about a
world where spreadsheets practically fill
themselves?
Well, my friend, you've stumbled upon the
haven of Excel mastery.
We're diving deep into the most powerful tips
and tricks - guiding you step-by-step to
become a PRO at Excel... Save you hours &
boost your productivity like never before!
- @ExcelbyChris
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 01 GENERAL SHORTCUTS
GENERAL SHORTCUTS
Learn these basic Excel shortcuts to work faster and
handle your spreadsheets with ease.
Shift + F4 Find next match (after initial Find)
Alt + F1 Insert embedded chart
F11 Insert chart in new sheet
Ctrl + Shift + L Toggle Autofilter
Alt + ↓ Activate filter
Ctrl + T Create table
Shift + Space Select table row
Ctrl + Space Select table column
Ctrl + A Select table (when active cell is in table)
Alt + C Clear slicer filter
F7 Run Spellcheck
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 01 GENERAL SHORTCUTS
GENERAL SHORTCUTS
Learn these basic Excel shortcuts to work faster and
handle your spreadsheets with ease.
Shift + F7 Open Thesaurus
Alt + F8 Open Macro dialog box
Alt + F11 Open VBA Editor
Ctrl + D Duplicate object, formula, text
Alt Snap to grid (whilst dragging)
Ctrl + 6 Hide or show objects
Alt + ' Open Modify Cell Style dialog box
Shift + F10 Show right-click menu
Alt Space Display control menu
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 02 WORKSHEET SHORTCUTS
WORKSHEET SHORTCUTS
Master the basics with these Excel shortcuts to quickly
navigate, organize and edit your spreadsheets.
Shift + F11 Insert new worksheet
Ctrl + PgDn Go to next worksheet
Ctrl + PgUp Go to previous worksheet
Alt + O, H R Rename current worksheet
Alt + E, L Delete current worksheet
Alt + E, M Move current worksheet
F6 Select adjacent worksheets
Ctrl + Click Select non-adjacent worksheets
ScrLk Toggle scroll lock
Ctrl + Shift + F1 Toggle full screen
Ctrl + P Print
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 02 WORKSHEET SHORTCUTS
WORKSHEET SHORTCUTS
Master the basics with these Excel shortcuts to quickly
navigate, organize and edit your spreadsheets.
Ctrl + F2 Open print preview window
Alt + P, R S Set print area
Alt + P, R C Clear print area
Ctrl + Mouse Wheel Up Zoom in
Ctrl + Mouse Wheel Down Zoom out
Alt + R, P S Protect sheet
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 03 FORMATTING SHORTCUTS
FORMATTING SHORTCUTS
Use formatting shortcuts to make your data look better
and easier to read, from bolding text to cell borders.
Ctrl + 1 Format cells
Ctrl + Shift + F Display Format Cells w Font tab selected
Ctrl + B Apply or remove bold
Ctrl + I Apply or remove italics
Ctrl + U Apply or remove underscore
Ctrl + 5 Apply or remove strikethrough
Alt + H, A C Align center
Alt + H, A L Align left
Alt + H, A R Align right
Alt + H, 6 Indent
Alt + H, 5 Remove indent
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 03 FORMATTING SHORTCUTS
FORMATTING SHORTCUTS
Use formatting shortcuts to make your data look better
and easier to read, from bolding text to cell borders.
Alt + H, W Wrap text
Alt + H, A T Align top
Alt + H, A M Align middle
Alt + H, A B Align bottom
Alt + H, F G Increase font size one step
Alt + H, F K Decrease font size one step
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 04 DATA ENTRY SHORTCUTS
DATA ENTRY SHORTCUTS
Save time on data entry with these shortcuts, making it
quicker and more accurate to input numbers, text, and
formulas.
Enter Enter data and move down
Shift + Enter Enter data and move up
Tab Enter data and move right
Shift + Tab Enter data and move left
Ctrl + Enter Enter data and stay in same cell
Enter Enter same data in multiple cells (after copying)
Ctrl + ; Insert current date
Ctrl + Shift + : Insert current time
Ctrl + D Fill down from cell above
Ctrl + R Fill right from cell on left
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 04 DATA ENTRY SHORTCUTS
DATA ENTRY SHORTCUTS
Save time on data entry with these shortcuts, making it
quicker and more accurate to input numbers, text, and
formulas.
Ctrl + ' Copy formula from cell above (formula is exact copy)
Ctrl + Shift + " Copy value from cell above
Ctrl + K Insert hyperlink
Alt + ↓ Display AutoComplete list
Ctrl + E Flash fill
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 05 RIBBON SHORTCUTS
RIBBON SHORTCUTS
Use these shortcuts to master Excel's Ribbon, letting
you quickly access commands and tools without
touching your mouse.
Ctrl + 1 Expand or collapse ribbon
Alt Activate access keys
→←↑↓ Move through Ribbon tabs and groups
Space OR Enter Activate or open selected control
Enter Confirm control change
F1 Get help on selected control
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 06 CELL EDIT MODE SHORTCUTS
CELL EDIT MODE SHORTCUTS
Edit cells faster with shortcuts that let you quickly
update, fix & finish your data without breaking your flow.
F2 Edit the active cell
Shift + F2 Insert or edit comment
Shift + F10, M Delete comment
Esc Cancel editing
Shift + → Select one character right
Shift + ← Select one character left
Ctrl + → Move one word right
Ctrl + ← Move one word left
Ctrl + Shift + → Select one word right
Ctrl + Shift + ← Select one word left
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 06 CELL EDIT MODE SHORTCUTS
CELL EDIT MODE SHORTCUTS
Edit cells faster with shortcuts that let you quickly
update, fix & finish your data without breaking your flow.
Shift + Home Select to beginning of cell
Shift + End Edit the active cell
Ctrl + Delete Insert or edit comment
Backspace Delete comment
Delete Cancel editing
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 07 SELECT SPECIAL SHORTCUTS
SELECT SPECIAL SHORTCUTS
Quickly select the data you need with these shortcuts,
so you can focus on the cells that matter most in your
analysis.
Ctrl + G Or F5 Display 'Go To' dialog box
Ctrl + Shift + O Select cells with comments
Ctrl + Shift + * Select current region around active cell
Ctrl + A Select current region
Ctrl + [ Select direct precedents
Ctrl + Shift + { Select all precedents
Ctrl + ] Select direct dependents
Ctrl + Shift + } Select all dependents
Alt + ; Select visible cells only
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 08 EXT. SELECTION SHORTCUTS
EXT. SELECTION SHORTCUTS
Easily expand your selections in Excel with these
shortcuts, great for highlighting large ranges or multiple
areas in your worksheet.
Shift + → Extend selection right
Shift + ← Extend selection left
Shift + ↑ Extend selection up
Shift + ↓ Extend selection down
Ctrl + Shift + → Extend the selection to last cell on the right
Ctrl + Shift + ← Extend the selection to last cell on the left
Ctrl + Shift + ↑ Extend the selection to the last cell up
Ctrl + Shift + ↓ Extend the selection to the last cell down
Shift + PgUp Extend selection up one screen
Shift + PgDn Extend selection down one screen
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 08 EXT. SELECTION SHORTCUTS
EXT. SELECTION SHORTCUTS
Easily expand your selections in Excel with these
shortcuts, great for highlighting large ranges or multiple
areas in your worksheet.
Ctrl + Shift + Home Extend selection to first cell in worksheet
Alt + Shift + PgDn Extend selection right one screen
Alt + Shift + PgUp Extend selection left one screen
Ctrl + Shift + End Extend selection to last cell in worksheet
Shift + Home Extend selection to start of row(s)
F8 Toggle 'Extend Selection' mode
Esc Cancel 'Extend Selection' mode
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 09 NAVIGATION SHORTCUTS
NAVIGATION SHORTCUTS
Navigate your Excel workbook quickly with
shortcuts that take you to any cell, row or column
without the hassle.
→ Move one cell right
← Move one cell left
↑ Move one cell up
↓ Move one cell down
Alt + PgDn Move one screen right
Alt + PgUp Move one screen left
PgUp Move one screen up
PgDn Move one screen down
Ctrl + → Move to right edge of data region
Ctrl + ← Move to left edge of data region
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 09 NAVIGATION SHORTCUTS
NAVIGATION SHORTCUTS
Navigate your Excel workbook quickly with
shortcuts that take you to any cell, row or column
without the hassle.
Ctrl + ↑ Move to top edge of data region
Ctrl + ↓ Move to bottom edge of data region
Home Move to beginning of row
Ctrl + End Move to last cell in worksheet that contains data
Ctrl + Home Move to first cell in worksheet
End Turn End mode on
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 10 SELECTION SHORTCUTS
SELECTION SHORTCUTS
Master selecting cells, ranges & objects in Excel with
these shortcuts to speed up your workflow and make
accurate changes.
Shift + Space Select entire row
Ctrl + Space Select entire column
Ctrl + A Select current region if worksheet contains data
Shift + Click Expand selection
Ctrl + Click Add non-adjacent cells to selection
Ctrl + Alt + → Move right between non-adjacent selections
Ctrl + Alt + ← Move left between non-adjacent selections
Shift + F8 Toggle 'Add to Selection' mode
Esc Exit 'Add to Selection' mode
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 11 DRAG & DROP SHORTCUTS
DRAG & DROP SHORTCUTS
Easily manage your data with drag-and-drop shortcuts,
allowing you to quickly move, copy or adjust data in
your worksheet.
Drag Display 'Go To' dialog box
Ctrl + Drag Select cells with comments
Shift + Drag Select current region around active cell
Ctrl + Shift + Drag Select current region
Alt + Drag Select direct precedents
Ctrl + Drag Select all precedents
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
SECTION 12 ACTIVE CELL SHORTCUTS
ACTIVE CELL SHORTCUTS
Stay in control of your data by learning active cell
shortcuts, so you can easily manage the content and
behavior of the selected cell.
Shift + Backspace Select active cell (+1 cells already selected)
Ctrl + Backspace Show the active cell on worksheet
Ctrl + . Move active cell clockwise to corners of selection
Enter Move active cell down in selection
Shift + Enter Move active cell up in selection
Tab Select all precedents
Shift + Tab Move active cell left in a selection
Get 90% OFF – Enroll in my Excel Course today: CLICK HERE
© 2025 Excel Skool. All rights reserved. This ebook is for personal use only. No part of this publication may be reproduced,
distributed, or transmitted in any form or by any means without permission from the publisher.
CONCLUSION
READY TO MASTER EXCEL?
This is the fastest & most complete way to do it!
You’ve got my Excel eBook, and that’s awesome!
But why stop there?
I’d love for you to take it to the next level and join my
Excel Program — a complete experience designed to
help you master Excel and truly level up your skills.
It’s packed with practical, time-saving tips and real-
world applications to help youwork smarter.
CLICK BELOW & Join at 90% OFF
CLICK TO GET ACCESS
