All Excel shortcuts

  


MS Excel  



Ms excel is the part of Microsoft Office,Ms Excel is used

to make or create a spreadsheet  Document  they are commonly used in Offices

, Schools, University’s and there like Business  work,

 If you want to use Ms. Excel then you should follow these Shortcuts After that, you will be able to edit or make a new Excel sheet

 

Shortcuts

All shortcuts that are commonly used in MS Excel You Read them and Grow your skill

Shortcuts

Description

Tab

Move to next cell, to the right of the currently selected cell

Ctrl+A

To select all.

Ctrl+B

Bold.

Ctrl+C

To Copy.

Ctr+F

Search/Find (if you need to find  any word/words in the file)

Ctrl+G

Go to a certain area(certain area)

Ctrl+H

Find and replace (find  any word/words in a file and replace it)

Ctrl+I

Puts ‘italics’ style on the highlighted section. (like as italics )

Ctrl+K

Hyperlink(add a link in a word such as Click here. )

Ctrl+L

Create a new Table dialog box cells

Ctrl+N

Create a new sheet.

Ctrl+O

Open a sheet.

Ctrl+P

To Print the sheet.

Ctrl+R

Fill multiple cells. (first, fill one cell and hold the right courser at end of cell and moves to any other the cell in the only Row)

Ctrl+S

Save. (save the sheet in given location)

Ctrl+U

Underlines all cells in the selected section(like as Welcome)

Ctrl+V

Paste here.

Ctrl+W

Close.

Ctrl+X

Cut the mentioned part.

Ctrl+Y

Redo repeat the previous work.

Ctrl+Z

 ‘Undo’ remove the mention work.

Ctrl+1

Correction of the mention cells

Ctrl+2

The selected section will Bold.

Ctrl+3

show italics style

Ctrl+4

Shows Underlined style.

Ctrl+5

shows strikethrough style like as; strikethrough 

Ctrl+6

shows objects. (Hides or unhide)

Ctrl+7

shows toolbar(hide or show)

Ctrl+8

the outline symbols “Toggles”

Ctrl+9

Show the hides rows.

Ctrl+0

Show the hides columns.

Ctrl+SHIFT+:

The current time will be entered.

Ctrl+;

The current date will be entered.

Ctrl+'

Shows formula copied.

Ctrl+Shift+"

Copy values in the cell.

Ctrl+-

Column or row will be deleted.

Ctrl+Shift+=

Insert.

Ctrl+Shift+~

Mentioned the values or formulas.

Ctrl+Shift+@

Time formatting.

Ctrl+Shift+!

Comma formatting.

Ctrl+Shift+$

Currency formatting applies.

Ctrl+Shift+#

Date formatting applies.

Ctrl+Shift+%

Percentage formatting applies.

Ctrl+Shift+^

Expand formatting.

Ctrl+Shift+*

Mentions current region.

Ctrl+Shift+&

The border will be placed around selected cells.

Ctrl+Shift+_

Take out a border.

Ctrl++

Put a border.

Ctrl+-

Remove.

Ctrl+Shift+(

Striking.

Ctrl+[

Pressing to select all cells that are connected with the mentioned formula.

.Ctrl+]

Selects.

Ctrl+Shift+{

Selects The cell directly to highlight input formula.

Ctrl+Shift+}

Mention all the cells (which contain formulas ) in active form.

Ctrl+Shift+| (pipe)

You try please, hmmm

Ctrl+Spacebar

Select the whole column.

Ctrl+Shift+

Spacebar

Select all the worksheet cells.

Ctrl+Home

Goes to first sell off the sheet.

Ctrl+End

Goes to the last cell of the sheet.

Ctrl+Tab

Goes to another opened tab of the excel file.

Ctrl+Shift+Tab

Last Activates.

Ctrl+Shift+A

Name into a formula.

Ctrl+Shift+F

Foants_menu_popup.

Ctrl+Shift+O

Mention (the cells that have) comments.

Ctrl+Shift+P

Foants+other_menu_popup.

Shift+Insert

Paste here.

Shift+Page Up

Shift+Page Down

Indicates  all the upper column cells(from selected cell).

Shift+Home

Indicate all the right side cells (right to left).

Shift+End

Active the -End Mode.

Shift+Up Arrow

Selecting cells to upwards direction.

Shift+Down Arrow

Selecting cells to downwards direction.

Shift+Left Arrow

Choosing cells in row one by one right to left.

Shift +Right Arrow

Choosing cells in row one by one left to right.

Alt+Tab

Goes to another opened window.

Alt+Spacebar

Selecting the top menu.

Alt+Backspace

Backward

Alt+Enter

**Missing**

Alt+=

Create a sum formula all for above.

Alt+'

Formatting on a dialog box.

F1

The help menu.

F2

Edit the all highlighted cell.

F3

F3 will paste names after creating a name.

F4

Repeat the last action.

F5

Goes to a selected cell. For For example,click to type C6 it goes to the C column and its 6th row.

F6

Move to next pane(Appears the menu bar in shortcuts)

F7

Check the spelling of selected text or document.

F8

Extended selection (Enters Extend Mode).

F9

Recalculation of every workbook.

F10

Appears the menu bar in shortcuts.

F11

Create a chart from selected data in the opened sheet.

F12

Save the file as an option

.

Shift+F1

Open the "???" window.

Shift+F2

 Open a sell comment (Allows the user to edit a cell comment).

Shift+F3

Excel formula window open.

Shift+F5

Appears as a search box.

Shift+F6

Move to the previous pane.

Shift+F8

Add to selection.

Shift+F9

Performs calculate function on the active sheet.

Ctrl+F3

Excel Name Manager Open.

Ctrl+F4

the current window closed.

Ctrl+F5

window size Restored

Ctrl+F6

Go to Next sheet.

Ctrl+Shift+F6

Go to Previous sheet.

Ctrl+F7

Window moved

Ctrl+F8

Window resized

Ctrl+F9

Minimize.

Ctrl+F10

(window)Maximized

Ctrl+F11

New macro sheet.

Ctrl+F12

File open.

Ctrl+Shift+F3

using those of either row or column labels to Creates names

Ctrl+Shift+F6

Move to the previous worksheet.( the previous worksheet window)

Ctrl+Shift+F12

printed.

Alt+F1

A new chart

Alt+F2

Save As file.

Alt+F4

Exit.

Alt+F8

macro dialog box.

Alt+F11

Visual Basic editor.

Alt+Shift+F1

Create a new sheet.

Alt+Shift+F2

Save as.

 

 

Ctrl+ENTER

Post a Comment

2 Comments

  1. thks dude for the tips, it help me when im using excel hehehe

    ReplyDelete
  2. thks man for ur tips ^_^

    ReplyDelete

Thanks for your feedback we will reply Fast.