Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Friday, July 27, 2018

EDITING CELLS USING EXCEL SHORTCUT KEYS

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2
Purpose:Use this excel shortcut key to Edit the active cell with cursor at end of the line.

ALT +ENTER
Purpose:Use this excel shortcut key to Start a new line in the same cell.

ENTER
Purpose:Use this excel shortcut key to Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell.

SHIFT +ENTER
Purpose:Use this excel shortcut key to Complete a cell entry and move up in the selection.

ESC
Purpose:Use this excel shortcut key to Cancel a cell entry.

BACKSPACE
Purpose:Use this excel shortcut key to Delete the character to the left of the insertion point, or delete the selection.

DELETE
Purpose:Use this excel shortcut key to Delete the character to the right of the insertion point, or delete the selection.

CTRL +DELETE
Purpose:Use this excel shortcut key to Delete text to the end of the line.

CTRL +; (SEMICOLON)
Purpose:Use this excel shortcut key to Insert current date.

CTRL +SHIFT +: (COLON)
Purpose:Use this excel shortcut key to Insert current time.

CTRL +T
Purpose:Use this excel shortcut key to Show all content as standard numbers. (So 14:15 becomes 14.25 etc for the entire file) To undo press ctrl + t again

Thursday, July 26, 2018

EXCEL AUTOFILL SHORTCUT KEYS

EXCEL AUTOFILL SHORTCUT KEYS

ALT +ARROW DOWN
Purpose:Use this excel shortcut key to On the field with column head, display the AutoFilter list for the current column .

ARROW DOWN /ARROW UP
Purpose:Use this excel shortcut key to Select the next item / previous item in the AutoFilter list.

ALT +ARROW UP
Purpose:Use this excel shortcut key to Close the AutoFilter list for the current column.

HOME /END
Purpose:Use this excel shortcut key to Select the first item / last item in the AutoFilter list.

ENTER
Purpose:Use this excel shortcut key to Filter the list by using the selected item in the AutoFilter list.

CTRL +SHIFT +L
Purpose:Use this excel shortcut key to Apply filter on selected column headings.

Wednesday, July 25, 2018

EXCEL DATA FORMS SHORTCUT KEYS

EXCEL DATA FORMS SHORTCUT KEYS

TAB /SHIFT +TAB
Purpose:Use this excel shortcut key to Move to the next / previous field which can be edited. Move to the next / previous option.

ENTER /SHIFT +ENTER
Purpose:Use this excel shortcut key to Move to the first field in the next / previous record.

PAGE DOWN /PAGE UP
Purpose:Use this excel shortcut key to Move to the same field 10 records forward / back. Move one screen down / one screen up in a worksheet.

CTRL +PAGE DOWN
Purpose:Use this excel shortcut key to Move to a new record.

CTRL +PAGE UP
Purpose:Use this excel shortcut key to Move to the first record.

HOME /END
Purpose:Use this excel shortcut key to Move to the beginning / end of a field.

Tuesday, July 24, 2018

EXCEL FILE AND FEATURES SHORTCUT KEYS

EXCEL FILE AND FEATURES SHORTCUT KEYS

CTRL +O
Purpose:Use this excel shortcut key to Open File

CTRL +S
Purpose:Use this excel shortcut key to Save the active file with its current file name, location, and file format.

F12
Purpose:Use this excel shortcut key to Display the Save As dialog box.

F10
Purpose:Use this excel shortcut key to Turn key tips on or off.

CTRL +P
Purpose:Use this excel shortcut key to Print File (Opens print menu).

F1
Purpose:Use this excel shortcut key to Display the Excel Help task pane.

F7
Purpose:Use this excel shortcut key to Display the Spelling dialog box.

SHIFT +F7
Purpose:Use this excel shortcut key to Display the Thesaurus dialog box.

ALT +F8
Purpose:Use this excel shortcut key to Display the Macro dialog box.

ALT +F11
Purpose:Use this excel shortcut key to Open the Visual Basic Editor to create Macros.

EXCEL DIALOG BOX SHORTCUT KEYS

EXCEL DIALOG BOX SHORTCUT KEYS

ARROW KEYS
Purpose:Use this excel shortcut key to Move between options in the active drop-down list box or between some options in a group of options.

SPACE
Purpose:Use this excel shortcut key to In a dialog box: perform the action for the selected button, or select/clear a check box. Select or clear a check box in the list.

A ... Z
Purpose:Use this excel shortcut key to Move to an option in a drop-down list box starting with the letter

ALT +A ... ALT +Z
Purpose:Use this excel shortcut key to Select an option, or select or clear a check box.

ENTER
Purpose:Use this excel shortcut key to Perform the action assigned to the default command button in the dialog box.

ESC
Purpose:Use this excel shortcut key to Cancel the command and close the dialog box.

Monday, July 23, 2018

EXECUTE EXCEL FORMULAS USING SHORTCUT KEYS

EXECUTE EXCEL FORMULAS USING SHORTCUT KEYS

=
Purpose:Use this excel shortcut key to Start/enter a formula

ALT +=
Purpose:Use this excel shortcut key to Insert the AutoSum formula.

CTRL +SHIFT +A
Purpose:Use this excel shortcut key to Insert Arguments in formula after typing formula name. .

SHIFT +F3
Purpose:Use this excel shortcut key to Insert a function into a formula. Display the Insert Function dialog box.

CTRL +SHIFT +ENTER
Purpose:Use this excel shortcut key to Enter a formula as an array formula.

F4
Purpose:Use this excel shortcut key to After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F9
Purpose:Use this excel shortcut key to Calculate all worksheets in all open workbooks.

SHIFT +F9
Purpose:Use this excel shortcut key to Calculate the active worksheet.

CTRL +ALT +F9
Purpose:Use this excel shortcut key to Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL +ALT +SHIFT +F9
Purpose:Use this excel shortcut key to Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

CTRL +SHIFT +U
Purpose:Use this excel shortcut key to Toggle expand or collapse formula bar.

CTRL +`
Purpose:Use this excel shortcut key to Toggle Show formula in cell instead of values

Sunday, July 22, 2018

EXCEL NAMING SHORTCUT KEYS

EXCEL NAMING SHORTCUT KEYS

CTRL +F3
Purpose:Use this excel shortcut key to Define a name or dialog.

CTRL +SHIFT +F3
Purpose:Use this excel shortcut key to Create names from row and column labels.

F3
Purpose:Use this excel shortcut key to Paste a defined name into a formula.

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...