Comments Off on Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

Here is a list of most useful and common shortcuts used in microsoft excel.These shortcut or hotkeys will help you to work in excel at lightning speed .

image

Shortcut Key

Functions

F2

Edit the selected cell

F5

Goto a specific cell. For example, C6.

F7

Spell check selected text and/or document

F11

Create chart

Ctrl + Shift + ;

Enter the current time

Ctrl + ;

Enter the current date

Alt + Shift + F1

Insert New Worksheet

Shift + F3

Open the Excel formula window

Shift + F5

Bring up search box

Ctrl + A

Select all contents of the worksheet

Ctrl + B

Bold highlighted selection

Ctrl + I

Italic highlighted selection

Ctrl + K

Insert link

Ctrl + U

Underline highlighted selection

Ctrl + 5

Strikethrough highlighted selection

Ctrl + P

Bring up the print dialog box to begin printing

Ctrl + Z

Undo last action

Ctrl + F9

Minimize current window

Ctrl + F10

Maximize currently selected window

Ctrl + F6

Switch between open workbooks / windows

Ctrl + Page up

Move between Excel work sheets in the same Excel document

Ctrl + Page down

Move between Excel work sheets in the same Excel document

Ctrl + Tab

Move between Two or more open Excel files

Alt + =

Create a formula to sum all of the above cells

Ctrl + ‘

Insert the value of the above cell into cell currently selected

Ctrl + Shift + !

Format number in comma format

Ctrl + Shift + $

Format number in currency format

Ctrl + Shift + #

Format number in date format

Ctrl + Shift + %

Format number in percentage format

Ctrl + Shift + ^

Format number in scientific format

Ctrl + Shift + @

Format number in time format

Ctrl + Arrow key

Move to next section of text

Ctrl + Space

Select entire column

Shift + Space

Select entire row

Make some difference learn all the hotkeys of other Softwares also…

Popularity: unranked [?]

Filed in: Computer Tips

Share This Post

Recent Posts

© 2019 Daily-Tips.Net. All rights reserved.