Can you excel yourself without using a mouse?

 

Microsoft Excel

 

-Can you excel yourself without using a mouse? 

 

By using keyboard shortcuts and key commands, Microsoft Excel may be utilized effectively without a mouse. You can carry out the following routine actions using the keyboard shortcuts listed below:

 

v  Navigating Cells:

v  Selecting Cells:

v  Editing Cells:

v  Formatting Cells:

v  Working with Worksheets and Workbooks:

v  Formulas:

v  Managing Rows and Columns:

v  AutoFill and Data Entry:

v  Working with Charts:

v  Find and Replace:

v  Working with Ribbon and Menus:

v  Undo and Redo:

 

keyboard shortcuts and key commands

 

v      Navigating Cells:

 

·         Move one cell in any direction: Arrow keys (Up, Down, Left, Right).

·         Move to the edge of data region: Ctrl + Arrow keys.

 

v Selecting Cells:

 

·         Select one cell: Arrow keys.

·         Select a range of cells: Shift + Arrow keys.

·         Select the entire column or row: Ctrl + Space (Column) or Shift + Space (Row).

v Editing Cells:

·         Enter Edit mode: F2 or Enter.

·         Exit Edit mode: Enter (to move down) or Tab (to move right).

·         Cancel Edit mode: Esc.

·         Copy: Ctrl + C, Cut: Ctrl + X, Paste: Ctrl + V.

v Formatting Cells:

·         Open Format Cells dialog box: Ctrl + 1.

·         Bold: Ctrl + B, Italic: Ctrl + I, Underline: Ctrl + U.

·         Increase Font Size: Ctrl + Shift + >, Decrease Font Size: Ctrl + Shift + <.

v 

Working with Worksheets and Workbooks:

·         Move to next worksheet: Ctrl + Page Down, Move to previous worksheet: Ctrl + Page Up.

·         Save workbook: Ctrl + S, Open workbook: Ctrl + O, Create new workbook: Ctrl + N.

·         Close workbook: Ctrl + W, Close Excel: Alt + F4.

v 

Formulas:

·         Enter formula bar: F2.

·         Recalculate worksheet: F9, Recalculate all worksheets: Ctrl + Alt + F9.

v 

Managing Rows and Columns:

·         Insert row: Ctrl + Shift + + (Plus key), Insert column: Ctrl + Space, then Ctrl + Shift + + (Plus key).

·         Delete row: Ctrl + - (Minus key), Delete column: Ctrl + Space, then Ctrl + - (Minus key).

v 

AutoFill and Data Entry:

·         AutoFill: Select the cell with data, hold down the Ctrl key, and drag the fill handle (small square at the bottom-right corner of the selected cell).

·         Data Validation: Alt + D, L, then use arrow keys and Enter to navigate and select options.

v 

Working with Charts:

·         Create a chart: Alt + F1.

·         Move between elements in a chart: Tab key.

v 

Find and Replace:

·         Find: Ctrl + F, Replace: Ctrl + H.

v 

Working with Ribbon and Menus:

·         Navigate Ribbon tabs: Alt, then use arrow keys.

·         Access context menus: Shift + F10 or the Application key (usually located between the right Alt and Ctrl keys).

v Undo and Redo:

·         Undo: Ctrl + Z, Redo: Ctrl + Y.

         These are just a few of the typical operations that Excel allows you to complete without the use of a mouse. When using Excel just from the keyboard, becoming familiar with these keyboard shortcuts will greatly increase your productivity.