8804949888

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
8804949888

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
8804949888

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.
Ctrl + Shift + Right
204 Select all cells from the current cell to the rightmost cell of the data.
Arrow
205 Ctrl + Shift + Left Arrow Select all cells from the current cell to the leftmost cell of the data.
Ctrl + Shift + Down
206 Select all cells from the current cell to the bottommost cell of the data.
Arrow
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.
8804949888

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.
Ctrl + Alt + Shift +
262 Open the Excel Theme Gallery.
T
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.
Open the Format Cells dialog box (Fill tab) to change background
267 Ctrl + Shift + P
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.
8804949888

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)

Ctrl + Shift + Down
301 Select down to the last filled cell in the column.
Arrow
Ctrl + Shift + Right
302 Select right to the last filled cell in the row.
Arrow
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.