Excel Shortcuts

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Fill Right/Fill Down

Ctrl R/ Ctrl D

Save

Ctrl S

Currency Format

Ctrl Shift $

Percent Format

Ctrl Shift %

Highlight Column

Ctrl Spacebar

Underline

Ctrl U

Paste

Ctrl V

Close

Ctrl W

Cut

Ctrl X

Redo

Ctrl Y

Undo

Ctrl Z

Move between workbooks

Ctrl page up/page down

Insert Current Time

Ctrl shift ;

Delete/insert

Ctrl+-/Shift Ctrl+

group row to hide

Alt A G G

Help

Alt F1

Print Preview

Alt FP

Clear

Alt H E

Font - change size

Alt H F S or Ctrl Shift P (full)

Copy/move a sheet

Alt HOM

Rename Sheet

Alt HOR

Function - inserting

Alt MF

Name a Cell

Alt MMD or Alt MN

Page Setup

Alt P S P

Set print area - use after selecting an area

Alt PRS

Comment - delete

Alt R D

Move Dialog Box

Alt Spacebar

Page Break Preview

Alt W I

Normal View

Alt W L

Zoom - return to 100% zoom

Alt WJ

Zoom

Alt WQ

Autosum

Alt= or Alt ==

Copy Past Formulas

Crl C then Alt HVF

Format Cells

Ctrl 1 or Alt HOE

Insert Current Date

Ctrl ;

Bold

Ctrl B

Copy Paste Formats

Ctrl C then Alt HVST

Copy/Cut

Ctrl C/Ctrl X

Find

Ctrl F

Replace

Ctrl H

Italic

Ctrl I

New Workbook

Ctrl N

Open

Ctrl O

Print

Ctrl P

Save As

F12

Edit Cell

F2

Anchor cells ($$$$)

F4

Repeat

F4

Go to

F5 or Ctrl G

Spellcheck

F7

Deselect to original cell

Shift Backspace

Comment - insert

Shift F2 or Alt R C

Highlight Row

Shift Spacebar

Insert Row, column

Shift Spacebar, then Ctrl Shift + (Ctrl Spacebar for column


Kaugnay na mga set ng pag-aaral

Chapter 16 - Health and Wellness

View Set

MicroBio Chapter 13: Viruses, Viroids, and Prions

View Set

UNIT 10: SELLER RELATIONSHIPS AND COUNSELING UNIT QUIZ

View Set

Somatic Symptom & Illness Anxiety Disorders

View Set