Keyboard Shortcuts (Short)

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Sort Options

Alt, A, S

Insert Filter

Alt, A, T

Print Preview

Alt, F, W, V

Increase Decimal

Alt, H, 0

Decrease Decimal

Alt, H, 9

Align Text Options

Alt, H, A

Accounting Number Format

Alt, H, AN

Insert Border

Alt, H, B

Delete Worksheet

Alt, H, D, S

Clear Cell Contents

Alt, H, E, A

Fill Color of Text

Alt, H, FC

Change Font

Alt, H, FF

Change Font Size

Alt, H, FS

Fill Color of Cell

Alt, H, H

Insert Column

Alt, H, I, C

Insert Row

Alt, H, I, R

Comma Format

Alt, H, K

Conditional Formatting

Alt, H, L

Select Number Format

Alt, H, N

Move or Copy Sheet

Alt, H, O, M

Change Tab Name

Alt, H, O, R

Percentage Format

Alt, H, P

AutoSum

Alt, H, U

Paste actual Values

Alt, H, V, A

Paste Formulas

Alt, H, V, F

Paste formatting

Alt, H, V, R

Paste Picture

Alt, H, V, U

Remove tracing arrows

Alt, M, A, A

Trace dependents

Alt, M, D

Trace precedents

Alt, M, P

Evaluate Formula

Alt, M, V

Insert Recommended Charts

Alt, N, R

Inset Pivot Table

Alt, N, V

Insert Textbox

Alt, N, X

Insert illustrations/shapes

Alt, N, ZI

Insert Symbol

Alt, N, ZS

Auto Format

Alt, O, A

Auto fit column width

Alt, O, C, A

Set column width

Alt, O, C, W

Page setup/margins

Alt, P, S, P

Toggle Gridlines

Alt, P, V, G

Review File (comments, stats, protect)

Alt, R

Ungroup rows/columns

Alt, Shift, left arrow

Group rows/columns

Alt, Shift, right arrow

Switch Program

Alt, Tab

Change View (new window, freeze panes, split)

Alt, W

Change Zoom

Alt, W, Q

Navigate Ribbon

Alt, arrow left or right

Display drop down list

Alt, down arrow

Delete cell and get inside

Backspace

Delete selected cells

Ctrl, -

Hide Column

Ctrl, 0

Format Cells Dialog Box

Ctrl, 1

Strike-through Text

Ctrl, 5

Hide Row

Ctrl, 9

Paste Special (all options)

Ctrl, Alt, V

Flash Fill Pattern

Ctrl, E

Find text/value

Ctrl, F

Minimize/Restore ribbon

Ctrl, F1

Name a cell

Ctrl, F3

Replace text/value

Ctrl, H

Move to cell "A1"

Ctrl, Home

New Excel File

Ctrl, N

Switch Worksheets

Ctrl, PgUp/Down

Save File

Ctrl, S

Unhide Column

Ctrl, Shift, 0

Unhide Row

Ctrl, Shift, 9

Select Column

Ctrl, Spacebar

Create Table

Ctrl, T

Redo

Ctrl, Y

Undo

Ctrl, Z

Go to precedent

Ctrl, [

Go to dependent

Ctrl, ]

Go to end of contiguous range

Ctrl, arrow key

Show formulas/values

Ctrl, ~

Delete Cell/Selection

Delete

New Separate Chart

F11

Save as

F12

Edit cells/Highlight dependent cells

F2

Anchor cells

F4

Go-to cell

F5

Spell Check

F7

Recalculate workbooks

F9

Move to "A" column in current row

Home

Insert cells

Shift, Ctrl, +

Display Shortcut menu

Shift, F10

New Worksheet

Shift, F11

Insert Note

Shift, F2

Select Row

Shift, Spacebar

Minimize Program

Windows, D

Open windows File Explorer

Windows, E

Screenshot Tool

Windows, Shift, S

View Clipboard

Windows, V


संबंधित स्टडी सेट्स

Training and Development Chapter 3

View Set

vocabulaire TB (2) 5a à bord de l'avion: partie b, vocabulaire TB (2) 5a à l'aéroport: partie a COMBO

View Set

Foundations of Employee Motivation MPO exam 3

View Set

Fundamentals Practice Questions Exam 2

View Set

Section 3.5 Part 3: Translating Phrases to Algebraic Equations with Integers and Solving

View Set