Windows & Office Keyboard Shortcuts

[http://neerajsingh.bizhat]

Excel Shortcuts - Move within Selection

Ctrl . Move clockwise to the next corner of the
selection

Ctrl + Alt Left Arrow Move left between nonadjacent selections

Ctrl + Alt Right Arrow Move right between nonadjacent selections

Shift Tab Move left

Shift Tab Move right

[http://neerajsingh.bizhat]

Excel Shortcuts - Outline Data

Ctrl 8 Display or hide outline symbols

Alt + Shift Left Arrow Ungroup rows or columns

Alt + Shift Right Arrow Group rows or columns

[http://neerajsingh.bizhat]

Excel Shortcuts - Print

Ctrl + Shift F13 Display the Print dialog box

Ctrl P Display the Print dialog box

[http://neerajsingh.bizhat]

Excel Shortcuts - Select Cells

Ctrl 6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects

Ctrl 7 Show or hide the Standard toolbar

Ctrl + Shift * Select the current region

Ctrl / Select current array

Alt ; Select visible cells in current selection

Ctrl [ Select direct dependents

Ctrl + Shift [ Select all dependents

Ctrl \ Select differences

Ctrl + Shift \ Select unequal cells

Ctrl ] Select direct precedents

Ctrl + Shift ] Select all precedents

Ctrl A Select the entire worksheet

Ctrl + Shift Arrow Key Extend the selection to the last nonblank cell in the same column or row as the active cell

Shift Arrow Key Extend the selection by one cell

Shift Backspace Select only the active cell when multiple
cells are selected

Ctrl + Shift End Extend the selection to the
last used cell on the worksheet (lower-right corner)

Shift F8 Add another range of cells to the
selection; or use the arrow keys to move to the start of the range you
want to add, and then press F8 and the arrow keys to select the next
range

Shift F8 Turn on extending a selection by using
the arrow keys

Ctrl + Shift Home Extend the selection to the
beginning of the worksheet

Shift Home Extend the selection to the beginning of
the row

Ctrl + Shift O Select all cells with comments

Shift Page Down Extend the selection down
one screen

Shift Page Up Extend the selection up one screen

Ctrl Spacebar Select the entire column

Ctrl + Shift Spacebar With an object selected,
select all objects on a sheet

Shift Spacebar Select the entire row

[http://neerajsingh.bizhat]

Excel Shortcuts - Windows

Ctrl Esc Show the Windows Start menu

Ctrl F10 Maximize or restore the workbook window

Ctrl F4 Close the active workbook window

Ctrl F5 Restore the active workbook window size

Ctrl F7 Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window

Ctrl F8 Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window

Ctrl F9 Minimize the workbook window to an icon

Alt Print Screen Copy the image of the active window to the Clipboard

Alt Print Screen Copy the image of the screen to the Clipboard

Alt Tab Switch to the next program

Alt + Shift Tab Switch to the previous program

Ctrl W Close the active workbook window

[http://neerajsingh.bizhat]

Excel Shortcuts - Worksheets

Shift F11 Insert a new worksheet

Alt + Shift F2 Insert a new worksheet

Ctrl + Shift Page Down Select current and next sheet in workbook

Ctrl + Shift Page Up Select current and previous in workbook

[ftvfatboy]

thannkoo http://neerajsingh.bizhat.
post more
live more in bizhat community.

[pH]

Excell short cuts was very useful for me.
Thanks Neeraj For sharing
Have a nice day

[http://neerajsingh.bizhat]

Thanks a lot friends for your appreciation.

[pH]

Neeraj any more tutorial available for automatic data copying from other pages? means, for formulaes like that

i don't know the exact name