myshortcutkeys.com

Function Shortcut Keys

Key

Description

F1

Displays the Help task pane.

CTRL+F1

Closes and reopens the current task pane.

ALT+F1

Creates a chart of the data in the current range.

ALT+SHIFT+F1

Inserts a new worksheet.

F2

Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.

SHIFT+F2

Edits a cell comment.

F3

Pastes a defined name into a formula.

SHIFT+F3

Displays the Insert Function dialog box.

F4

Repeats the last command or action, if possible.

CTRL+F4

Closes the selected workbook window.

CTRL+F5

Restores the window size of the selected workbook window.

F6

Switches to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6

Switches to the previous pane in a worksheet that has been split.

CTRL+F6

Switches to the next workbook window when more than one workbook window is open.

SHIFT+F6

Note When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.

F7

Displays the Spelling dialog box to check spelling in the active worksheet or selected range.

CTRL+F7

Performs the Move command on the workbook window when it is not maximized. Use the arrow Keys to move the window, and when finished press ESC.

F8

Turns extend mode on or off. In extend mode; EXT appears in the status line, and the arrow Keys extend the selection.

SHIFT+F8

Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow Keys.

CTRL+F8

Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.

ALT+F8

Displays the Macro dialog box to run, edit, or delete a macro.

F9

Calculates all worksheets in all open workbooks.

F9

F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.

SHIFT+F9

Calculates the active worksheet.

CTRL+ALT+F9

Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9

Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

CTRL+F9

Minimizes a workbook window to an icon.

F10

Selects the menu bar or closes an open menu and submenu at the same time.

SHIFT+F10

Displays the shortcut menu for a selected item.

ALT+SHIFT+F10

Displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.

CTRL+F10

Maximizes or restores the selected workbook window.

F11

Creates a chart of the data in the current range.

SHIFT+F11

Inserts a new worksheet.

ALT+F11

Opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).

ALT+SHIFT+F11

Opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.

F12

Displays the Save As dialog box.

CTRL + Key Shortcut Description

Key

Description

CTRL+(

Unhide any hidden rows within the selection.

CTRL+)

Unhide any hidden columns within the selection.

CTRL+&

Applies the outline border to the selected cells.

CTRL+_

Removes the outline border from the selected cells.

CTRL+~

Applies the General number format.

CTRL+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+%

Applies the Percentage format with no decimal places.

CTRL+^

Applies the Exponential number format with two decimal places.

CTRL+#

Applies the Date format with the day, month, and year.

CTRL+@

Applies the Time format with the hour and minute, and AM or PM.

CTRL+!

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+-

Displays the Delete dialog box to delete the selected cells.

CTRL+*

Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

CTRL+:

Enters the current time.

CTRL+;

Enters the current date.

CTRL+`

Alternates between displaying cell values and displaying formulas in the worksheet.

CTRL+’

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

CTRL+”

Copies the value from the cell above the active cell into the cell or the Formula Bar.

CTRL++

Displays the Insert dialog box to insert blank cells.

CTRL+1

Displays the Format Cells dialog box.

CTRL+2

Applies or removes bold formatting.

CTRL+3

Applies or removes italic formatting.

CTRL+4

Applies or removes underlining.

CTRL+5

Applies or removes strikethrough.

CTRL+6

Alternates between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+7

Displays or hides the Standard toolbar.

CTRL+8

Displays or hides the outline symbols.

CTRL+9

Hides the selected rows.

CTRL+0

Hides the selected columns.

CTRL+A

Selects the entire worksheet.

CTRL+A

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

CTRL+B

Applies or removes bold formatting.

CTRL+C

Copies the selected cells.

CTRL+C

CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.

CTRL+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F

Displays the Find dialog box.

CTRL+G

Displays the Go To dialog box.

F5

F5 also displays this dialog box.

CTRL+H

Displays the Find and Replace dialog box.

CTRL+I

Applies or removes italic formatting.

CTRL+K

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+L

Displays the Create List dialog box.

CTRL+N

Creates a new, blank file.

CTRL+O

Displays the Open dialog box to open or find a file.

CTRL+SHIFT+O

Selects all cells that contain comments.

CTRL+P

Displays the Print dialog box.

CTRL+R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+S

Saves the active file with its current file name, location, and file format.

CTRL+U

Applies or removes underlining.

CTRL+V

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

CTRL+W

Closes the selected workbook window.

CTRL+X

Cuts the selected cells.

CTRL+Y

Repeats the last command or action, if possible.

CTRL+Z

Uses the Undo command to reverse the last command or to delete the last entry you typed.

CTRL+SHIFT+Z

Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Other useful shortcut Keys

Key

Description

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 (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) 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.

CTRL+SHIFT+ARROW KEY

LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow Keys switch between the main menu and the submenu.

CTRL+SHIFT+ARROW KEY

DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.

CTRL+SHIFT+ARROW KEY

In a dialog box, arrow Keys move between options in an open drop-down list, or between options in a group of options.

ALT+DOWN ARROW

Opens a selected drop-down list.

BACKSPACE

Deletes one character to the left in the Formula Bar.

BACKSPACE

Also clears the content of the active cell.

DELETE

Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

DELETE

In cell editing mode, it deletes the character to the right of the insertion point.

END

Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.

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, in the lowest used row of the rightmost used column.

CTRL+SHIFT+END

Extends the selection of cells to the last used cell on the worksheet (lower-right corner).

ENTER

Completes a cell entry from the cell or the Formula Bar,

and selects the cell below (by default).

ENTER

In a data form, it moves to the first field in the next

record.

ENTER

Opens a selected menu (press F10 to activate the menu

bar) or performs the action for a selected command.

ENTER

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.

ESC

Cancels an entry in the cell or Formula Bar.

ESC

It also closes an open menu or submenu, dialog box, or message window.

HOME

Moves to the beginning of a row in a worksheet.

HOME

Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.

HOME

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.

SPACEBAR

In a dialog box, performs the action for the selected button, or selects or clears a check box.

CTRL+SPACEBAR

Selects an entire column in a worksheet.

SHIFT+SPACEBAR

Selects an entire row in a worksheet.

CTRL+SHIFT+SPACEBAR

Selects the entire worksheet.

ALT+SPACEBAR

Displays the Control menu for the Excel window.

TAB

Moves one cell to the right in a worksheet.

TAB

Moves between unlocked cells in a protected worksheet.

TAB

Moves to the next option or option group in a dialog box.

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 dialog box.

CTRL+SHIFT+TAB

Switches to the previous tab in a dialog box.

Commands

Details

ADDUSERS

Add or list users to/from a CSV file

ARP

Address Resolution Protocol

ASSOC

Change file extension associations

ASSOCIAT

One step file association

AT

Schedule a command to run at a later time

ATTRIB

Change file attributes

BOOTCFG

Edit Windows boot settings

BROWSTAT

Get domain, browser and PDC info

CACLS

Change file permissions

CALL

Call one batch program from another

CD

Change Directory move to a specific Folder

CHANGE

Change Terminal Server Session properties

CHKDSK

Check Disk check and repair disk problems

CHKNTFS

Check the NTFS file system

CHOICE

Accept keyboard input to a batch file

CIPHER

Encrypt or Decrypt files/folders

CleanMgr

Automated cleanup of Temp files, recycle bin

CLEARMEM

Clear memory leaks

CLIP

Copy STDIN to the Windows clipboard.

CLS

Clear the screen

CLUSTER

Windows Clustering

CMD

Start a new CMD shell

COLOR

Change colors of the CMD window

COMP

Compare the contents of two files or sets of files

COMPACT

Compress files or folders on an NTFS partition

COMPRESS

Compress individual files on an NTFS partition

CON2PRT

Connect or disconnect a Printer

CONVERT

Convert a FAT drive to NTFS.

COPY

Copy one or more files to another location

CSCcmd

Client side caching (Offline Files)

CSVDE

Import or Export Active Directory data

DATE

Display or set the date

Dcomcnfg

DCOM Configuration Utility

DEFRAG

Defragment hard drive

DEL

Delete one or more files

DELPROF

Delete NT user profiles

DELTREE

Delete a folder and all subfolders

DevCon

Device Manager Command Line Utility

DIR

Display a list of files and folders

DIRUSE

Display disk usage

DISKCOMP

Compare the contents of two floppy disks

DISKCOPY

Copy the contents of one floppy disk to another

DNSSTAT

DNS Statistics

DOSKEY

Edit command line, recall commands, and create macros

DSADD

Add user (computer, group..) to active directory

DSQUERY

List items in active directory

DSMOD

Modify user (computer, group..) in active directory

ECHO

Display message on screen

ENDLOCAL

End localisation of environment changes in a batch file

ERASE

Delete one or more files

EXIT

Quit the current script/routine and set an errorlevel.

EXPAND

Uncompress files

EXTRACT

Uncompress CAB files

FC

Compare two files

FDISK

Disk Format and partition

FIND

Search for a text string in a file

FINDSTR

Search for strings in files

FOR /F

Loop command: against a set of files

FOR /F

Loop command: against the results of another command

FOR

Loop command: all options Files, Directory, List

FORFILES

Batch process multiple files

FORMAT

Format a disk

FREEDISK

Check free disk space (in bytes)

FSUTIL

File and Volume utilities

FTP

File Transfer Protocol

FTYPE

Display or modify file types used in file extension associations

GLOBAL

Display membership of global groups

GOTO

Direct a batch program to jump to a labelled line

HELP

Online Help

HFNETCHK

Network Security Hotfix Checker

IF

Conditionally perform a command

IFMEMBER

Is the current user in an NT Workgroup

IPCONFIG

Configure IP

KILL

Remove a program from memory

LABEL

Edit a disk label

LOCAL

Display membership of local groups

LOGEVENT

Write text to the NT event viewer.

LOGOFF

Log a user off

LOGTIME

Log the date and time in a file

MAPISEND

Send email from the command line

MEM

Display memory usage

MD

Create new folders

MKLINK

Create a symbolic link (linkd)

MODE

Configure a system device

MORE

Display output, one screen at a time

MOUNTVOL

Manage a volume mount point

MOVE

Move files from one folder to another

MOVEUSER

Move a user from one domain to another

MSG

Send a message

MSIEXEC

Microsoft Windows Installer

MSINFO

Windows NT diagnostics

MSTSC

Terminal Server Connection (Remote Desktop Protocol)

MUNGE

Find and Replace text within file(s)

MV

Copy in use files

NET

Manage network resources

NETDOM

Domain Manager

NETSH

Configure network protocols

NETSVC

Command line Service Controller

NBTSTAT

Display networking statistics (NetBIOS over TCP/IP)

NETSTAT

Display networking statistics (TCP/IP)

NOW

Display the current Date and Time

NSLOOKUP

Name server lookup

NTBACKUP

Backup folders to tape

NTRIGHTS

Edit user account rights

PATH

Display or set a search path for executable files

PATHPING

Trace route plus network latency and packet loss

PAUSE

Suspend processing of a batch file and display a message

PERMS

Show permissions for a user

PERFMON

Performance Monitor

PING

Test a network connection

POPD

Restore the previous value of the current directory saved by PUSHD

PORTQRY

Display the status of ports and services

PRINT

Print a text file

PRNCNFG

Display, configure or rename a printer

PRNMNGR

Add, delete, list printers set the default printer

PROMPT

Change the command prompt

PsExec

Execute process remotely

PsFile

Show files opened remotely

PsGetSid

Display the SID of a computer or a user

PsInfo

List information about a system

PsKill

Kill processes by name or process ID

PsList

List detailed information about processes

PsLoggedO

n Who’s logged on (locally or via resource sharing)

PsLogList

Event log records

PsPasswd

Change account password

PsService

View and control services

PsShutdow

n Shutdown or reboot a computer

PsSuspend

Suspend processes

PUSHD

Save and then change the current directory

QGREP

Search file(s) for lines that match a given pattern.

RASDIAL

Manage RAS connections

RASPHONE

Manage RAS connections

RECOVER

Recover a damaged file from a defective disk.

REG

Registry: Read, Set, Export, Delete keys and values

REGEDIT

Import or export registry settings

REGSVR32

Register or unregister a DLL

REGINI

Change Registry Permissions

REM

Record comments (remarks) in a batch file

REN

Rename a file or files.

REPLACE

Replace or update one file with another

RD

Delete folder(s)

RDISK

Create a Recovery Disk

RMTSHARE

Share a folder or a printer

ROBOCOPY

Robust File and Folder Copy

ROUTE

Manipulate network routing tables

RUNAS

Execute a program under a different user account

RUNDLL32

Run a DLL command (add/remove print connections)

SC

Service Control

SCHTASKS

Create or Edit Scheduled Tasks

SCLIST

Display NT Services

ScriptIt

Control GUI applications

SET

Display, set, or remove environment variables

SETLOCAL

Control the visibility of environment variables

SETX

Set environment variables permanently

SHARE

List or edit a file share or print share

SHIFT

Shift the position of replaceable parameters in a batch file

SHORTCUT

Create a windows shortcut (.LNK file)

SHOWGRPS

List the NT Workgroups a user has joined

SHOWMBRS

List the Users who are members of a Workgroup

SHUTDOWN

Shutdown the computer

SLEEP

Wait for x seconds

SOON

Schedule a command to run in the near future

SORT

Sort input

START

Start a separate window to run a specified program or command

SU

Switch User

SUBINACL

Edit file and folder Permissions, Ownership and Domain

SUBST

Associate a path with a drive letter

SYSTEMINF

List system configuration

TASKLIST

List running applications and services

TIME

Display or set the system time

TIMEOUT

Delay processing of a batch file

TITLE

Set the window title for a CMD.EXE session

TOUCH

Change file timestamps

TRACERT

Trace route to a remote host

TREE

Graphical display of folder structure

TYPE

Display the contents of a text file

USRSTAT

List domain usernames and last login

VER

Display version information

VERIFY

Verify that files have been saved

VOL

Display a disk label

WHERE

Locate and display files in a directory tree

WHOAMI

Output the current UserName and domain

WINDIFF

Compare the contents of two files or sets of files

WINMSD

Windows system diagnostics

WINMSDP

Windows system diagnostics II

WMIC

WMI Commands

XCACLS

Change file permissions

XCOPY

Copy files and folders