Excel 500 Shorcut key list

🔹 File & Workbook

1. Ctrl + N – Create new workbook

2. Ctrl + O – Open existing workbook

3. Ctrl + S – Save workbook

4. F12 – Save As

5. Ctrl + P – Print

6. Ctrl + F2 – Print Preview

7. Ctrl + W – Close workbook

8. Ctrl + F4 – Close Excel window

9. Alt + F4 – Exit Excel

10. Ctrl + Tab – Switch to next workbook

11. Ctrl + Shift + Tab – Switch to previous workbook

🔹 Basic Editing

12. Ctrl + C – Copy

13. Ctrl + X – Cut

14. Ctrl + V – Paste

15. Ctrl + Z – Undo

16. Ctrl + Y – Redo

17. Delete – Clear cell contents

18. Backspace – Delete one character left

19. Ctrl + Backspace – Show active cell

20. Ctrl + Alt + V – Paste Special dialog

21. Alt + E, S, V – Paste Special values

🔹 Navigation

22. Arrow Keys – Move cell by cell

23. Ctrl + Arrow Key – Jump to edge of data region

24. Ctrl + Home – Go to A1 cell

25. Ctrl + End – Go to last used cell

26. Page Up – Move one screen up

27. Page Down – Move one screen down

28. Alt + Page Up – One screen left

29. Alt + Page Down – One screen right

30. Tab – Next cell right

31. Shift + Tab – Previous cell left

32. Ctrl + G / F5 – Go To dialog

🔹 Row & Column

33. Ctrl + Space – Select entire column

34. Shift + Space – Select entire row

35. Ctrl + Shift + + – Insert row/column

36. Ctrl + - – Delete row/column

37. Ctrl + 9 – Hide row

38. Ctrl + Shift + 9 – Unhide row

39. Ctrl + 0 – Hide column

40. Ctrl + Shift + 0 – Unhide column

41. Alt + H, D, R – Delete row

42. Alt + H, D, C – Delete column

🔹 Formatting

43. Ctrl + B – Bold

44. Ctrl + I – Italic

45. Ctrl + U – Underline

46. Ctrl + 1 – Format cells dialog

47. Ctrl + Shift + $ – Currency format

48. Ctrl + Shift + % – Percentage format

49. Ctrl + Shift + # – Date format

50. Ctrl + Shift + @ – Time format

51. Ctrl + Shift + ! – Number format

52. Ctrl + Shift + ^ – Exponential format

53. Alt + H, H – Fill color

54. Alt + H, F, C – Font color

🔹 Worksheets

55. Ctrl + Page Up – Previous sheet

56. Ctrl + Page Down – Next sheet

57. Shift + F11 – Insert new sheet

58. Alt + H, D, S – Delete sheet

59. Alt + O, H, R – Rename sheet

60. Ctrl + Shift + F – Format sheet tab color

🔹 Formulas

61. = – Start formula

62. Alt + = – AutoSum

63. Shift + F3 – Insert function

64. Ctrl + Shift + Enter – Array formula

65. Ctrl + ‘ – Copy formula from above

66. F4 – Absolute/Relative toggle

67. Ctrl + Shift + A – Insert function arguments

68. Alt + M, F, X – Evaluate formula

69. Ctrl + `[ – Show formula precedents

70. Ctrl + ] – Show dependents

🔹 Editing Cells

71. F2 – Edit active cell

72. Shift + F2 – Add/Edit comment

73. Ctrl + D – Fill down

74. Ctrl + R – Fill right

75. Ctrl + ; – Insert current date

76. Ctrl + Shift + : – Insert current time

77. Ctrl + Shift + “ – Copy value from above

78. Alt + H, E, A – Clear all

79. Alt + H, E, F – Clear formats

80. Alt + H, E, C – Clear comments

🔹 Data

81. Ctrl + Shift + L – Toggle AutoFilter

82. Alt + D, F, F – Apply/Remove Filter

83. Alt + A, T – Sort ascending

84. Alt + A, S, D – Sort descending

85. Alt + A, Q – Remove duplicates

86. Alt + N, V – Insert PivotTable

87. Alt + A, M – Consolidate data

88. Alt + A, G – Group

89. Alt + A, U, G – Ungroup

90. Alt + A, E – Text to Columns

🔹 Charts

91. Alt + F1 – Create chart in same sheet

92. F11 – Create chart in new sheet

93. Alt + J, C – Chart tools menu

94. Ctrl + Shift + F1 – Toggle full-screen chart

95. Alt + N, R – Insert recommended chart

🔹 Other Useful

96. F7 – Spell check

97. Shift + F7 – Thesaurus

98. Ctrl + K – Insert hyperlink

99. Ctrl + Shift + U – Expand/Collapse formula bar

100. Alt + F8 – Macro dialog

🔹 Function Keys (F1–F12 Special Uses)

101. F1 – Excel Help

102. Shift + F1 – What’s This? (Help about selected item)

103. Ctrl + F1 – Show/Hide Ribbon

104. Alt + F1 – Create chart in same sheet

105. Alt + Shift + F1 – Insert new worksheet

106. F2 – Edit active cell

107. Shift + F2 – Add/Edit comment

108. Ctrl + F2 – Print Preview

109. F3 – Paste name (if named ranges exist)

110. Shift + F3 – Insert Function

111. F4 – Repeat last action

112. Ctrl + F4 – Close window

113. Alt + F4 – Close Excel

114. F5 – Go To dialog

115. Shift + F5 – Find

116. Ctrl + F5 – Restore window size

117. F6 – Move between panes in workbook

118. Shift + F6 – Move backward between panes

119. Ctrl + F6 – Next workbook window

120. Ctrl + Shift + F6 – Previous workbook window

121. F7 – Spell check

122. Ctrl + F7 – Move window

123. F8 – Extend selection mode

124. Shift + F8 – Add to selection

125. Ctrl + F8 – Resize window

126. F9 – Calculate all worksheets

127. Shift + F9 – Calculate active sheet

128. Ctrl + Alt + F9 – Force calculate all sheets

129. Ctrl + Alt + Shift + F9 – Check dependent formulas

130. F10 – Show menu bar (like Alt key)

131. Shift + F10 – Context menu (like Right-click)

132. Ctrl + F10 – Maximize/Restore window

133. F11 – Create chart in new sheet

134. Shift + F11 – New worksheet

135. Alt + F11 – Open VBA Editor

136. F12 – Save As

🔹 Selection & Highlight

137. Ctrl + Shift + Arrow – Select data to edge

138. Shift + Arrow – Extend selection one cell

139. Ctrl + Shift + Space – Select entire worksheet

140. Ctrl + A – Select all

141. Ctrl + Shift + End – Select to last used cell

142. Ctrl + Shift + Home – Select to A1

143. Shift + Page Down – Select one screen down

144. Shift + Page Up – Select one screen up

145. Ctrl + Shift + Page Down – Select next sheet

146. Ctrl + Shift + Page Up – Select previous sheet

🔹 Workbook Management

147. Ctrl + Shift + N – New workbook (based on template)

148. Alt + F2 – Save As dialog

149. Alt + F3 – Create new named range

150. Ctrl + Alt + F3 – Define name dialog

151. Alt + F8 – Run Macro

152. Alt + F11 – Open VBA Editor

153. Alt + F12 – Open Power Query Editor

🔹 Advanced Editing

154. Ctrl + Shift + Tab – Switch to previous workbook

155. Ctrl + [ – Jump to precedent cell

156. Ctrl + ] – Jump to dependent cell

157. Alt + Down Arrow – Open drop-down list in cell

158. Ctrl + Alt + L – Reapply filter

159. Ctrl + Alt + Shift + L – Clear filter

🔹 Pivot Table Shortcuts

160. Alt + N, V – Insert Pivot Table

161. Alt + J, T – Pivot Table Tools menu

162. Alt + Shift + Left Arrow – Collapse field

163. Alt + Shift + Right Arrow – Expand field

164. Alt + F5 – Refresh pivot table

165. Ctrl + Alt + F5 – Refresh all pivot tables

🔹 Cell & Range Operations

166. Ctrl + Shift + [Backslash] – Select cells with differences in a column

167. Ctrl + [Forward Slash] – Select array

168. Ctrl + [Asterisk] – Select current region

169. Ctrl + Shift + O – Select cells with comments

170. Ctrl + . (Period) – Move to next corner of selection

171. Ctrl + Enter – Fill all selected cells with current entry

172. Alt + Enter – Line break in same cell

173. Shift + Enter – Move up in selection

174. Tab – Move right in selection

175. Shift + Tab – Move left in selection

🔹 Charts & Graphics

176. Ctrl + Shift + F1 – Full screen chart

177. Alt + J, C, A – Add chart element

178. Alt + J, C, S – Switch row/column

179. Alt + J, C, L – Select chart layout

180. Alt + J, C, D – Change chart type

🔹 Outlining & Grouping

181. Alt + Shift + K – Hide detail (collapse)

182. Alt + Shift + J – Show detail (expand)

183. Alt + Shift + → – Group

184. Alt + Shift + ← – Ungroup

185. Ctrl + 8 – Show/hide outline symbols

🔹 Special Data Operations

186. Alt + A, M – Consolidate data

187. Alt + A, F, C – Advanced filter

188. Alt + A, F, F – Flash fill

189. Ctrl + E – Flash fill shortcut

190. Alt + A, K – Data validation

191. Alt + A, V, V – Circle invalid data

192. Alt + A, V, C – Clear validation circles

🔹 Miscellaneous

193. Ctrl + Shift + F – Open Format cells (Font tab)

194. Ctrl + Shift + P – Format cells (Font size)

195. Ctrl + 2 – Bold (alternative to Ctrl+B)

196. Ctrl + 3 – Italic (alternative to Ctrl+I)

197. Ctrl + 4 – Underline (alternative to Ctrl+U)

198. Ctrl + 5 – Strikethrough

199. Ctrl + 6 – Hide/Show objects

200. Ctrl + 7 – Show/Hide ribbon tabs

🔹 Clipboard & Paste Options

201. Ctrl + Alt + V, T – Paste formats only

202. Ctrl + Alt + V, V – Paste values only

203. Ctrl + Alt + V, F – Paste formulas only

204. Ctrl + Alt + V, C – Paste comments only

205. Ctrl + Alt + V, N – Paste validation only

206. Ctrl + Alt + V, W – Paste column widths

207. Ctrl + Alt + V, E – Paste everything except borders

208. Ctrl + Alt + V, R – Paste values & number formats

🔹 Window & View

209. Alt + W, F, F – Freeze panes

210. Alt + W, S – Split window

211. Alt + W, A – Arrange all windows

212. Ctrl + Alt + F5 – Refresh all windows/workbooks

213. Alt + W, Q – Zoom dialog

214. Alt + V, Z – Zoom controls

215. Alt + W, I – Switch to Page Break Preview

216. Alt + W, P – Switch to Page Layout View

217. Alt + W, N – Switch to Normal View

🔹 Comments & Notes

218. Shift + F2 – Add/Edit comment

219. Ctrl + Shift + O – Select all cells with comments

220. Alt + R, C – New comment (Excel 2016+)

221. Alt + R, D – Delete comment

222. Alt + R, A – Show all comments

223. Alt + R, H – Show/Hide selected comment

🔹 Named Ranges

224. Ctrl + F3 – Open Name Manager

225. Ctrl + Shift + F3 – Create names from selection

226. Alt + M, N – Define name dialog

227. Alt + M, P – Use in formula (apply names)

🔹 Tables

228. Ctrl + T – Create table

229. Ctrl + L – Create table (alternative)

230. Alt + J, T, R – Resize table

231. Alt + J, T, I – Insert table column to left

232. Alt + J, T, A – Insert table row above

233. Alt + J, T, D – Delete table row/column

234. Alt + J, T, O – Toggle table total row

🔹 Power Tools

235. Alt + A, P – Power Pivot window

236. Alt + N, X – Insert Power View report

237. Alt + A, Q – Remove duplicates

238. Alt + N, Q – Insert Power Query

239. Alt + N, D – Insert Data Model

🔹 Macros & VBA

240. Alt + F8 – Open Macro dialog

241. Alt + F11 – Open VBA Editor

242. Alt + F10 – Show Selection Pane

243. Alt + F9 – Toggle Field Codes (Excel linked objects)

244. Ctrl + Shift + F11 – Insert Excel 4.0 Macro sheet

245. Ctrl + Shift + P – Format macro dialoge

🔹 Special Navigation

246. Ctrl + [ (Bracket Left) – Jump to precedent cell

247. Ctrl + ] (Bracket Right) – Jump to dependent cell

248. Ctrl + Alt + Arrow Down – Drop-down menu in cell

249. Alt + Down Arrow – Select from AutoFilter list

250. Ctrl + Shift + F12 – Print preview (old style)

🔹 File & Security

251. Alt + F, I – Info (Workbook properties & protection)

252. Alt + F, R – Recent workbooks

253. Alt + F, T – Options dialog

254. Alt + R, P, S – Protect worksheet

255. Alt + R, P, W – Protect workbook

256. Alt + T, P, P – Set print area

257. Alt + T, P, S – Clear print area

🔹 Accessibility & Ease

258. Alt + Shift + F1 – Insert new worksheet

259. Ctrl + Shift + U – Expand/Collapse formula bar

260. Alt + Shift + F10 – Smart Tag menu

261. Ctrl + Alt + K – Insert hyperlink (alt method)

262. Ctrl + Shift + Tab – Cycle backward through open files

263. Alt + Tab – Switch between applications

🔹 Special Formatting

264. Ctrl + Shift + & – Apply outline border

265. Ctrl + Shift + _ – Remove border

266. Ctrl + Shift + ~ – Apply General format

267. Ctrl + Shift + + (on numpad) – Insert new cell

268. Ctrl + Alt + – (minus) – Delete selected cell

🔹 Clipboard (Extended)

269. Ctrl + Alt + V, H – Paste column widths only

270. Ctrl + Alt + V, D – Paste formulas & number formats

271. Ctrl + Alt + V, O – Paste formatting only

🔹 Miscellaneous Rare

272. Alt + Shift + F2 – Save workbook

273. Alt + Shift + F9 – Calculate active worksheet only

274. Alt + Shift + 1 – Collapse to level 1 outline

275. Alt + Shift + 9 – Collapse to level 9 outline

276. Ctrl + Alt + P – Print preview (legacy)

277. Ctrl + Alt + U – Ungroup pivot table items

278. Ctrl + Shift + # – Apply default date format

279. Ctrl + Shift + $ – Apply accounting format

280. Ctrl + Shift + ! – Apply number format with commas

🔹 Quick Access Toolbar

281. Alt + 1 – Run first quick access toolbar item

282. Alt + 2 – Run second toolbar item

283. Alt + 3 – Run third toolbar item

284. Alt + 4 – Run fourth toolbar item

285. Alt + 5–9 – Run respective toolbar items

🔹 Data Tools (Advanced)

286. Alt + A, Z – Text to Speech

287. Alt + A, C – Goal Seek

288. Alt + T, G – Solver add-in dialog

289. Alt + A, T, I – Import data

290. Alt + A, D – Remove outline

🔹 View & Display

291. Ctrl + Alt + Shift + V – Show formulas

292. Ctrl + ` (grave accent) – Toggle formulas view

293. Alt + W, V, G – Show gridlines

294. Alt + W, V, H – Show headings

295. Alt + W, V, Z – Zoom selection

296. Alt + W, R – New window

297. Alt + W, N – Arrange new windows

298. Ctrl + Alt + T – Trace precedents

299. Ctrl + Alt + D – Trace dependents

300. Alt + M, A, A – Remove all arrows (trace precedents/dependents)

🔹 Excel 365 & Cloud Features

301. Alt + Y, 1, O – Share workbook (cloud share)

302. Alt + Y, 2, R – Version history

303. Alt + Y, 2, S – AutoSave on/off

304. Alt + Y, 3, C – Comments pane (modern threaded comments)

305. Ctrl + Alt + Shift + I – Send feedback to Microsoft

306. Alt + Q – Search box (“Tell me what you want to do”)

🔹 Power Query

307. Alt + A, P, P – Open Power Query editor

308. Alt + A, P, L – Load to worksheet / Data Model

309. Alt + A, P, C – Close & load

310. Alt + A, P, R – Refresh query

311. Ctrl + Shift + M – Manage queries panel

🔹 Power Pivot

312. Alt + A, P, T – Power Pivot tab

313. Alt + A, P, D – Add to Data Model

314. Alt + A, P, V – Power Pivot window

315. Alt + A, P, K – Create KPI

316. Alt + A, P, H – Create hierarchy

🔹 Charts – Advanced

317. Alt + J, C, W – Move chart to another sheet

318. Alt + J, C, T – Change chart type

319. Alt + J, C, N – Chart data labels

320. Alt + J, C, A, L – Add legend

321. Alt + J, C, A, X – Add axis titles

322. Alt + J, C, A, T – Add chart title

🔹 Accessibility Shortcuts

323. Alt + Shift + A – Speak cells on/off

324. Alt + Shift + S – Stop speaking cells

325. Ctrl + Alt + Space – Narrator quick read

326. Alt + Shift + C – Close comment/task pane

327. Alt + Shift + N – New comment in accessibility mode

🔹 Custom Views

328. Alt + W, C – Custom views dialog

329. Alt + W, H – Hide window

330. Alt + W, U – Unhide window

331. Alt + W, B – Arrange side by side

332. Alt + W, K – Synchronous scrolling toggle

🔹 Data Analysis Tools

333. Alt + T, A, T – Analysis ToolPak add-in

334. Alt + D, T – Data Table

335. Alt + A, E, G – Forecast sheet

336. Alt + N, F – Insert forecast chart

337. Alt + T, G – Solver add-in dialog

338. Alt + T, D – Scenario manager

339. Alt + T, C – Data consolidation

🔹 Form Controls & Objects

340. Alt + N, F, D – Insert form controls

341. Alt + N, F, T – Insert ActiveX controls

342. Alt + J, D, E – Edit shape text

343. Alt + J, D, A – Align objects

344. Alt + J, D, R – Rotate object

345. Alt + J, D, S – Selection panel

🔹 Conditional Formatting

346. Alt + H, L, N – New conditional rule

347. Alt + H, L, D – Manage rules dialog

348. Alt + H, L, C – Clear rules from selection

349. Alt + H, L, S – Icon sets

350. Alt + H, L, B – Data bars

🔹 Smart Lookup / AI Features

351. Alt + Q, L – Smart Lookup (Bing)

352. Ctrl + Alt + Shift + L – Linked Data Types (Stocks, Geography)

353. Alt + A, F, I – Insert data from picture (Excel 365)

354. Ctrl + Shift + Y – Insights (AI analysis)

355. Alt + N, D, X – Insert 3D Maps

🔹 Filtering – Advanced

356. Alt + A, C, F – Clear filter

357. Alt + A, C, S – Search filter box

358. Alt + A, C, O – Filter by color

359. Alt + A, C, I – Filter by icon

360. Alt + A, C, T – Text filter submenu

🔹 Pivot Charts & Power BI

361. Alt + N, V, C – Insert PivotChart

362. Alt + J, T, A – Pivot table Analyze menu

363. Alt + J, T, R – Refresh pivot chart

364. Alt + J, T, O – Options dialog

365. Alt + J, T, G – Group field

366. Alt + J, T, U – Ungroup field

🔹 Page Layout / Printing

367. Alt + P, S, P – Page setup dialog

368. Alt + P, O – Orientation (Portrait/Landscape)

369. Alt + P, M – Margins menu

370. Alt + P, Z – Zoom settings

371. Alt + P, B – Breaks (Insert page break)

372. Alt + P, A – Print area

373. Alt + P, G – Background picture

374. Alt + P, H – Print headings

🔹 Review & Proofing

375. Alt + R, S – Spelling check (alternative)

376. Alt + R, T – Thesaurus

377. Alt + R, L – Language settings

378. Alt + R, P – Protect sheet/workbook

379. Alt + R, A – Accessibility checker

380. Alt + R, N – Notes (legacy comments)

🔹 Miscellaneous Advanced

381. Ctrl + Shift + ` (tilde) – Apply General format

382. Ctrl + Shift + K – Apply superscript

383. Ctrl + Shift + = – Apply subscript

384. Ctrl + 8 – Toggle outline symbols

385. Alt + F9 – Display field codes (Excel objects)

386. Alt + Shift + F11 – Open Microsoft Script Editor (legacy)

387. Ctrl + Alt + F1 – Insert new chart sheet (alternative)

388. Ctrl + Shift + L, S – Toggle slicer filters

389. Alt + N, S, L – Insert slicer

390. Alt + N, S, T – Insert timeline

🔹 Rare Legacy Shortcuts

391. Alt + D, O, O – Create outline

392. Alt + D, O, U – Remove outline

393. Alt + D, G, G – Data grouping

394. Alt + D, G, U – Data ungrouping

395. Ctrl + Shift + “ (quote) – Copy value from above

396. Ctrl + Alt + F2 – Open file dialog (old version)

397. Ctrl + Shift + F5 – Find & Replace (old Excel)

398. Ctrl + Alt + F6 – Switch to next Excel window (MDI mode)

399. Ctrl + Alt + F7 – Move Excel window (old Win)

400. Ctrl + Alt + F8 – Add to selection (old selection mode)

401. Alt + H + V + V → Paste Values

402. Alt + H + V + S → Paste Special dialog box

403. Alt + H + V + T → Paste Transpose

404. Alt + H + V + F → Paste Formatting

405. Alt + H + V + C → Paste Column Widths

406. Alt + H + V + M → Paste Values & Number Formats

407. Alt + H + V + E → Paste All Except Borders

408. Alt + H + V + A → Paste All using Source Theme

409. Alt + H + V + P → Paste Values & Source Formatting

410. Ctrl + Alt + V → Opens Paste Special dialog

411. Alt + H + D + R → Delete Row

412. Alt + H + D + C → Delete Column

413. Alt + H + D + S → Delete Sheet

414. Ctrl + Shift + "+" → Insert new cell/row/column

415. Ctrl + "−" → Delete cell/row/column

416. Ctrl + 9 → Hide row

417. Ctrl + Shift + 9 → Unhide row

418. Ctrl + 0 → Hide column

419. Ctrl + Shift + 0 → Unhide column (Windows setting may block)

420. Alt + H + O + H → Set row height

421. Alt + H + O + W → Set column width

422. Alt + H + O + I → AutoFit column width

423. Alt + H + O + A → AutoFit row height

424. Alt + H + O + E → Format Cells dialog (Alignment tab)

425. Alt + H + O + L → Rename sheet

426. Alt + H + O + M → Move/Copy sheet

427. Alt + H + O + R → Tab color

428. Alt + H + O + U → Unhide sheet

429. Alt + H + O + H → Hide sheet

430. Shift + Ctrl + F → Format Cells dialog (Font tab)

431. Ctrl + 1 → Format Cells dialog box (General)

432. Ctrl + Shift + F3 → Create names from selection

433. Ctrl + Shift + F4 → Find Next (after initial Find)

434. Shift + F4 → Repeat Find

435. Ctrl + Shift + F5 → Opens Find and Replace dialog

436. Ctrl + F3 → Name Manager

437. F3 → Paste Name (from Name Manager)

438. Ctrl + Shift + F6 → Switch to previous workbook window

439. Ctrl + F6 → Switch to next workbook window

440. Ctrl + Tab → Cycle through open Excel windows

441. Ctrl + Shift + Tab → Cycle backwards through open Excel windows

442. Alt + W + L → Show Normal view

443. Alt + W + P → Page Layout view

444. Alt + W + I → Page Break Preview

445. Alt + W + F → Freeze Panes

446. Alt + W + S → Split window

447. Alt + W + V + G → Gridlines on/off

448. Alt + W + V + H → Headings on/off

449. Alt + W + V + Z → Zoom dialog box

450. Alt + W + Q → Zoom control box

451. Alt + W + N → New window

452. Alt + W + A → Arrange All windows

453. Alt + W + M → Switch windows dropdown

454. Ctrl + Alt + Shift + F9 → Recheck dependent formulas

455. Ctrl + Shift + U → Expand/Collapse Formula Bar

456. Ctrl + Shift + K → Apply superscript formatting

457. Ctrl + Shift + L → Toggle AutoFilter on/off

458. Alt + Down Arrow (in filter cell) → Open filter dropdown

459. Alt + A + T → Apply filter

460. Alt + A + C → Clear filter

461. Alt + A + S + S → Sort Smallest to Largest

462. Alt + A + S + O → Sort Largest to Smallest

463. Alt + A + S + A → Custom Sort dialog

464. Alt + A + G + G → Remove Duplicates

465. Alt + A + M → Advanced Filter

466. Ctrl + T → Create Table

467. Ctrl + L → Create List (older version Table)

468. Ctrl + Shift + T → Select Table data only

469. Ctrl + Shift + Space (in Table) → Select entire Table

470. Tab (inside Table) → Add new row at bottom

471. Alt + J + T + D → Convert Table to Range

472. Alt + J + T + N → Table Name box

473. Alt + J + T + I → Insert Slicer

474. Alt + J + T + R → Resize Table

475. Alt + J + T + O → Total Row on/off

476. Alt + N + V → Insert PivotTable

477. Alt + N + V + T → PivotTable and PivotChart Wizard

478. Alt + J + T + C → Summarize with PivotChart

479. Alt + J + T + F → PivotTable Field List

480. Alt + J + T + B → Group selection

481. Alt + J + T + U → Ungroup selection

482. Alt + J + T + S → Refresh PivotTable

483. Alt + J + T + R → Report Layout

484. Alt + J + T + A → Show Values As

485. Alt + J + T + F → Field Settings

486. Alt + J + T + L → Value Field Settings

487. Alt + J + T + H → Hide Field List

488. Alt + J + T + O → Options menu for PivotTable

489. Alt + J + T + D → Drill Down details

490. Alt + J + T + E → Expand/Collapse field

491. Alt + J + C → PivotChart Tools menu

492. Alt + J + C + D → Change Chart Type in PivotChart

493. Alt + J + C + A → Move PivotChart

494. Alt + J + C + L → Legend Options

495. Alt + J + C + T → Chart Title options

496. Alt + J + C + F → Format PivotChart

497. Alt + J + C + G → Add Chart Element

498. Alt + J + C + K → Quick Layout

499. Alt + J + C + E → Switch Row/Column

500. Alt + J + C + M → Change Chart Type