Navigation and Data Editing of MS-Office Excel 2010

                         Navigation and Data Editing

Arrow keys Move to new cells	ALT + ENTER Start new line in same cell
ALT + Display = a drop-down list	SHIFT + Arrow keys Highlight within cells
ALT + Tab = Switch programs	SHIFT + CTRL + Arrow keys Highlight contiguous items
CTRL + Pg Up/Down = Switch worksheets	BACKSPACE Delete preceding character
CTRL + Tab = Switch workbooks	DELETE Delete character to the right
CTRL + Arrow keys Go to end of contiguous range	F4 Anchor “Fix” Cells
SHIFT + Arrow keys Select a cell range	ESC Cancel a cell entry
SHIFT + CTRL + Arrow keys Highlight contiguous range	F7 Spell check
Home Move to beginning of line	SHIFT + F2 Insert a comment
CTRL + Home Move to cell “A1”	CTRL + F3 Name a cell
F5 “Go to”	ALT + N + V Pivot table
ENTER Move to cell below	ALT + N + K Insert charts
SHIFT + ENTER Move to cell above	ALT + P + S + P Page setup
TAB Move to cell to the right	ALT + A + S Sort options
SHIFT + TAB Move to cell to the left	ALT + A + F + W Data from web
BACKSPACE Delete cell and get inside
DELETE Delete cell/selection
F2 Edit/ highlight dependent cells

Best Excel Keyboard Shortcuts

Excel Keyboard Shortcuts

 

Cell Value & Formula Views

1. CTRL + ` Change between displaying cell values and displaying formulas.

Comments

 

1. SHIFT + F2 Insert and Edit a comment.

2. CTRL + SHIFT + O Select all cells containing comments.



Data Entry

1. CTRL + ENTER Example, highlight or select cells A1:A10. Enter a number or text in cell A1 then press CTRL + ENTER.

 

Dates & Times

1. CTRL + SHIFT + : Inserts the current time.

2. CTRL + ; Inserts today's date.

3. CTRL + SHIFT + # Format the cell as a Date in day, month, year format.

4. CTRL + SHIFT + @ Format the cell as a Time in hours,minutes, and AM or PM.

Sheets & Workbooks

1. CTRL + TAB Moves between workbooks.

2. CTRL + PG & CTRL + PG DOWN moves between sheets.

Toolbars

1. CTRL + 7 Show or hide the Standard toolbar.

For more shortcut keys Click Here 

Shortcut Keys and Tips for MS-EXCEL

Enthusiasm Exceed is a worksheet program used to make and control dealings that deal with bookkeeping. To make this possible, it can assist you with developing details of dealings, then using those list to make index charts and other research resources.

For Shortcut Keys PDF File Click Here

The Search Bars

On the right part of the tissues place, there is a straight scroll bar that allows       you to scroll up and down in situation your papers cannot screen everything at a time:


In the reduced right area of the main screen, there is a horizontally search bar that allows you to search eventually left and right if your worksheet has more products than can be shown all at once: