Free Excel Tips & Tricks

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

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.

No comments:

Post a Comment

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...