top of page
Search

MICROSOFT EXCEL FOR FRESHERS

Updated: Jun 20, 2021

Many fershers won't understand the importance of Microsoft Excel until they are employed.Experienced people and who are into management will understand this.

Below are important formulae useful for freshers........




  • Page Up Moves to the previous screen of rows up

  • Shift + Enter Moves to the cell directly above (opposite direction to enter)

  • Shift + Tab Moves to the cell directly to the left(opposite direction to Tab)

  • Alt + Page Up Moves you one screen of coloumns to the left

  • Alt + Page Down Moves you one screen of coloumns to the right

  • Ctrl + Home Moves to the cell "A1"on the active sheet

  • Ctrl + End Moves to the last used cell on the active worksheet

  • Ctrl + Up Arrow Moves to the first row in the current region

  • Ctrl + Down Arrow Moves to the last row in the current region

  • Ctrl + Left Arrow Moves to the first column in the current

  • Ctrl + Right Arrow Moves to the last column in the current region

  • Ctrl + Page Up Moves to the previous worksheet in the workbook

  • Ctrl + Page Down Move to the next worksheet in the workbook

  • Ctrl + Shift +Tab Moves to the previous open workbook or window

  • Scroll lock + Arrow Keys Move the workbook or window one cell the corresponding direction.

  • Scroll lock + End Move to the last cell in the current window rst cell in the current window

  • Scroll lock + Home Moves to the first cell in the current window.

  • Scroll lock + page Down Moves you down one screen current selection unchanged

  • Enter Moves from top to bottom within a selection.

  • Tab Moves from left to right within a selection

  • Ctrl + _ Moves clockwise to the next corner within a selection

  • Shift + Tab Moves from right to left within a selection (opposite diection to Tab)

  • Alt + Ctrl + Left Arrow moves to the left between non adjacent cells in a selection

  • Alt + Ctrl + Right Arrow moves to the right between non adjacent cells in a selection.

  • = starts a formula.

  • Ctrl + * Toggles between the value layer and the formula layer.

  • Ctrl + Insert Copies the current selection to the clipboard.

  • Ctrl + Shift + ( unhides any hidden rows within the selection.

  • Ctrl + Shift + ) unhides any hidden columns within the selection.

  • Ctrl + Shift + Spaceabar selects all the objects on the worksheet when an object selects the whole worksheet.

  • Ctrl + Spacebar select the current coloumn.

  • Shift + Arrow keys select the active cell and the cell is the given direction.

  • Shift + Backspace select the active cell when multiple cells are selected.

  • Shift + Spacebar selects the current row.

  • Ctrl + Shift +Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction.

  • Ctrl + Shift + End Extends the selection to the last used cell on the worksheet.

  • Ctrl + Shift + Home Extends the selection to the last used cell on the worksheet.

  • Shift + Arrow keys Extends the selection by one cell in that direction.

  • Shift + Home Extends the selection to the first column.

  • Shift + Page down Extends the selection down one screen.

  • Shift +Page Up Extends the selection up one screen.

  • End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction.

  • End + Shift + End Extends the selection to the last cell in the current row.

  • End + Shift + Home Extends the selection to the last used cell on the worksheet.

  • Alt + " displays the style dialog box.

  • Ctrl + Shift +(4 or $) Applies the currency format to the selection.

  • Ctrl + Shift + (5 or %) Applies the percentage format the selection.

  • Ctrl + Shift + (6 or ^) Applies the Exponential format to the selection.

  • Ctrl + Shift + (7 or &) Applies the outline border to the selections.

  • Ctrl + Shift + (+ or _) Removes all the borders from the selection.

  • Arrow Keys Moves to the next cell in that direction.

  • Ctrl + Tab Moves to the next open workbook or window.

  • Alt + Tab Moves to the next application open on your computer.

  • Alt + Shift + Tab Moves to the previous application open on your computer.

  • Enter Moves to the cell directly below.

  • Tab Moves to the next cell on the right (or unedxpected cell).

  • Home Moves to the first column in the current row.

  • End + Arrow Keys Moves to the next non empty cell in that direction.

  • End + Enter Moves to the last cell in the current row that is not blank.

  • End + Home Moves to the last used cell on the active worksheet.

  • Page Down Moves to the next screen of rows down.

27 views0 comments

Recent Posts

See All

Comments


bottom of page