KEMBAR78
@excelbychris - 200+ Excel Shortctus Guide | PDF | Computing | Software
0% found this document useful (0 votes)
139 views13 pages

@excelbychris - 200+ Excel Shortctus Guide

The document introduces a free guide containing over 200 Excel shortcuts designed to enhance productivity and efficiency for users of both Windows and Mac. Christian, the founder of Excel Skool, shares his journey from struggling with spreadsheets to mastering Excel, aiming to help others transform their Excel experience. The guide includes various sections on navigation, general shortcuts, formatting, and more, making it a comprehensive resource for Excel users.

Uploaded by

mr.lucifer245
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
139 views13 pages

@excelbychris - 200+ Excel Shortctus Guide

The document introduces a free guide containing over 200 Excel shortcuts designed to enhance productivity and efficiency for users of both Windows and Mac. Christian, the founder of Excel Skool, shares his journey from struggling with spreadsheets to mastering Excel, aiming to help others transform their Excel experience. The guide includes various sections on navigation, general shortcuts, formatting, and more, making it a comprehensive resource for Excel users.

Uploaded by

mr.lucifer245
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 13

“Hey Chris... I legit can’t believe this thing is 100% free.

Like, who just gives away 200 Excel shortcuts that actually make you
faster? I thought I knew Excel. Turns out, I was taking the scenic route on
everything. Thank you again for everything...”
- Austin L. Operations Manager

For Window and Mac

Excelbychris
Excel Expert
Excelbychris
Excel Expert

Ciao! I’m Christian, founder of Excel Skool.


A couple years ago, I was neck-deep in spreadsheets as an
Ops Manager, wasting hours cleaning up messy data and
chasing formulas that never worked the way they should.
Then something changed and learned how to use Excel.
Not the basic stuff... I'm talking real shortcuts, clean
systems, the kind of moves that cut hours off my day.
No more guesswork.
No more clicking around like a zombie for hours.
Just results. Fast!
In 2024, I bet on myself.
Quit my job and made this my full-time thing...
Helping people like you get ridiculously good at Excel.
Now?
Millions follow along, 1000s of students in every corner of
the world.
And ONE clear goal...
Turn Excel from a headache into your unfair advantage.

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
Excelbychris
Excel Expert

Introducing... *drumroll*
The 200+ Ultimate Excel Shortcuts Guide
Yep, you heard that right.
For all you shortcut lovers, time-savers and efficiency
junkies... this guide is your new best friend.
Are you the type who likes to do the least and get the
most?
Ever wish your spreadsheets could basically run
themselves?
Well, it’s your lucky day!
We’re diving deep with powerful tips and tricks, showing
you step-by-step how to become a straight-up Excel PRO
by mastering Excel Shortcuts.
This guide will save you hours and boost your productivity
like never before.
No more staring at endless cells.
It’s time to take control and stop wasting hours on boring
tasks.

ExcelbyChris
Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 01 NAVIGATION SHORTCUTS

C
NAVIGATION SHORTCUTS

X
Learn these Excel navigation shortcuts to move around

E
faster and stop wasting time scrolling and clicking.

X C E L
Shortcut Name

E
Win Mac

L
Move one cell right → →

Move one cell left ← ←

Move one cell up ↑ ↑

Move one cell down ↓ ↓

Move one screen right Alt Pgdn Fn ⌥ ↓

Move one screen left Alt Pgdn Fn ⌥ ↑

Move one screen up Pgdn Fn ↑

Move one screen down Pgdn Fn ↓

Move to beginning of row Home Fn ←

Move to last cell in worksheet Ctrl End Fn ⌘ →

Move to first cell in worksheet Ctrl Home Fn ⌘ ←

Turn End mode on End ⌃ →

Move to right edge of region Ctrl → ⌘ →

Move to left edge of region Ctrl ← ⌘ ←

Move to top edge of region Ctrl ↑ ⌘ ↑

Move to bottom edge of region Ctrl ↓ ⌘ ↓

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 02 GENERAL SHORTCUTS

C
GENERAL SHORTCUTS

X
Learn these Excel shortcuts to speed up and stop

E
reaching for the mouse every two seconds.

X C E L
Shortcut Name

E
Win Mac

L
Cut selected cells Ctrl X ⌘ X

Paste content from clipboard Ctrl V ⌘ V

Undo last action Ctrl Z ⌘ Z

Redo last action Ctrl Y ⌘ Y

Copy selected cells Ctrl C ⌘ C

Repeat last action F4 ⌘ Y

Paste values Ctrl Shift V ⌘ ⌃ V V

Display Paste Special box Ctrl Alt V ⌘ ⌃ V

Display find and replace Ctrl F ⌘ F

Find with replace selected Ctrl H ⌘ H

Find previous match Ctrl Shift F4 ⌘ ⌥ G

Find next match Shift F4 ⌘ G

Create embedded chart Alt F1 ⌘ ⌥ F1

Create chart in new worksheet F11 Fn F11

Open options / preferences Alt F T ⌘ ,

Open help F1 ⌘ /

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 03 SELECT SPECIAL SHORTCUTS

C
SELECT SPECIAL SHORTCUTS

X
Learn these Select Special shortcuts to highlight

E
exactly what you need fast and clean.

X C E L
Shortcut Name

E
Win Mac

L
Select current region Ctrl A ⌘ A

Select current array Ctrl / ⌃ /

Select row differences Ctrl \ ⌃ \

Select column differences Ctrl Shift | ⌃ ⇧ |

Select direct precedents Ctrl [ ⌃ [

Select all precedents Ctrl Shift { ⌃ ⇧ {

Select direct dependents Ctrl ] ⌃ ]

Select all dependents Ctrl Shift } ⌃ ⇧ }

Select visible cells only Alt ; ⌘ ⇧ Z

Display ‘Go To’ dialog box Ctrl G ⌃ G

Select cells with comments Ctrl Shift O ← ⌃ ↓ O

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 04 FORMATTING SHORTCUTS

C
FORMATTING SHORTCUTS

X
Learn these formatting shortcuts to clean up your

E
sheets fast and make them actually look good.

X C E L
Shortcut Name

E
Win Mac

L
Align center Ctrl H A C ⌘ E

Align left Ctrl H A L ⌘ L

Align right Ctrl H A R ⌘ R

Format anything Ctrl 1 ⌘ 1

Display Format Cells Font tab Ctrl Shift F ⌃ ⇧ F

Indent Ctrl H 6 ⌃ ⌥ Tab

Remove indent Alt H 5 ⌃ ⌥ ⇧ Tab

Increase font size one step Ctrl H F G ⌘ ⇧ >

Decrease font size one step Ctrl H F K ⌘ ⇧ <

Toggle bold formatting Ctrl B ⌘ B

Toggle italic formatting Ctrl I ⌘ I

Toggle underline formatting Ctrl U ⌘ U

Toggle strikethrough Ctrl 5 ⌘ ⇧ X

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 05 ENTERING DATA SHORTCUTS

C
ENTERING DATA SHORTCUTS

X
Learn these data entry shortcuts to get info in fast

E
and keep your flow going.

X C E L
Shortcut Name

E
Win Mac

L
Enter and move left Shift Tab ⇧ Tab

Enter and stay in cell Ctrl Enter ⌃ Return

Enter same data in multiple cells Ctrl Enter ⌃ Return

Copy value from cell above Ctrl Shift “ ⌃ ⇧ “

Add hyperlink Ctrl K ⌘ K

Display Auto-Complete list Alt ↓ ⌥ ↓

Flash fill Ctrl E ⌃ E

Enter and move down Enter Return

Enter and move up Shift Enter ⇧ Return

Enter and move right Tab Tab

Insert current date Ctrl ; ⌃ ;

Insert current time Ctrl Shift : ⌘ ;

Fill down from cell above Ctrl D ⌘ D

Fill right from cell left Ctrl R ⌘ R

Copy formula from cell above Ctrl ‘ ⌘ ‘

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 06 BORDERS SHORTCUTS

C
BORDERS SHORTCUTS

X
Learn these borders shortcuts to frame your data

E
fast without hunting through menus.

X C E L
Shortcut Name

E
Win Mac

L
Add border outline Ctrl Shift & ⌘ ⌥ 0

Add or remove border right Alt R ⌘ ⌥ →

Add or remove border left Alt L ⌘ ⌥ ←

Add or remove border top Alt T ⌘ ⌥ ↑

Add or remove border bottom Alt B ⌘ ⌥ ↓

Remove borders Ctrl Shift _ ⌘ ⌥ _

Add or remove border diagonal Alt D

Add border horizontal interior Alt H

Add or remove border vertical Alt V

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 07 SELECTION SHORTCUTS

C
SELECTION SHORTCUTS

X
Learn these selection shortcuts to highlight data fast

E
and stay in control of your sheet.

X C E L
Shortcut Name

E
Win Mac

L
Select entire row Shift Space ⇧ Space

Select entire column Ctrl Space ⌘ Space

Select entire worksheet Ctrl A ⌘ A

Add adjacent cells to selection Shift ⇧


Add non-adjacent cells Ctrl ⌘

Move right non-adjacent Ctrl Alt → ⌃ ⌥ →

Move left non-adjacent Ctrl Alt ← ⌃ ⌥ ←

Toggle add to selection mode Shift F8 Fn ⌥ F8

Cancel selection Esc Esc

Same selection in next column ⌥ Tab

Same selection previous column ⌥ ⇧ Tab

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C SECTION 08 CELL EDIT MODE SHORTCUTS

C
CELL EDIT MODE SHORTCUTS

X
Learn these shortcuts to jump in and edit cells fast

E
without breaking your flow.

X C E L
Shortcut Name

E
Win Mac

L
Select one word right Ctrl Shift → ⌃ ⇧ →

Select one word left Ctrl Shift ← ⌃ ⇧ ←

Select one character right Shift → ⇧ →

Select one character left Shift ← ⇧ ←

Move one word right Ctrl → ⌃ →

Move one word left Ctrl ← ⌃ ←

Select to beginning of cell Shift Home Fn ⇧ ←

Select to end of cell Shift End Fn ⇧ →

Delete to end of line Ctrl Delete Fn ⌃ Delete

Delete character to the left Backspace Delete

Delete character to the right Delete Fn Delete

Insert line break in cell Esc Enter ⌃ ⌥ Return

Edit the active cell F2 ⌃ U

Cancel entry Esc Esc

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
L EX
EL EX C MODULE 09 WORKBOOK SHORTCUTS

C
WORKBOOK SHORTCUTS

X
Learn these shortcuts to switch, save and manage

E
workbooks without wasting a second.

X C E L
Shortcut Name

E
Win Mac

L
Insert new worksheet Shift Enter Fn ⇧ F11

Go to next worksheet Ctrl PgDn Fn ⌃ ↓

Go to previous worksheet Ctrl PgUp Fn ⌃ ↑

Move to next pane F6 Fn ⌃

Move to previous pane Shift F6 Fn ⇧ F6

Go to next workbook Ctrl Tab ⌘ `

Go to previous workbook Ctrl Shift Tab ⌘ ⇧ ~

Toggle scroll lock ScrLk Fn ⇧ F14

Toggle full screen Ctrl Shift “ ⌃ ⌘ F

Select adjacent worksheets Ctrl ⇧


Select non-adjacent worksheets Ctrl ⌘

Minimize workbook window Ctrl F9 ⌘ M

Maximize workbook window Ctrl F10 Fn ⌃ F10

Ready to Enroll in Our Excel Program? CLICK HERE AND JOIN NOW
© 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.
EX C E L
L X C
X C EL E
X C E L E You got the Excel eBook... solid move.

E
But why stop there? The Office Mastery Program takes

L
that win and blows it wide open.
Excel? Yep. But also PowerPoint, Word, Outlook and even

C
AI... all the stuff that actually moves the needle at work.

EX
It’s not fluff.

L
Look, this isn’t some boring course full of stuff you’ll never

C E
use. It’s the kind of thing that actually makes your day less

X
painful... Join now at 90% OFF

X C E L E
L E C
C EL EX
X CLICK TO LEARN MORE

You might also like