Blog - Ms excel Short Command

Ms excel Short Command

Ms excel Short Command

Microsoft Excel Short Command

 ctrl +1

open the format cells dialog box

ctrl+2

Bold

ctrl+3

italic

ctrl+4

underline

ctrl+5

 strike through

ctrl+6

show/ hide object

ctrl+9

hide row

ctrl+shift+9

unhide row

ctrl+o

Hide column

ctrl+shift+o

unhide  column

ctrl+~

Increase column width

 ctrl+pgdown

switch to the next worksheet

ctrl+ Pgup

switch to the previous sheet

Home

Return to the 1st cell of the current row in a worksheet .

ctrl+ home

Move to the last used cell of the current worksheet.

ctrl+space

select entire column

shift+ space

select entire row

ctrl+ -

Delete (Row, columns or cell)

 

 ctrl + ;

insert current date

ctrl + shift+ :

insert current time

ctrl + F1

shown/hide the Excel Ribbon

ctrl+F4

close window

ctrl  + F9

Minimize workbook

ctrl +F10

Maximize window

ctrl + F12

Open File

F2

 Edit the current cell

Alt + Enter

In cell editing mode, enter a new line.

ctrl +sh +home

select entire range of cell from end to start

ctrl +sh+ End

select entire range of cell from start to end

ctrl +sh+''

copy value from cell above

ctrl + sh+ &

Place outline border around selected cell

ctrl +sh+ _

Remove outline border

 ctrl + sh+ +

Insert (row, columns or cell)

ctrl + sh +~

General number format

ctrl + sh +!

 Two decimal places, thousands separator ex-16618 change 16,618.00

ctrl +sh +$

Currency format with two decimal places

ctrl +sh+%

Percentage format with no decimal places (apply blank cell)

 ctrl + sh +^

Scientific rotation number format with two decimals

Alt +ctrl +v

paste special box

 ctrl +Alt+v+t

paste format only

Alt +w+f

(un)Freeze window

F8

Anchor to highlight

F11

New chart

F12

Save as

shift +F2

 Insert a comment

 shift +F3

 Insert function box

shift+ F5

Find

shift +F8

Add to selection

shift +F10

Display shortcut menu

shift + F11

 New worksheet

 


311 1 year ago