Microsoft Excel 2013 Keyboard Shortcut keys

Microsoft Excel 2013 Keyboard Shortcut keys from custom guide online training.

EXCEL SHORTCUT KEYS FOR NAVIGATION

Make easy and quick  navigation by using this keys in your excel

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

Save the below image for your desktop use.

EXCEL SHORTCUT KEYS FOR SELECTION

Use this shortcut keys for Selection in your Excel.
 

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

Save the below image for your desktop use.

How to copy and paste image's in excel using shortcutKeys

Here some useful tips to copy and paste images in your excel sheet.

1. Click on the image Right Click => copy => paste in next cell.

2. Use Keyboard shortcut keys Ctrl + C for (copy) Ctrl + V for (paste)

3. Click on the image hold Ctrl + Drag with mouse.

How to insert division symbol in excel

Hello Friends, this month will be the end for closing year for accounting & finance. so we need to do types of reports to compare last year and this year flow.

Especially for Accounts & sales they need to do comparison,so lets give them a Quick tip to improve their reports.



Just hold your Alt key and type 0247 to get Division symbol.



  

Excel 2007 Shortcut Keys for (Alt)

Excel 2007 Shortcut Keys for (Alt)

Excel Tip : Hold Alt Key and push down next key (Ex : Hold Alt key then type F4)

Excel 2007 Shortcut Keys for (Ctrl)

Excel 2007 Shortcut Keys for (Ctrl)

Push Ctrl while drawing Autoshapes to expand outwards (good for placing circles in precise locations)

Excel 2007 Shortcut Keys for (Function)

Excel 2007 Shortcut Keys for (Function)