Shortcut Key Excel

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

select visible cells

(Alt)(;)

Auto Sum

(Alt)(=)

Open a Menu or list

(Alt)(Down)

Enter a New line in the cell

(Alt)(Enter)

Moves Between open windows

(Alt)(Esc)

Opens the selection pane

(Alt)(F10)

Moves one screen to the right in a worksheet

(Alt)(PgDn)

moves one screen to the left in a worksheet

(Alt)(PgUp)

Swith Between application

(Alt)(Tab)

minimize/ Maximize Window

(Ctl)(F10)

Copy formula from cell above

(Ctrl)(')

increase decimals

(Ctrl)(,)

Delete the selected Cells/Rows/Columns

(Ctrl)(-)

Hide Columns

(Ctrl)(0)

Opens the format dialog box

(Ctrl)(1)

Show and Hide Objects

(Ctrl)(6)

Hide Rows

(Ctrl)(9)

Enter Current date

(Ctrl)(;)

Select All

(Ctrl)(A)

Paste Values

(Ctrl)(Alt)(V)

Bold

(Ctrl)(B)

Copy

(Ctrl)(C)

Fill Down

(Ctrl)(D)

moves to the bottom of the region or next region

(Ctrl)(Down)

Flash Fill

(Ctrl)(E)

Moves to the bottom of the active area

(Ctrl)(End)

Copies formula into selected cells

(Ctrl)(Enter)

Find

(Ctrl)(F)

Hide Ribons

(Ctrl)(F1)

Open Name Manager

(Ctrl)(F3)

close

(Ctrl)(F4)

Minimize workbook

(Ctrl)(F9)

Print

(Ctrl)(P)

Switches between worksheet tabs from right to left

(Ctrl)(Page Up)

Move to the next worksheet in the workbook

(Ctrl)(PgDn)

Move to the previous worksheet in the workbook

(Ctrl)(PgUp)

Replace

(Ctrl)(H)

Moves to the top of the spreadsheet

(Ctrl)(Home)

Italics

(Ctrl)(I)

Moves to the left of the region or next region

(Ctrl)(Left)

New workbook

(Ctrl)(N)

switches between worksheet tabs from left to right

(Ctrl)(Page Down)

Open the Quick analysis tool

(Ctrl)(Q)

Fill Right

(Ctrl)(R)

Moves to the right of the region or next region

(Ctrl)(Right)

Save

(Ctrl)(S)

Insert Table

(Ctrl)(T)

Swith between Workbooks

(Ctrl)(Tab)

underline

(Ctrl)(U)

Moves to the top of the region or next region

(Ctrl)(Up)

Paste

(Ctrl)(V)

Cut

(Ctrl)(X)

Redo/Repeat

(Ctrl)(Y)

Moves left to the next blank cell

(Shift)(Ctrl)(F4)

Wrap Text

(Shift)(Ctrl)(W)

select cells while moving down

(Shift)(Down)

Select in end mode

(Shift)(End)

Enter and move up

(Shift)(Enter)

Open context Menu

(Shift)(F10)

Insert new worksheet

(Shift)(F11)

moves right to the next blank cell

(Shift)(F4)

Previous Pane or Area

(Shift)(F6)

Open Thesaurus

(Shift)(F7)

add to selection

(Shift)(F8)

Undo

(Ctrl)(Z)

Delete cell content

(Del)

Move down one cell

(Down)

puts excel in end mode

(End)

Enter a formula into a cell or move to the next cell

(Enter)

Escape out of edit mode

(Esc)

Help

(F1)

Select the menu bar

(F10)

Save As

(F12)

Toggles Edit / Enter Mode

(F2)

Paste Name

(F3)

Repeat last action/ toggle through absolute and relative reference

(F4)

open goto dialog box

(F5)

Spell Check

(F7)

Extended Selection Mode

(F8)

Calculate

(F9)

Moves to the front of the row

(Home)

Move Left one cell/ Move one character to the left

(Left)

Jumps one Page down

(Pg Dn)

Jumps one page up

(Pg Up)

Move right one cell/ moves one character right

(Right)

Apply comma format

(Shift)(Ctrl)(!)

Enter the current time

(Shift)(Ctrl)(;)

Hide Ribbons, Tabs and Status Bar

(Shift)(Ctrl)(F1)

Calculate Sheet

(Shift)(F9)

select cells while moving left

(Shift)(Left)

Select cells to the next page

(Shift)(PgDn)

Select cells to the previous page

(Shift)(PgUp)

select cells while moving right

(Shift)(Right)

Select the active column

(Shift)(Space)

Tab to Previous Cell, tool, Tab stop or object

(Shift)(Tab)

Select cells while moving up

(Shift)(Up)

open the context menu

(Shift),(F10)

Enter a Space/ Select item or checkbox

(Space)

Tab to next cell, tool, Tab stop or object

(Tab)

Move up one cell or item

(Up)


Kaugnay na mga set ng pag-aaral

Pharmacology Comprehensive Study Guide: Section 2

View Set

Chapter 2 - Evaluating Nutrition Information

View Set

Chapter 4: Policy riders provision etc.

View Set

Chapter 3 - Real Estate Financing Principles

View Set