Excel Keyboard Shortcuts

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Delete row / column

CTRL + -

Format Cells menu

CTRL + 1

Select All

CTRL + A

Refresh All Pivot Tables

CTRL + ALT + F5

Bold text

CTRL + B

Copy cells

CTRL + C

Copy down

CTRL + D

Find

CTRL + F

Name a cell / range

CTRL + F3

Close file

CTRL + F4

Replace

CTRL + H

Go to cell A1 on sheet

CTRL + HOME

Italics

CTRL + I

Add entry to slicer selection

CTRL + Mouse click

New file

CTRL + N

Open File

CTRL + O

Move to next worksheet

CTRL + PgUp / PgDn

Copy right

CTRL + R

Save file

CTRL + S

Apply Number format

CTRL + SHIFT + !

Apply Date format

CTRL + SHIFT + #

Apply Currency format

CTRL + SHIFT + $

Apply Percentage format

CTRL + SHIFT + %

Add border

CTRL + SHIFT + &

Delete borders

CTRL + SHIFT + -

Apply Time format

CTRL + SHIFT + @

Apply General format

CTRL + SHIFT + ~

Select cells to end of boundary

CTRL + SHIFT + →

Select one word in cell

CTRL + SHIFT + →

Select column

CTRL + Spacebar

Toggle Workbooks

CTRL + TAB

Underline

CTRL + U

Paste cells

CTRL + V

Cut cells

CTRL + X

Redo

CTRL + Y

Undo

CTRL + Z

Show formulas

CTRL + ~

Go to end of boundary

CTRL + →

Skip word in cell

CTRL + →

Format PT cells

RMBK*, F

Open Grouping dialog box

RMBK*, G

Sort PT cells

RMBK*, S

Remove a filter from PT

RMBK*, T, C

Create a filter rule for PT

RMBK*, T, S

New worksheet

SHIFT + F11

Add / edit comment

SHIFT + F2

Select multiple areas

SHIFT + F8

Select all text in cell

SHIFT + HOME/END

Select row

SHIFT + Spacebar

Select multiple cells

SHIFT + →

Autofit columns

ALT + O, C, A

Change column width

ALT + O, C, W

Rename worksheet

ALT + O, H, R

Show / Hide all comments

ALT + R, A

Remove comment

ALT + R, D

Open Zoom dialog box

ALT + V, Z

Freeze / Unfreeze panes

ALT + W, F, F

Group rows / columns

ALT + A, G, G

Collapse entire field

ALT + A, H

Hide grouped cells

ALT + A, H

Expand entire field

ALT + A, J

Show grouped cells

ALT + A, J

Sort Data Ascending

ALT + A, S, A

Sort Data Descending

ALT + A, S, D

Sort Data

ALT + A, S, S

Ungroup rows / columns

ALT + A, U, U

Clear slicer selection

ALT + C

Paste formulas

ALT + E, S, F

Paste formats

ALT + E, S, T

Paste values

ALT + E, S, V

Close Excel

ALT + F4

Add a decimal place

ALT + H, 0

Remove a decimal place

ALT + H, 9

Border menu

ALT + H, B

Change text color

ALT + H, F, C

Change text size

ALT + H, F, S

Move / Copy worksheet

ALT + H, O, M

Format as Table

ALT + H, T

Insert new column

ALT + I, C

Insert new row

ALT + I, R

Show values as

ALT + J, T, A

Summarize values by

ALT + J, T, D

Insert slicer

ALT + J, T, S, L

Insert banded rows

ALT + J, Y, R

Change PT style

ALT + J, Y, S

Remove all traces

ALT + M, A, A

Trace dependents

ALT + M, D

Trace precedents

ALT + M, P

Create Pivot Chart

ALT + N, C

Create Pivot Table

ALT + N, V

Delete cell

Delete

Go to last character in cell

END

Leave cell without changes

Escape

Save As

F12**

Edit cell

F2**

Anchor a cell / range

F4**

Repeat last action

F4**

Jump to cell

F5**

Go to first cell in row

HOME

Go to first character in cell

HOME


Set pelajaran terkait

Chapter 1: The Twenty First Century Entrepreneur

View Set

Simulation Lab 3.1: Module 03 Change IPv6 Auto-Configuration Settings

View Set

ATI RN Nursing Care of Children Online Practice 2019 A

View Set

Find the Exact Value of The Trig Function

View Set

Federal Government, Unit 1, Lesson 4: Federalism

View Set