For any general information / health tips / beauty tips / education / public holidays / Chennai news / gold & silver rate / Interview Tips/

Whatsapp forwards and Jokes

Visit, www.myinboxinfo.blogspot.in

Tuesday, 27 November 2012

MS Excel Shortcut Keys Tutorials Tips

Why complicate your spreadsheet life with a bunch of tricks you’ll never use?

These shortcuts will expedite the Excel tasks you perform every day.



Here is the solution which improve your accuracy and make your life easier.

Spend few minutes to save your valuable time ….


Select the whole column

CTRL + SPACE

Select the whole row

SHIFT + SPACE

Select table

SHIFT + CTRL + SPACE bar

Save

CTRL + s

Select visible cells only

ALT + ;

Select entire region

CTRL + A

Select range from start cell to far left

SHIFT + Home

Select range from start cell to end in direction of arrow

SHIFT + End + arrow

Select a continuous range of data (e.g. pivot), no matter where your cursor is.

CTRL + *

Select blank cells

F5 + ALT + S + K + ENTER

Select all cells with comments

CTRL + SHIFT + O

Select all cells that are directly or indirectly referred to by formulas in the selection

CTRL + SHIFT + {

Select all cells with formulas that refer directly or indirectly to the active cell

CTRL + SHIFT + }

Selects all the way to a1 from cursor position

CTRL + SHIFT + HOME

Select cells in the direction of arrow

CTRL + SHIFT + Arrow

Previous sheet

CTRL + Page Up

Next sheet

CTRL + Page Down

Launch GO TO Dialog (from here you can select special or jump to a cell or range)

F5

Go to top left (will go to top left of freezed pane if set)

CTRL + Home

Go to last non-blank cell

CTRL + end

Go to previous sheet

CTRL + PgUp

Go to next sheet

CTRL + PgDn

Print

CTRL + p

Toggle between workbooks in a given session of excel.

CTRL + TAB

Change the type of cell reference from relative to absolute or semi-absolute

F4

Repeat whatever you did last

F4

Debug portions of a formula (select and press)

F9

Sum range

ALT + =

Enter array formula

CTRL + SHIFT + Enter

Select array formula range

CTRL + /

Display range names (can be used when typing formulas)

F3

Copy a formula from above cell and edit

CTRL + '

Display the formula palette after you type a valid function name in a formula

CTRL + A (while writing a formula)

Alternate between displaying cell values and displaying cell formulas

CTRL + ` (Single Left Quotation Mark)

Calculate formulas

F9

Select all precedent cells

CTRL + [

Select all dependent cells

CTRL + ]

Format Selection (cells, objects, charts)

CTRL + 1

Bold a cell’s content

CTRL + B

Format Painter – Paste formats from selection

ALT + EST

Format as number with 2 dp

CTRL + SHIFT + 1

Format as local currency

CTRL + SHIFT + 4

Format as percentage with 0 dp

CTRL + SHIFT + 5

Hide row

CTRL + 9

Hide column

CTRL + 0

Unhide row

CTRL + SHIFT + 9

Unhide column

CTRL + SHIFT + 0

Display the style command format menu

ALT + '

Sets/removes strikeout in current cell

CTRL + 5

Show/hide the top bar when you have a group

Crtl + 8

Single border around selected cells

CTRL + SHIFT + 7

Sort

ALT + DS

Insert hyperlink

CTRL + K

Freeze panes

ALT + WFF

To wrap lines

ALT + HW (2007+)

Save as

F12

Collapse the ribbon (press again to expand)

CTRL + F1

Opens print preview

CTRL + F2

Maximize the current window

ALT + SPACE X

Activate next window

ALT + TAB

Activate previous window

ALT + SHIFT + TAB

Close an excel workbook

crtl + F4

Split screens

ALT + W + S

Create a pivot table in new sheet (of course after selecting the range)

ALT + DPF

Create a pivot table in the same sheet.

ALT + DPN

Show visual basic editor

ALT + F11

Macro dialog

ALT + F8

Apply/remove filter

ALT + DFF

Keep filter on columns, but show all rows

ALT + DFS

Insert pivot table

ALT + NVT

Turn filter on or off

CTRL + SHIFT + L

Paste values only

ALT + ESV

Edit a cell, place cursor at the end

F2

Show in-cell drop down with previously entered values

ALT + Down arrow

Fills down value from cell above

CTRL + D

Add a comment or Edit comment

SHIFT + F2

Insert new sheet

SHIFT + F11

Insert row

CTRL + +

Delete row

CTRL + -

Copy

CTRL + C

Paste

CTRL + V

Cut

CTRL + X

Undo

CTRL + Z

Get a line break inside the cell

ALT + Enter (while editing the cell)

Clear all contents

ALT + EAA

Copy

CTRL + insert

Paste

SHIFT + Insert

Make chart/pivot chart

F11

Edit a cell in Apple Macs

CTRL + U

Copy the value from the cell above the active cell into the cell or the formula bar

CTRL + SHIFT + "

Copies whatever is in the cell to the left of it.

CTRL + R

Delete box (cell, row, column)

ALT + ED

Insert box (cell, row, column)

ALT + IE

Enter current date

CTRL + ;

Enter current time

CTRL + :

0 comments:

  © Blogger templates Newspaper III by Ourblogtemplates.com 2008

Back to TOP  

Related Posts Plugin for WordPress, Blogger...