Here are assignments related to the ALT key :
6. ALT + Function Keys Shortcut
Shortcut Key Action
Alt+F1 Insert Chart (Creates a chart of the data in the current range)
Alt+F2 Save As
Alt+F4 Closes all workbooks & Exits Excel
Alt+F8 Macro dialog box
Alt+F11 Displays Visual Basic Editor
7. ALT + SHIFT + Function Keys Shortcut
Shortcut Key Action
alt+shft+1 Inserts a new worksheet into the active workbook
Alt+Shft+F2 Displays the Save As dialog box
Alt+Shft+F4 Closes all the workbooks and exits Excel
Alt+Shft+F10 Displays the drop-down menu for the corresponding smart tag
Alt+Shft+F11 Displays the drop-down menu for the corresponding smart tag
8. ALT + Letter Keys Shortcut
Shortcut Key Action
Alt + A + E Convert Text to Columns Wizard
Alt + A + H Hide grouped columns or rows
Alt + A + J Show grouped columns or rows
Alt + A + M Displays the Remove Duplicates dialog box
Alt + A + Q Advanced Filter
Alt + A + SA Sort smallest to largest
Alt + A + SD Sort largest to smallest
Alt + A + SS Displays the Sort dialog box
Alt + B Add or Remove the bottom border
Alt + D Add or Remove the downward diagonal border
Alt + F Go to Backstage View
Alt + H Add or Remove the horizontal interior border
Alt + H + AB Align text to the bottom of the cell
Alt + H + AC Align text to the center of the cell
Alt + H + AL Align text to the left of the cell
Alt + H + AM Align text to the middle of the cell
Alt + H + AN Choose accounting format
Alt + H + AR Align text to the right of the cell
Alt + H + AT Align text to the top of the cell
Alt + H + B Expand Borders drop-down menu
Alt + H + FC Choose font color
Alt + H + FC Expand Font Color drop-down menu
Alt + H + FF Change the font face
Alt + H + FG Increase the font size by 1 point
Alt + H + FK Decrease the font size by 1 point
Alt + H + FM Format Cells dialog box with the Number tab selected
Alt + H + FN Format Cells dialog box with the Font tab selected
Alt + H + FO Clipboard task pane
Alt + H + FP Activates Format Painter
Alt + H + FS Change the font size
Alt + H + H Expand the Fill Color drop-down menu
Alt + H + J Expand the Cell Styles menu
Alt + H + K Format number with a thousand’s comma (,) separator
Alt + H + N Choose number format
Alt + H + T Expand Format as Table drop-down menu
Alt + H + T Expand the Format as Table menu
Alt + H + W Wrap text
Alt + JA Go to the Layout tab of the Ribbon
Alt + JC Go to the Design tab of the Ribbon
Alt + JC + A Expand Add Chart Element drop-down menu
Alt + L Add/ Remove the left border
Alt + L + I Expand the Insert Form Controls and ActiveX Controls drop-down menu
Alt + M + D Trace Dependents
Alt + M + P Trace Precedents
Alt + N + B Insert Bar Chart
Alt + N + C Insert Column Chart
Alt + N + N Insert Line Chart
Alt + N + Q Insert Pie or Doughnut Chart
Alt + N + R Recommended Charts
Alt + N + SD Insert Combo Chart
Alt + N + V Pivot Table
Alt + N + X Insert Text Box
Alt + R Add or Remove the right border
Alt + R + A Show all comments
Alt + R + D Delete comment
Alt + T Add or Remove the top border
Alt + T + O Display Excel Options dialog box
Alt + V Add or Remove the vertical interior border
Alt + W + I Page Break Preview
Alt + W + L Normal View
Alt + W + Q Zoom dialog box
Alt + W + VG View or hide gridlines
|