Home Tab

1

Copy

Ctrl + C

2

Cut

Ctrl + X

3

Paste

Ctrl + V

4

Undo

Ctrl + Z

5

Redo

Ctrl + Y

6

Bold

Ctrl + B

7

Italic

Ctrl + I

8

Underline

Ctrl + U

9

Format Cells Dialog

Ctrl + 1

10

Toggle Filters

Ctrl + Shift + L

11

Insert New Row/Column

Ctrl + Shift + "+"

12

Delete Row/Column

Ctrl + "-"

13

Flash Fill

Ctrl + E

14

Change Cell Color

Alt + H + H

15

Change Font

Alt + H + F

16

Align Center

Alt + H + A

17

Apply Number Format (Number)

Ctrl + Shift + "!"

18

Apply Currency Format

Ctrl + Shift + "$"

19

Apply Percentage Format

Ctrl + Shift + "%"

20

Apply Date Format

Ctrl + Shift + "#"

Insert Tab

21

Alt + N + V

Insert Pivot Table

22

Alt + N + R

Insert Chart

23

Alt + N + C

Insert Column

24

Alt + N + L

Insert Line Break

25

Ctrl + K

Insert Hyperlink

26

Ctrl + Shift + "+"

Insert Row/Column

27

Alt + N + P

Insert Picture

28

Alt + N + S

Insert Symbol

29

Alt + N + T

Insert Table

30

Alt + N + W

Insert Text Box

31

Ctrl + Shift + M

Insert New Sheet

32

Alt + N + B

Insert Border

33

Alt + N + F

Insert a Shape

34

Alt + N + D

Insert a Drawing

35

Alt + N + A

Insert Audio

36

Alt + N + V

Insert a Video

37

Alt + N + U

Insert a Web Object

38

Ctrl + Shift + F3

Define Name

39

Ctrl + Alt + F9

Recalculate All Formulas

40

Ctrl + Shift + T

Insert New Comment

Page Layout Tab

41

Alt + P + S

Page Setup

42

Alt + P + C

Change Page Orientation

43

Alt + P + M

Change Margins

44

Alt + P + G

Set Gridlines

45

Alt + P + H

Print Area

46

Alt + P + W

Wrap Text

47

Alt + P + K

Change Background Color

48

Alt + P + F

Add Footer

49

Alt + P + E

Add Header

50

Ctrl + Alt + P

Print Preview

51

Alt + P + N

Set Page Breaks

52

Alt + P + L

Set Print Titles

53

Alt + P + U

Insert a Page Number

54

Alt + P + R

Set Print Area

55

Alt + P + T

Insert Theme

56

Ctrl + P

Print

57

Ctrl + F2

Open Print Preview

58

Ctrl + Shift + F12

Open Print Dialog Box

59

Alt + P + D

Page Setup Dialog

60

Alt + P + Z

Add Watermark

Formulas Tab

61

Alt + M + F

Insert Function

62

Alt + M + A

AutoSum

63

Alt + M + O

Insert Name

64

Alt + M + D

Define Name

65

Alt + M + N

Name Manager

66

Alt + M + C

Calculate Now

67

Alt + M + R

Show Formulas

68

Ctrl + Shift + F9

Recalculate Active Workbook

69

Alt + M + V

Create a Variable

70

Alt + M + P

Paste Function

71

Ctrl + Shift + U

Toggle Formula Bar

72

Ctrl + Shift + L

Show Formulas

73

Ctrl + "`"

Show Formulas

74

Ctrl + Shift + Alt + F9

Calculate All Workbooks

75

Alt + M + S

Insert Subtotal

76

Ctrl + F3

Open Name Manager

77

Ctrl + Shift + F5

Go To Special

78

Ctrl + Shift + F1

Insert Function Dialog Box

79

F3

Paste Name

80

F9

Calculate Selected Formulas

Data Tab

81

Alt + A + S

Sort Data

82

Alt + A + F

Filter Data

83

Alt + A + T

Text to Columns

84

Alt + A + G

Group Data

85

Alt + A + U

Ungroup Data

86

Alt + A + I

Import Data

87

Ctrl + Shift + T

Insert Table

88

Ctrl + Shift + L

Add/Remove Filter

89

Alt + A + H

Hide Rows

90

Alt + A + W

Unhide Rows

91

Alt + A + M

Remove Duplicates

92

Alt + A + N

Text to Columns Wizard

93

Alt + A + V

Consolidate Data

94

Ctrl + Shift + E

Refresh All Data

95

Ctrl + T

Create a Table

96

Ctrl + Shift + K

Insert Subtotal

97

Alt + A + C

Clear Contents

98

Alt + A + P

Print

99

Ctrl + Alt + Shift + F9

Recalculate All Data

100

Ctrl + Shift + F12

Data Form

Review Tab

101

Alt + R + S

Spell Check

102

Alt + R + T

Track Changes

103

Alt + R + W

New Comment

104

Ctrl + Alt + M

Insert New Comment

105

Shift + F2

Add/Edit Comment

106

Ctrl + F7

Move the Comment Box

107

Ctrl + F8

Resize the Comment Box

108

Alt + R + G

Group Comments

109

Ctrl + Shift + K

Review Comments

110

Ctrl + Shift + N

Open Review Pane

111

Ctrl + Shift + Q

Review Document Properties

112

Alt + R + F

Find and Replace Comments

113

Alt + R + P

Print Comments

114

Alt + R + C

Protect Workbook

115

Ctrl + R

Remove Comments

116

Ctrl + Alt + A

Accept Changes

117

Ctrl + Alt + R

Reject Changes

118

Alt + R + H

Hide Comments

119

Alt + R + L

Lock Cell Comments

120

Ctrl + Shift + I

Insert Comment

View Tab

121

Alt + W + F

Freeze Panes

122

Alt + W + S

Split Window

123

Ctrl + F1

Show/Hide Ribbon

124

Ctrl + Shift + F9

Toggle Full Screen

125

Alt + W + T

Show Gridlines

126

Alt + W + N

New Window

127

Alt + W + R

Arrange Windows

128

Ctrl + Tab

Switch Between Open Workbooks

129

Ctrl + Page Up

Move to the Previous Worksheet

130

Ctrl + Page Down

Move to the Next Worksheet

131

Ctrl + Alt + F4

Close the Window

132

Alt + W + V

Zoom In

133

Alt + W + Z

Zoom Out

134

Ctrl + Shift + F9

Zoom In/Out Window

135

Alt + W + P

Page Layout View

136

Alt + W + L

Normal View

137

Alt + W + H

Hide Gridlines

138

Ctrl + 9

Hide Row

139

Ctrl + 0

Hide Column

140

Alt + W + O

Open Workbook

Help Tab

141

F1

Open Help

142

Alt + H + T

Show Keyboard Shortcuts

143

Alt + H + F

Get Help

144

Alt + H + A

Ask Questions

145

Ctrl + F1

Help System

145

Ctrl + F1

Help System

General Shortcuts (continued)

146

Ctrl + A

Select All

147

Ctrl + D

Fill Down

148

Ctrl + R

Fill Right

149

Ctrl + Shift + Right Arrow

Select to the right edge

150

Ctrl + Shift + Left Arrow

Select to the left edge

151

Ctrl + Shift + Down Arrow

Select to the bottom edge

152

Ctrl + Shift + Up Arrow

Select to the top edge

153

Shift + Space

Select the entire row

154

Ctrl + Space

Select the entire column

155

Ctrl + Shift + "+"

Insert new row/column

156

Ctrl + "-"

Delete row/column

157

Ctrl + Shift + "~"

Apply General Number Format

158

Ctrl + Shift + "^"

Apply Scientific Format

159

Ctrl + Shift + "!"

Apply Number Format

160

Ctrl + Shift + "$"

Apply Currency Format

161

Ctrl + Shift + "%"

Apply Percentage Format

162

Ctrl + Shift + "#"

Apply Date Format

163

Ctrl + Shift + "&"

Add border around selected cells

164

Ctrl + 1

Open Format Cells dialog box

165

Ctrl + Shift + U

Expand formula bar

166

Ctrl + T

Create a table

167

F2

Edit active cell

168

Ctrl + F3

Open Name Manager

169

Alt + E, S, V

Paste special

170

Ctrl + Shift + V

Paste values only

171

Alt + E, S, T

Paste transposed

172

Ctrl + K

Insert hyperlink

173

Alt + F1

Create chart in current worksheet

174

F4

Repeat last action

175

Ctrl + 5

Strikethrough

176

Ctrl + N

Open a new workbook

177

Ctrl + O

Open an existing workbook

178

Ctrl + P

Open the Print dialog box

179

Ctrl + S

Save workbook

180

Ctrl + W

Close workbook

181

Ctrl + F

Open Find and Replace

182

Ctrl + H

Open Find and Replace with Replace tab

183

Ctrl + Shift + F

Open Format Cells dialog box (Font tab)

184

Ctrl + Shift + P

Open Format Cells dialog box (Font size)

185

Alt + Enter

Start a new line within a cell

186

Ctrl + Shift + L

Toggle AutoFilter

187

Ctrl + 9

Hide rows

188

Ctrl + 0

Hide columns

189

Ctrl + 1

Open Format Cells dialog box

190

Ctrl + F2

Print Preview

191

F7

Spell Check

192

Ctrl + Shift + N

Open New Worksheet

193

Ctrl + Shift + T

Insert table

194

Ctrl + Shift + K

Insert a chart

195

Ctrl + R

Fill selected cells to the right

196

Ctrl + D

Fill selected cells downward

197

Ctrl + F3

Name Manager

198

Ctrl + Page Up

Switch to previous worksheet

199

Ctrl + Page Down

Switch to next worksheet

200

Ctrl + F4

Close the workbook

Selection Shortcuts

201

Ctrl + A

Select all cells in the worksheet.

202

Ctrl + Shift + Space

Select the entire row.

203

Shift + Space

Select the entire column.

204

Ctrl + Shift + Right

Arrow

Select all cells from the current cell to the rightmost cell of the data.

205

Ctrl + Shift + Left Arrow

Select all cells from the current cell to the leftmost cell of the data.

206

Ctrl + Shift + Down

Arrow

Select all cells from the current cell to the bottommost cell of the data.

207

Ctrl + Shift + Up Arrow

Select all cells from the current cell to the topmost cell of the data.

208

Shift + Arrow keys

Extend the selection by one cell.

209

Ctrl + Arrow keys

Move to the edge of the data region in any direction.

210

Ctrl + Shift + Arrow keys

Select to the edge of the data region in any direction.

211

Ctrl + Shift + End

Select from the current cell to the last used cell on the worksheet.

212

Ctrl + Shift + Home

Select from the current cell to the first cell in the worksheet.

213

Alt + ;

Select visible cells only (useful when working with filtered data).

214

Ctrl + Shift + L

Toggle filters on and off.

215

Ctrl + Shift + "+"

Insert new row/column.

216

Ctrl + "-"

Delete the selected row or column.

217

Ctrl + Shift + Page Up

Select the previous worksheet.

218

Ctrl + Shift + Page Down

Select the next worksheet.

Movement Shortcuts

219

Ctrl + Arrow keys

Move to the edge of data in the direction of the arrow.

220

Ctrl + Home

Move to the beginning of the worksheet (A1).

221

Ctrl + End

Move to the last used cell in the worksheet.

222

Arrow keys

Move one cell in the direction of the arrow.

223

Page Up

Move one screen up.

224

Page Down

Move one screen down.

225

Alt + Page Up

Move one screen to the left.

226

Alt + Page Down

Move one screen to the right.

227

Ctrl + Tab

Switch between open Excel workbooks.

228

Ctrl + Page Up

Move to the previous worksheet.

229

Ctrl + Page Down

Move to the next worksheet.

230

Home

Move to the first cell of the current row.

231

Ctrl + Home

Move to the first cell in the worksheet (A1).

232

Ctrl + Shift + Home

Select all cells from the current cell to the first cell (A1).

233

Ctrl + Shift + End

Select from the current cell to the last used cell.

234

Alt + Left Arrow

Move to the previous group of cells in the same row.

235

Alt + Right Arrow

Move to the next group of cells in the same row.

236

Tab

Move one cell to the right.

237

Shift + Tab

Move one cell to the left.

Customize Ribbon Shortcuts

238

Alt + F10

Show the ribbon commands

239

Ctrl + F1

Hide or show the ribbon

240

Alt + Q

Open the "Tell me what you want to do" search box

241

Alt + H

Open the Home tab of the ribbon

242

Alt + N

Open the Insert tab of the ribbon

243

Alt + P

Open the Page Layout tab of the ribbon

244

Alt + M

Open the Formulas tab of the ribbon

245

Alt + A

Open the Data tab of the ribbon

246

Alt + R

Open the Review tab of the ribbon

247

Alt + W

Open the View tab of the ribbon

248

Ctrl + Shift + F

Open the Font dialog box in the Home tab

249

Ctrl + Shift + O

Open the Format Cells dialog box

250

Alt + F9

Toggle between showing and hiding formulas in the worksheet

251

Alt + E, S, V

Open the Paste Special dialog box

252

Ctrl + Shift + F10

Activate the ribbon's contextual tab

253

Alt + F

Open the File tab (Backstage view)

254

Alt + H, F, D

Open the Format Cells dialog (Font tab)

255

Alt + H, F, B

Change the font size

256

Alt + H, A, C

Center align the selected cell(s)

257

Alt + H, A, L

Left align the selected cell(s)

258

Alt + H, A, R

Right align the selected cell(s)

259

Alt + H, D, C

Clear contents of selected cell(s)

260

Alt + H, M, L

Minimize the ribbon

Change Theme and Appearance

261

Alt + H, T, S

Change the theme of the workbook.

262

Ctrl + Alt + Shift +

T

Open the Excel Theme Gallery.

263

Alt + W, K

Change the workbook color.

264

Alt + H, A, H

Highlight selected cells.

265

Alt + H, A, U

Underline selected text.

266

Alt + H, T, C

Change cell styles.

267

Ctrl + Shift + P

Open the Format Cells dialog box (Fill tab) to change background

color.

268

Ctrl + Shift + B

Change the background color.

269

Ctrl + Shift + N

Change cell styles to normal.

270

Alt + H, E, T

Clear all formatting.

271

Alt + H, G, T

Toggle the gridlines on/off.

General Interface and Other Shortcuts

272

F1

Open Help

273

Ctrl + F

Open the Find and Replace dialog box (Find tab).

274

Ctrl + H

Open the Find and Replace dialog box (Replace tab).

275

Ctrl + G

Open the "Go To" dialog box.

276

Ctrl + F3

Open Name Manager.

277

Ctrl + Shift + F3

Create name from selection.

278

Alt + E, A, A

Select the entire worksheet.

279

Ctrl + K

Insert a hyperlink.

280

Ctrl + Shift + K

Insert a hyperlink to a new file.

281

Ctrl + 9

Hide rows.

282

Ctrl + 0

Hide columns.

283

Ctrl + Shift + 9

Unhide rows.

284

Ctrl + Shift + 0

Unhide columns.

285

Ctrl + Shift + T

Toggle visibility of task pane.

286

Alt + F, A

Save As dialog box.

287

Alt + F, L

Open the Options window.

288

Ctrl + Alt + F9

Recalculate all open workbooks.

289

Ctrl + Shift + F12

Open the Print dialog box.

290

Ctrl + P

Print the current sheet.

291

Ctrl + Shift + F

Open Format Cells dialog box.

292

Ctrl + Shift + "+"

Insert new row/column.

293

Ctrl + L

Toggle filter.

294

Alt + F4

Close Excel.

295

Ctrl + W

Close the active workbook.

296

Ctrl + F4

Close the current workbook.

297

Ctrl + Q

Open Quick Analysis tool.

298

Ctrl + Shift + U

Expand the formula bar.

299

Ctrl + Shift + Alt + F9

Force a complete recalculation.

300

F2

Edit active cell content.

Selection Shortcuts (continued)

301

Ctrl + Shift + Down

Arrow

Select down to the last filled cell in the column.

302

Ctrl + Shift + Right

Arrow

Select right to the last filled cell in the row.

303

Ctrl + Shift + Left Arrow

Select left to the first filled cell in the row.

304

Ctrl + Shift + Up Arrow

Select up to the first filled cell in the column.

305

Ctrl + Shift + End

Select from the current cell to the last used cell in the worksheet.

306

Ctrl + Shift + Home

Select from the current cell to the first cell (A1) of the worksheet.

307

Shift + Space

Select the entire row of the active cell.

308

Ctrl + Space

Select the entire column of the active cell.

309

Ctrl + Shift + Space

Select the entire worksheet (including headers).

310

Alt + ;

Select visible cells only (useful when working with filtered data).

311

Ctrl + 9

Hide selected rows.

312

Ctrl + 0

Hide selected columns.

313

Ctrl + Shift + 9

Unhide rows.

314

Ctrl + Shift + 0

Unhide columns.

315

Ctrl + F8

Start dragging the selection (used to move the selection box).

316

Ctrl + 1

Open the Format Cells dialog box.

317

Ctrl + F3

Open the Name Manager.

318

Ctrl + Shift + F3

Define names from selection.

319

Alt + F1

Create a chart from the selected data in the current worksheet.

320

Alt + Shift + F1

Insert a new worksheet.

Movement Shortcuts (continued)

321

Ctrl + Home

Move the cursor to the beginning of the worksheet (A1).

322

Ctrl + End

Move to the last used cell in the worksheet.

323

Ctrl + Page Up

Move to the previous worksheet.

324

Ctrl + Page Down

Move to the next worksheet.

325

Alt + Page Up

Move one screen to the left.

326

Alt + Page Down

Move one screen to the right.

327

Ctrl + Arrow keys

Move to the edge of the data in the direction of the arrow key.

328

Alt + Left Arrow

Move to the previous group of cells in the current row.

329

Alt + Right Arrow

Move to the next group of cells in the current row.

330

Page Up

Move one screen up.

331

Page Down

Move one screen down.

332

Home

Move to the first cell of the current row.

333

Ctrl + Arrow keys

Move to the end of the data in the current direction (left, right, up, down).

334

Ctrl + Shift + Arrow keys

Select to the edge of the data in the current direction (left, right, up, down).

335

Alt + Tab

Switch between open Excel workbooks.

336

Ctrl + Tab

Switch between open Excel windows (workbooks).

337

Shift + Tab

Move to the previous cell.

338

Ctrl + Shift + Page Up

Select the previous worksheet.

339

Ctrl + Shift + Page Down

Select the next worksheet.

340

Alt + F4

Close the active workbook.

Customize Ribbon Shortcuts

341

Alt + F10

Show the ribbon commands.

342

Ctrl + F1

Hide or show the ribbon.

343

Alt + Q

Open the "Tell me what you want to do" search box.

344

Alt + H

Open the Home tab of the ribbon.

345

Alt + N

Open the Insert tab of the ribbon.

346

Alt + P

Open the Page Layout tab of the ribbon.

347

Alt + M

Open the Formulas tab of the ribbon.

348

Alt + A

Open the Data tab of the ribbon.

349

Alt + R

Open the Review tab of the ribbon.

350

Alt + W

Open the View tab of the ribbon.

351

Ctrl + Shift + F

Open the Format Cells dialog box (Font tab).

352

Ctrl + Shift + P

Open the Format Cells dialog box (Font Size tab).

353

Alt + H, F, D

Open the Format Cells dialog box (Font tab).

354

Ctrl + F3

Open the Name Manager.

355

Alt + W + T

Show or hide gridlines.

356

Alt + H, A, C

Center align the selected cell(s).

357

Alt + H, A, L

Left align the selected cell(s).

358

Alt + H, A, R

Right align the selected cell(s).

359

Alt + H, D, C

Clear contents of selected cell(s).

360

Alt + H, M, C

Merge and center the selected cells.

361

Ctrl + F9

Minimize the current workbook window.

362

Ctrl + F10

Maximize or restore the current workbook window.

363

Alt + F11

Open the Visual Basic for Applications (VBA) editor.

Change Theme and Appearance

364

Alt + H, T, S

Change the theme of the workbook.

365

Ctrl + Alt + Shift + T

Open the Excel Theme Gallery.

366

Alt + W, K

Change the workbook color.

367

Ctrl + Shift + P

Open the Format Cells dialog box (Fill tab) to change background color.

368

Ctrl + Shift + B

Change the background color.

369

Ctrl + Shift + N

Change cell styles to normal.

370

Ctrl + Shift + F

Open the Format Cells dialog box (Font tab) to change text font.

371

Alt + W, G

Toggle the gridlines on or off.

372

Ctrl + 1

Open the Format Cells dialog box.

373

Ctrl + F3

Open the Name Manager to manage named ranges.

374

Ctrl + Shift + C

Open the "Copy Format" dialog.

375

Alt + H, A, W

Wrap text in selected cell(s).

376

Ctrl + Shift + U

Expand the formula bar.

377

Alt + H, F, F

Add or change the font family.

378

Alt + H, F, S

Add or change the font size.

379

Alt + H, F, L

Add or change the font color.

380

Ctrl + Shift + Q

Apply or remove the outline border on selected cells.

General Interface and Other Shortcuts

381

Ctrl + P

Open the Print dialog box.

382

Ctrl + W

Close the active workbook.

383

Ctrl + S

Save the current workbook.

384

Ctrl + N

Create a new workbook.

385

Ctrl + O

Open an existing workbook.

386

Ctrl + F

Open the Find and Replace dialog box (Find tab).

387

Ctrl + H

Open the Find and Replace dialog box (Replace tab).

388