SHORTCUT KEYS IN EXCEL

SHORTCUT KEYS IN EXCEL

Shortcut keys excel is most useful for a user because shortcut keys save your working time and make your task much efficient. This tutorial tells you about some important shortcut keys of excel .

Formatting Text In Excel

Description

  • Ctrl + B= Bold toggle for selection

  • Ctrl + I= Italic toggle for selection

  • Ctrl + U= Underline toggle for selection

  • Ctrl + 5= Strike-through for selection

  • Ctrl + Shift + F= Change the font

  • Ctrl + Shift + P= Change the font size

  • Ctrl + Shift + 7= Apply outline borders

  • Alt + Enter= Wrap text in same cell

 

Description

  • Ctrl + N New file

  • Open file Ctrl + O

  • Ctrl + S Save file

  • Move between open workbooks Ctrl + F 6

  • Ctrl +  F 4 Close file

  • F 12 Save as

  • Ctrl + P Display the print menu

  • Ctrl + A Select whole spreadsheet

  • Ctrl + Space Select column

  • Shift + Space Select row

  • Ctrl + Z Undo last action

  • Ctrl + Y Redo last action

  • Alt + F 4 Exit Excel

    Navigating

  • Description

  • Tab= Move to next cell in row

  • Shift + Tab= Move to previous cell in row

  • Page Up= Up one screen

  • Page Down= Down one screen

  • Ctrl + Page Down= Move to next worksheet

  • Ctrl + Page Up= Move to previous worksheet

  • Ctrl + Home= Go to first cell in data region

  • Ctrl + End= Go to last cell in data region

    Formatting Cells

  • Description 

  • Ctrl + 1= Format cells

  • Ctrl + Shift + F= Select font

  • Ctrl + Shift + P= Select point size

  • Ctrl + Shift + 4= Format as currency

  • Ctrl + Shift + 5= Format as percentage

  • Ctrl + Shift + 1= Format as number

    Editing/Deleting Text

  • Description 

  • Delete one character to right = Delete

  • Delete one character to left = Backspace

  • Edit active cell = F 2

  • Cancel cell entry = Escape Key

  • Highlighting Cells

  • Description

  • Select entire worksheet = Ctrl + A

  • Select entire row = Shift + Space-bar

  • Select entire column = Ctrl + Space-bar

  • Manual select = Hold Shift + with Left, Right, Up, Down Arrow

Key  Display & Printing

Discription

Alt + W + F + F=Freeze Panes

Alt + W + Q=Zoom

Ctrl + Mouse Scroll Wheel=Zoom

Alt + P + S + P=Page Setup

Alt + P + R + S=Set Print Range to Selected Area

Ctrl + F 2=Print Preview

Alt + W + I=Page Break View

Alt + W + L=Normal View

Alt + W + VG=Toggle Grid-lines

  • Inserting Text Automatically

  • Description 

  • Auto sum a range of cells = Alt + “=” Equals Sign

  • Insert the date = Ctrl + ; (semi-colon)

  • Insert the time = Ctrl + Shift + ; (semi-colon)

  • Insert columns/rows = Ctrl + Shift + + (plus sign)

  • Insert a new worksheet = Shift + F 11

  • Misc

  • Description 

  • SHORTCUT KEYS IN EXCEL

  • Find text = Ctrl + F

  • Replace text dialog = Ctrl + H

  • Create a chart automatically on new sheet = F 11

  • Edit a cell comment = Shift + F 2

  • Move to Next Sheet = Ctrl + Page Down

  • Move to Prior Sheet = Ctrl + Page Up

  • Go to a cell command = Ctrl + G

  • Auto Sum= Alt + Equals(=)

  • Formula Mode = Equals Sign

  • Insert Date In Current Cell = Ctrl + ; (semicolon)

  • Insert Time In Current Cell = Ctrl + Shift + ; (semicolon)

  • Spell Check = F 7

  • Tab Backwards = Shift + Tab

  • Auto Filter Ctrl + Shift + A

  • Cell Hyperlink Alt + Shift + H

Filtering, Sorting & Validation

Shortcut keys in excel

Alt + A + SS=Sort Data

Alt + A + SA=Sort Ascending

Alt + A + SD=Sort Descending

Ctrl + Shift + L=Filter Data

Alt + A + Q=Advanced Data Filter

Right Mouse Button + E + V=Filter by Cell’s Properties

Alt + A + M=Remove Duplicates

Format Menu

SHORTCUT KEYS IN EXCEL

Ctrl + 1=Format Dialog

Ctrl + Alt + V=Paste Special

Ctrl + Alt + V + T=Paste Formats

Ctrl + Alt + V + V=Paste Values

Ctrl + Alt + V + F=Paste Formulas

Alt + H + FC=Font Color

Alt + H + H=Fill Color

Alt + H + B=Border Options

Alt + H + A + L / C / R=Align Left / Center/ Right

Alt + H + 6=Increase Indent

Alt + H + 5=Decrease Indent

Alt + H + 0=Increase Decimal Places

Alt + H + 9=Decrease Decimal Places

Ctrl + B=Bold

Ctrl + I=Italics

Ctrl + U=Underline

Ctrl + 5=Strike-through

Ctrl + Shift + &=Add Borders

Ctrl + Shift + –=Delete Borders

Shift + Ctrl + ~=General

Shift + Ctrl + !=Number

Shift + Ctrl + @=Time

Shift + Ctrl + #=Date

Shift + Ctrl + $=Currency

Shift + Ctrl + %=Percentage

Shift + Ctrl + ^=Scientific

=TEXT(Cell, Format)=Displays cell using custom format

Alt + H + O + I=Auto-Fit Col.

Alt + H + O + A=Auto-Fit Row

Alt + H + O + W=Column Width

Alt + H + O + H=Row Height

Alt + H + L + R=Conditional Formatting

Alt + H + T=Format as Table

 

 

One thought on “SHORTCUT KEYS IN EXCEL

  1. Hi There! We are looking for some people that might be interested in from working their home on a part-time basis. If you want to earn $500 a day, and you don’t mind writing some short opinions up, this might be perfect opportunity for you! Simply check out the link here NOW!

Leave a Reply

Your email address will not be published. Required fields are marked *