Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Microsoft Excel > Keyboard Shortcuts > Flashcards

Keyboard Shortcuts Flashcards

1
Q

Jump to Bottom of Data

A

Ctrl-Down Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Jump to Top of Data

A

Ctrl-Up Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Go to Previous Sheet

A

Ctrl-Page Up

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Go to Next Sheet

A

Ctrl-Page Down

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Select All Data in Column

A

Ctrl-Shift-Down Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Select Whole Column

A

Ctrl-Space

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Select All Data in Row

A

Shift-Space

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Select All Data in Region

A

Ctrl-A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Filter

A

Ctrl-Shift-L

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Find

A

Ctrl-F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Flash Fill

A

Ctrl-E

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Select Discontinuous Cells

A

Shift-F8

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Spell Check

A

F7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Automatically Add Sum Totals for Columns and/or Rows

A

Alt-=

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Remove Duplicates

A

Alt-A-M

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Sort A-Z

A

Alt-A-S-A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Sort Z-A

A

Alt-A-S-D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Delete Row / Delete Column

A

Ctrl-minus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Copy Selected Object or Data

A

Ctrl-D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Format Cells

A

Ctrl-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Create Data Table

22
Q

Autoformat Data Tables

23
Q

Format As Currency

A

Ctrl-Shift-4

24
Q

Format As 2 Decimal Place Number

A

Ctrl-Shift-1

25
Q

Paste as Value

A

Ctrl-Alt-V-V-Enter or Alt-E-S-V-Enter

26
Q

Paste as Formulas

A

Alt-E-S-F-Enter

27
Q

Insert Row / Insert Column

A

Ctrl-Shift-plus

28
Q

Things to do with Left Click & Drag (both Row & Column)

A

Left Click & Drag&raquo_space; Move
Shift - Left Click & Drag&raquo_space; Insert
Ctrl - Shift - Left Click & Drag&raquo_space; Duplicate

29
Q

Filter by Value

A

Keyboard Menu -E-V

30
Q

Cycle through Excel Instance

A

Ctrl-Tab or Ctrl-Shift-Tab

31
Q

Create Table

32
Q

Copy to the right

33
Q

Resize object sticking to the Grid

A

By Pressing Alt

34
Q

Move Object by locking one of the axis

A

By Pressing Shift

35
Q

View all the formulas

36
Q

Display All Values From Top till Previous Cell

A

Alt - Down Arrow

37
Q

Save As Dialog Box

38
Q

Go to Dialog Box

A

F5 or Ctrl-G
Go to Special From this dialog box&raquo_space; Alt - S

39
Q

Insert Hyperlink

40
Q

Insert Default Chart

A

Select The Data & Alt-F1

41
Q

Hide Row / Column

A

Row = Ctrl-0
Column = Ctrl-9

42
Q

Select Visible Cell or Check if any row/column hidden

43
Q

Highlights the values which doesn’t have formulas in them. The values which has formulas is not highlighted.

A

F5 - Alt - S - O - X

44
Q

Open User Form To Enter Data in Table

A

Convert the data into Table & then:
Alt - D - O

45
Q

Create default chart

A

Select the data & Alt - F1

46
Q

Select multiple cell without pressing Ctrl Key

A

Shift - F8

47
Q

Rename Sheet

A

Alt - H - O - R

48
Q

Delete the sheet

A

Alt - H - D - S

49
Q

Autoformatting

A

Alt - O - A

50
Q

Full Screen

A

Alt - V - U

Microsoft Excel (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions