Here Are 50 Best Excel Shortcuts You Need To Know

Excel_shortcuts

Among Microsoft Office Suite, Excel is the most useful one for engineers. All our engineering degrees we are forced to learn different software that are supposed to help in our professional careers later on, but what we aren’t told is that instead of them, we would be using Microsoft Excel the rest of our lives. Nevertheless, it is a useful and interesting bit of software that you might have to spend the rest of your life with. Here are some of the most useful excel shortcuts that you can use to make lives easier for yourself:

F2 : Edit selected cell

F4 : Repeat the last edit

F9 : Does calculation on all worksheets

F11 : New chart

ALT : Access the ribbon for formulas

ALT + = : Automatically SUM() selected

ALT + Enter : Start a new line in the same cell

ALT + o-c-a : Auto size columns

PG + UP/PG+DOWN : Go to next/previous worksheet

CTRL + ` : Display Formulas

CTRL + Backspace : Show active cell

CTRL + Shift + # : Change Date format with day, month and year.

CTRL + K : To insert Hyperlink.

CTRL+ Shift + $ : Applies the currency format to the selected cells.

CTRL + Shift + & : Applies border to cells

CTRL + B : Change font to Bold

CTRL + I : Change font to Italics

CTRL + U : Underline selected text

CTRL + Shift + ~ : General style number

CTRL + Shift + $ : Currency style number

CTRL + Shift + % : Percentage style Number

CTRL + Shift + ^ : Scientific notation style

CTRL + Shift + # : Date style

CTRL + Shift + @ : Time Style

CTRL + Shift +! : Number Style

CTRL + F12 : Open

CTRL + Spacebar : Select the entire column

CTRL + [ : Select all cells directly referenced by formulas in the selection

CTRL + ; : Insert actual date in active cell

CTRL + : : Insert actual time in active cell

CTRL + A : Select All

CTRL + Shift + J : List Constants

CTRL + D : Copy equation down

CTRL + F : Find

CTRL + H : Find&Replace

CTRL + Right arrow : Move right

CTRL + Left arrow : Move left

CTRL + Up arrow : Move up

CTRL + Down arrow : Move down

CTRL + Enter : Same data in multiple cells

Shift + Spacebar : Select the entire row

Shift + F3 : Find Previous

Using all of these will be tedious and difficult at first, but trust, once you have got the hang of it, it will be just like typing without seeing all over again!

2 comments

  1. Gord Reply

    Ctrl+shift- $ is repeated.
    Ctrl-D will copy selection down not just an equation.

Leave a Reply

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