Window Shortcuts

Uses of Shortcut keys

Ctrl + B
Bold highlighted selection
Ctrl + C
Copy selected text
Ctrl + X
Cut selected text
Ctrl + N
Open new/blank document
Ctrl + O
Open options
Ctrl + P
Open the print window
Ctrl + F
Open find box
Ctrl + I
Italicize highlighted selection
Ctrl + K
Insert link
Ctrl + U
Underline highlighted selection
Ctrl + V
Paste
Ctrl + G
Find and replace options
Ctrl + H
Page 1 of 21
Find and replace options
Ctrl + J
Justify paragraph alignment
Ctrl + L
Align selected text or line to the left
Ctrl + Q
Align the selected paragraph to the left
Ctrl + E
Align selected text or line to the centre
Ctrl + R
Align selected text or line to the right
Ctrl + M
Indent the paragraph
Ctrl + T
Hanging indent
Ctrl + D
Font options
Ctrl + Shift + F
Change the font
Ctrl + Shift + >
Increase selected font +1
Ctrl + ]
Increase selected font +1
Ctrl + [
Decrease selected font -1
Ctrl + Shift + *
View or hide non-printing characters
Page 2 of 21
Ctrl + (Left arrow)
Move one word to the left
Ctrl + (Right arrow)
Move one word to the right
Ctrl + (Up arrow)
Move to the beginning of the line or paragraph
Ctrl + (Down arrow)
Move to the end of the paragraph
Ctrl + Del
Delete the word to the right of the cursor
Ctrl + Backspace
Delete the word to the left of the cursor
Ctrl + End
Move the cursor to the end of the document
Ctrl + Home
Move the cursor to the beginning of the document
Ctrl + Space
Reset highlighted text to the default font
Ctrl + 1
Single-space lines
Ctrl + 2
Double-space lines
Ctrl + 5
1.5-line spacing
Ctrl + Alt + 1
Change text to heading 1
Ctrl + Alt + 2
Page 3 of 21
Change text to heading 2
Ctrl + Alt + 3
Change text to heading 3
Shift + Insert
Paste
Ctrl + S
Save
Alt + Shift + D
Insert the current date
Alt + Shift + T
Insert the current time
Ctrl + W
Close document
Ctrl+=
Set chosen text as a subscript.
Ctrl+Shift+=
Set chosen text as superscript.

Press this To do this

key

Ctrl + X Cut the selected item.

Ctrl + C Copy the selected item.

(or Ctrl +
Insert)

Page 4 of 21
Press this To do this
key

Ctrl + V Paste the selected item.

(or Shift +
Insert)

Ctrl + Z Undo an action.

Alt + Tab Switch between open apps.

Alt + F4 Close the active item, or exit the active app.

Windows Lock your PC.

logo
key + L

Windows Display and hide the desktop.

logo
key + D

F2 Rename the selected item.

F3 Search for a file or folder in File Explorer.

F4 Display the address bar list in File Explorer.

F5 Refresh the active window.

F6 Cycle through screen elements in a window or on

the desktop.

F10 Activate the Menu bar in the active app.

Page 5 of 21
Press this To do this
key

Alt + A Set focus to the first icon in the Suggested actions

menu.

Alt + F8 Show your password on the sign-in screen.

Alt + Esc Cycle through items in the order in which they were
opened.

Alt + Perform the command for that letter.

underlined
letter

Alt + Enter Display properties for the selected item.

Alt + Open the shortcut menu for the active window.

Spacebar

Alt + Left Go back.

arrow

Alt + Right Go forward.

arrow

Alt + Page Move up one screen.

Up

Alt + Page Move down one screen.

Down

Page 6 of 21
Press this To do this
key

Ctrl + F4 Close the active document (in apps that are full-
screen and let you have multiple documents open at
the same time).

Ctrl + A Select all items in a document or window.

Ctrl + D Delete the selected item and move it to the Recycle

(or Delete) Bin.

Ctrl + E Open Search (in most apps).

Ctrl + R Refresh the active window.

(or F5)

Ctrl + Y Redo an action.

Ctrl + Move the cursor to the beginning of the next word.

Right
arrow

Ctrl + Left Move the cursor to the beginning of the previous

arrow word.

Ctrl + Move the cursor to the beginning of the next

Down paragraph.
arrow

Ctrl + Up Move the cursor to the beginning of the previous

arrow paragraph.

Page 7 of 21
Press this To do this
key

Ctrl + Alt Use the arrow keys to switch between all open
+ Tab apps.

Alt + Shift When a group or tile is in focus on the Start menu,

+ arrow move it in the direction specified.
keys

Ctrl + When a tile is in focus on the Start menu, move it

Shift + into another tile to create a folder.
arrow
keys

Ctrl + Resize the Start menu when it's open.

arrow
keys

Ctrl + Select multiple individual items in a window or on

arrow key the desktop.
(to move
to an
item) +
Spacebar

Ctrl + Select a block of text.

Shift with
an arrow
key

Ctrl + Esc Open Start.

Ctrl + Open Task Manager.

Shift + Esc

Page 8 of 21
Press this To do this
key

Ctrl + Switch the keyboard layout when multiple

Shift keyboard layouts are available.

Ctrl + Turn the Chinese input method editor (IME) on or

Spacebar off.

Shift + F10 Display the shortcut menu for the selected item.

Shift with Select more than one item in a window or on the

any arrow desktop, or select text in a document.
key

Shift + Delete the selected item without moving it to the

Delete Recycle Bin first.

Right Open the next menu to the right, or open a

arrow submenu.

Left arrow Open the next menu to the left, or close a submenu.

Esc Stop or leave the current task.

PrtScn Take a screenshot of your whole screen and copy it

to the clipboard.
Note: You can change this shortcut so it also
opens screen snipping, which lets you edit your
screenshot.
Select Start > Settings > Accessibility > Keyboard ,
and set Use the Print Screen button to open screen
snipping to On.

Page 9 of 21
MS ACCESS
Open the Help window. F1
Go back to Access Help Home. Alt+Home
Select the next item in the Help window. Tab key
Select the previous item in the Help window. Shift+Tab
Perform the action for the selected item. Enter
In the Access Help topics list, expand or collapse the selected item. Enter
Select the next hidden text or hyperlink, including Show All or Hide All at
the top of a topic. Tab key
Select the previous hidden text or hyperlink. Shift+Tab
Perform the action for the selected Show All, Hide All, hidden text, or
hyperlink. Enter
Move back to the previous Help topic (Back button). Alt+Left arrow key or
Backspace
Move forward to the next Help topic (Forward button). Alt+Right arrow key
Scroll small amounts up or down within the currently displayed Help topic.
Up or Down arrow key
Scroll larger amounts up or down, respectively, within the currently
displayed Help topic. Page up or Page down
Stop the last action (Stop button). Esc
Refresh the window (Refresh button). F5
Print the current Help topic. Ctrl+P
(If the cursor is not in the current Help topic, press F6, and then press
Ctrl+P)
Change the connection state. F6, and then Enter to open the list of choices
Switch among areas in the Help window, such as the toolbar and the Search
list. F6

Page 10 of 21
In a Table of Contents in tree view, select the next or previous item,
respectively. Up or Down arrow key
In a Table of Contents in tree view, expand or collapse the selected item.
Enter

MS EXCEL
Arrow keys
Move one cell up, down, left, or right in a worksheet.
Ctrl+Arrow key moves to the edge of the current data region in a
worksheet.
Shift+Arrow key extends the selection of cells by one cell.
Ctrl+Shift+Arrow key extends the selection of cells to the last nonblank cell
in the same column or row as the active cell, or if the next cell is blank,
extends the selection to the next nonblank cell.
Left or Right arrow key selects the tab to the left or right when the ribbon is
selected. When a submenu is open or selected, these arrow keys switch
between the main menu and the submenu. When a ribbon tab is selected,
these keys navigate the tab buttons.
Down or Up arrow key selects the next or previous command when a menu
or submenu is open. When a ribbon tab is selected, these keys navigate up
or down the tab group.
In a dialog box, arrow keys move between options in an open drop-down
list, or between options in a group of options.
Down or Alt+Down arrow key opens a selected drop-down list.
Backspace
Deletes one character to the left in the formula bar.
Clears the content of the active cell.
In cell editing mode, it deletes the character to the left of the insertion
point.
Delete

Page 11 of 21
Removes the cell contents (data and formulas) from selected cells without
affecting cell formats, threaded comments, or notes.
In cell editing mode, it deletes the character to the right of the insertion
point.
End
End turns End mode on or off. In End mode, you can press an arrow key to
move to the next nonblank cell in the same column or row as the active
cell. End mode turns off automatically after pressing the arrow key. Make
sure to press End again before pressing the next arrow key. End mode is
shown in the status bar when it is on.
If the cells are blank, pressing End followed by an arrow key moves to the
last cell in the row or column.
End also selects the last command on the menu when a menu or submenu is
visible.
Ctrl+End moves to the last cell on a worksheet, to the lowest used row of
the rightmost used column. If the cursor is in the formula bar, Ctrl+End
moves the cursor to the end of the text.
Ctrl+Shift+End extends the selection of cells to the last used cell on the
worksheet (lower-right corner). If the cursor is in the formula bar,
Ctrl+Shift+End selects all text in the formula bar from the cursor position
to the end—this does not affect the height of the formula bar.
Enter
Completes a cell entry from the cell or the formula bar and selects the cell
below (by default).
In a data form, it moves to the first field in the next record.
Opens a selected menu (press F10 to activate the menu bar) or performs the
action for a selected command.
In a dialog box, it performs the action for the default command button in
the dialog box (the button with the bold outline, often the OK button).
Alt+Enter starts a new line in the same cell.
Ctrl+Enter fills the selected cell range with the current entry.
Shift+Enter completes a cell entry and selects the cell above.
Page 12 of 21
Esc
Cancels an entry in the cell or formula bar.
Closes an open menu or submenu, dialog box, or message window.
Home
Moves to the beginning of a row in a worksheet.
Moves to the cell in the upper-left corner of the window when Scroll lock is
turned on.
Selects the first command on the menu when a menu or submenu is visible.
Ctrl+Home moves to the beginning of a worksheet.
Ctrl+Shift+Home extends the selection of cells to the beginning of the
worksheet.
Page down
Moves one screen down in a worksheet.
Alt+Page down moves one screen to the right in a worksheet.
Ctrl+Page down moves to the next sheet in a workbook.
Ctrl+Shift+Page down selects the current and next sheet in a workbook.
Page up
Moves one screen up in a worksheet.
Alt+Page up moves one screen to the left in a worksheet.
Ctrl+Page up moves to the previous sheet in a workbook.
Ctrl+Shift+Page up selects the current and previous sheet in a workbook.
Shift
Hold the Shift key while you drag a selected row, column, or selected cells
to move the selected cells and drop to insert them in a new location.
Spacebar
In a dialog box, performs the action for the selected button, or selects or
clears a checkbox.
Ctrl+Spacebar selects an entire column in a worksheet.

Page 13 of 21
Shift+Spacebar selects an entire row in a worksheet.
Ctrl+Shift+Spacebar selects the entire worksheet.
If the worksheet contains data, Ctrl+Shift+Spacebar selects the current
region. Pressing Ctrl+Shift+Spacebar a second time selects the current
region and its summary rows. Pressing Ctrl+Shift+Spacebar a third time
selects the entire worksheet.
When an object is selected, Ctrl+Shift+Spacebar selects all objects on a
worksheet.
Alt+Spacebar displays the Control menu for the Excel window.
Tab key
Moves one cell to the right in a worksheet.
Moves between unlocked cells in a protected worksheet
Moves to the next option or option group
Shift+Tab moves to the previous cell in a worksheet or the previous option
in a dialog box.
Ctrl+Tab switches to the next tab in a dialog box, or (if no dialog box is
open) switches between two Excel windows.
Ctrl+Shift+Tab switches to the previous tab in a dialog box, or (if no dialog
box is open) switches between all Excel windows.

EDUCBAEDUCBA
Excell Shortcuts.
The ALT key on the keyboard is the master key, which is present on both
sides of the Spacebar key.
Keyboard shortcuts are essential alternatives to the mouse.
We can use the keyboard shortcuts in Excel using ALT, CTRL, SHIFT,
Function key, and Windows key.
The shortcut keys for the Windows keyboard and Mac keyboard are
different.
How to Find Excel Keyboard Shortcuts?
Page 14 of 21
To find the keyboard shortcuts press the ALT key on the keyboard. The
Excel ribbon displays the below shortcuts for the menus in the toolbar.
Excel keyboard shortcuts-ALT
When we press ALT + H, Microsoft Excel displays the keyboard shortcuts
for every function in the toolbar except the menus, as shown below.

Excel Keyboard Shortcuts – CTRL + A Select All

Excel Keyboard Shortcuts – CTRL+B Bold
Excel Keyboard Shortcuts – CTRL+C Copy
Excel Keyboard Shortcuts – CTRL+D Fill Down
Excel Keyboard Shortcuts – CTRL+F Find
Excel Keyboard Shortcuts – Ctrl+G Go to
Excel Keyboard Shortcuts – Ctrl+H Replace
Excel Keyboard Shortcuts – Ctrl+I Italic
Excel Keyboard Shortcuts – Ctrl+K Insert Hyperlink
Excel Keyboard Shortcuts – Ctrl + LDisplays the Create Table dialog box
Excel Keyboard Shortcuts – Ctrl+N New Workbook
Excel Keyboard Shortcuts – Ctrl+O Open
Excel Keyboard Shortcuts – Ctrl+P Print
Excel Keyboard Shortcuts – Ctrl+R Fill Right
Excel Keyboard Shortcuts – Ctrl+S Save
Excel Keyboard Shortcuts – Ctrl+U Underline
Excel Keyboard Shortcuts – Ctrl+V Paste
Excel Keyboard Shortcuts – Ctrl+W Close
Excel Keyboard Shortcuts – Ctrl+X Cut
Excel Keyboard Shortcuts – Ctrl+Y Repeat the last worksheet action
Excel Keyboard Shortcuts – Ctrl+Z Undo

Page 15 of 21
 1. CTRL + Numbers Shortcuts
Excel Keyboard Shortcuts – Ctrl+0 Hide columns
Excel Keyboard Shortcuts – Ctrl+1 Format Cells dialog box
Excel Keyboard Shortcuts – Ctrl+2 Bold
Excel Keyboard Shortcuts – Ctrl+3 Italic
Excel Keyboard Shortcuts – Ctrl+4 Underline
Excel Keyboard Shortcuts – Ctrl+5 Strikethrough
Excel Keyboard Shortcuts – Ctrl+6 Show or Hide objects
Excel Keyboard Shortcuts – Ctrl+7 Show or Hide Standard toolbar
Excel Keyboard Shortcuts – Ctrl+8 Toggle Outline symbols
Excel Keyboard Shortcuts – Ctrl+9 Hide rows
Excel Keyboard Shortcuts – Ctrl + Shift + 0 It Unhides the columns in the
current selection
Excel Keyboard Shortcuts – Ctrl + Shift + 2 It Enters the value from the
cell directly above into the active cell
Excel Keyboard Shortcuts – Ctrl + Shift + 8 It Selects the current region
(associated with blank rows and columns)
Excel Keyboard Shortcuts – Ctrl + Shift + 9 It will Unhide the rows in the
current selection
2. Function Keys Shortcut
Excel keyboard shortcuts-F1 Shortcut Microsoft Excel Help
Excel keyboard shortcuts-F2 Shortcut Edit
Excel keyboard shortcuts-F3 shortcut Paste Name
Excel keyboard shortcuts-F4 SHORTCUT
Repeat the last worksheet action
Switch between relative and absolute refs
Excel keyboard shortcuts-F5 SHORTCUT Go To
Excel keyboard shortcuts-F6 SHORTCUT Next Pane

Page 16 of 21
Excel keyboard shortcuts-F7 SHORTCUT Spell check
Excel keyboard shortcuts-F8 SHORTCUT Extend mode
Excel keyboard shortcuts-F9 SHORTCUT To recalculate all workbooks
Excel keyboard shortcuts-F10 SHORTCUT Activate Menu Bar
Excel keyboard shortcuts-F11 New Chart
Excel keyboard shortcuts-F12 SHORTCUT Save As
3. CTRL + Function Keys Shortcut
Ctrl+f1 Expand or collapse the Ribbon
Ctrl + F2 Display the Print Preview area on the Print tab of Backstage View
Ctrl + F3 Display the Name Manager dialog box
Ctrl + F4 Close the currently selected workbook window
Ctrl + F6 Alternate between the currently active workbook window and
the next workbook window
Ctrl + F7 Apply the Move command on the active workbook window
Ctrl + F8 Apply Resize command on the active workbook window
Ctrl + F9 Minimize the currently selected workbook window
Ctrl + F10 Maximize or restore the currently selected workbook window
Ctrl + F11 New Macro sheet
Ctrl + F12 Display the Open dialog box
4. SHIFT + Function Keys Shortcut
ShiFt+F2 Edit cell comment
ShiFt+F3 Displays formula box to Paste function into the formula
ShiFt+F4 Find Next
ShiFt+F5 Find
ShiFt+F6 Moves to the Previous Pane in a workbook
ShiFt+F8 Add to selection
ShiFt+F9 Calculate active worksheet

Page 17 of 21
ShiFt+F10 Display shortcut menu
ShiFt+F11 Insert New worksheet
ShiFt+F12 Save
5. ALT + Function Keys Shortcut
Alt+F1 Insert Chart (Creates a chart of the data in the current range)
Alt+F2 Save As
Alt+F4 Closes all workbooks & Exits Excel
Alt+F8 Macro dialog box
Alt+F11 Displays Visual Basic Editor
6. ALT + SHIFT + Function Keys Shortcut
Alt+shft+1 Inserts a new worksheet into the active workbook
Alt+Shft+F2 Displays the Save As dialog box
Alt+Shft+F4 Closes all the workbooks and exits Excel
Alt+Shft+F10 Displays the drop-down menu for the corresponding smart
tag
Alt+Shft+F11 Displays the drop-down menu for the corresponding smart
tag
7. ALT + Letter Keys Shortcut
Alt + A + E Convert Text to Columns Wizard
Alt + A + H Hide grouped columns or rows
Alt + A + J Show grouped columns or rows
Alt + A + M Displays the Remove Duplicates dialog box
Alt + A + Q Advanced Filter
Alt + A + SA Sort smallest to largest
Alt + A + SD Sort largest to smallest
Alt + A + SS Displays the Sort dialog box
Alt + B Add or Remove the bottom border
Alt + D Add or Remove the downward diagonal border
Page 18 of 21
Alt + F Go to Backstage View
Alt + H Add or Remove the horizontal interior border
Alt + H + AB Align text to the bottom of the cell
Alt + H + AC Align text to the center of the cell
Alt + H + AL Align text to the left of the cell
Alt + H + AM Align text to the middle of the cell
Alt + H + AN Choose accounting format
Alt + H + AR Align text to the right of the cell
Alt + H + AT Align text to the top of the cell
Alt + H + B Expand Borders drop-down menu
Alt + H + FC Choose font color
Alt + H + FC Expand Font Color drop-down menu
Alt + H + FF Change the font face
Alt + H + FG Increase the font size by 1 point
Alt + H + FK Decrease the font size by 1 point
Alt + H + FM Format Cells dialog box with the Number tab selected
Alt + H + FN Format Cells dialog box with the Font tab selected
Alt + H + FO Clipboard task pane
Alt + H + FP Activates Format Painter
Alt + H + FS Change the font size
Alt + H + H Expand the Fill Color drop-down menu
Alt + H + J Expand the Cell Styles menu
Alt + H + K Format number with a thousand’s comma (,) separator
Alt + H + N Choose number format
Alt + H + T Expand Format as Table drop-down menu
Alt + H + T Expand the Format as Table menu
Alt + H + W Wrap text
Page 19 of 21
Alt + JA Go to the Layout tab of the Ribbon
Alt + JC Go to the Design tab of the Ribbon
Alt + JC + A Expand Add Chart Element drop-down menu
Alt + L Add/ Remove the left border
Alt + L + I Expand the Insert Form Controls and ActiveX Controls drop-
down menu
Alt + M + D Trace Dependents
Alt + M + P Trace Precedents
Alt + N + B Insert Bar Chart
Alt + N + C Insert Column Chart
Alt + N + N Insert Line Chart
Alt + N + Q Insert Pie or Doughnut Chart
Alt + N + R Recommended Charts
Alt + N + SD Insert Combo Chart
Alt + N + V Pivot Table
Alt + N + X Insert Text Box
Alt + R Add or Remove the right border
Alt + R + A Show all comments
Alt + R + D Delete comment
Alt + T Add or Remove the top border
Alt + T + O Display Excel Options dialog box
Alt + V Add or Remove the vertical interior border
Alt + W + I Page Break Preview
Alt + W + L Normal View
Alt + W + Q Zoom dialog box
Alt + W + VG View or hide gridlines
What are the most Common Excel Keyboard Shortcuts?

Page 20 of 21
CTRL+ Home Move to the beginning of a worksheet
CTRL+ Pgdn Move to the next sheet in a workbook
CTRL+ Pgup Move to the previous sheet in a workbook
ALT + Pgdn Move one screen to the right in a worksheet
ALT + Pgup Move one screen to the left in a worksheet
CTRL + Arrow Move to the edge of the current data region in a worksheet.
Frequently Asked Questions (FAQs)
Q1. What is the F1 shortcut key in Excel?
Answer: The F1 key is a function key in Excel that displays the Help task
pane. If we press CTRL + F1, it displays/ hides the Excel ribbon. Excel
creates an embedded chart if we press ALT + F1 for a selected data/ range.
Q2. How do I get a list of shortcuts in Excel?
Answer: To get a list of shortcuts in Excel, press the ALT key. The ALT key
will display all the ribbon shortcuts, which are also called Key Tips. These
tips appear as small letters next to the function they represent.
Q3. What is F7 used for in Excel?
Answer: The function key F7 displays the Spelling dialog box, which checks
the spelling of the active Excel worksheet or a selected cell range. If we
press CTRL + F7, it performs the Move command on the Excel workbook
window.
Q4. What is F4 in Excel?
Answer: The function key F4 repeats the last action or command. It is
helpful when performing multiple tasks and not remembering the last
action. It helps save time too.

Page 21 of 21