Free Excel Tips & Tricks

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

Tuesday, July 10, 2018

EXCEL SMART ART USING SHORTCUT KEYS

EXCEL SMART ART USING SHORTCUT KEYS

ARROW KEYS
Purpose:Use this excel shortcut key to Select elements

ESC
Purpose:Use this excel shortcut key to Remove Focus from Selection.

F2
Purpose:Use this excel shortcut key to Edit Selection Text in if possible (in formula bar).

ALT + F1
Purpose:Use this excel shortcut key to Create an embedded chart using currently selected data

ALT + JA
Purpose:Use this excel shortcut key to (A) In Excel 2013 and later, go to Format tab of the Ribbon (when active); or (B) In Excel 2007 and 2010, go to Layout tab of the Ribbon (when active)

ALT + JC
Purpose:Use this excel shortcut key to Go to Design tab of the Ribbon (when active)

ALT + JC + A
Purpose:Use this excel shortcut key to In Excel 2013 and later, expand Add Chart Element drop-down menu

ALT + N + B
Purpose:Use this excel shortcut key to Insert Bar Chart in a sheet.

ALT + N + C
Purpose:Use this excel shortcut key to Insert Column Chart in a sheet.

ALT + N + N
Purpose:Use this excel shortcut key to Insert Line Chart in a sheet

ALT + N + Q
Purpose:Use this excel shortcut key to Insert Pie or Doughnut Chart

ALT + N + R
Purpose:Use this excel shortcut key to In Excel 2013 and later, Recommended Charts

ALT + N + SD
Purpose:Use this excel shortcut key to In Excel 2013 and later, Insert Combo Chart

ALT + N + X
Purpose:Use this excel shortcut key to Insert Text Box

F11
Purpose:Use this excel shortcut key to Create a chart in a separate Chart sheet using currently selected data

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