Timofey@timofey

关注

Excel Keyboard Shortcuts Guide

Excel shortcuts for managing your data directly from the keyboard. Press Alt + H + O + I to auto-fit column width, which adjusts the size to fit the longest content and helps clean up large reports quickly. Use Alt + H + O + A to auto-fit row height instead. If you need text wrapping, hit Alt + H + W. Changing font color is as simple as Alt + H + F + C, while opening the Fill Color menu requires Alt + H + H. Apply all borders with Alt + H + B + A or remove them entirely using Alt + H + B + N. Merging and centering cells works via Alt + H + M + C, whereas unmerging uses Alt + H + M + U. Aligning text left, right, or centered follows Alt + H + A + L, Alt + H + A + R, and Alt + H + A + C respectively. Deleting selected columns takes Alt + H + D + C and deleting rows is Alt + H + D + R. Insert a new column with Alt + H + I + C or a new row using Alt + H + I + R. For data management, open the Text to Columns wizard with Alt + A + E, remove duplicates via Alt + A + M, sort A to Z using Alt + A + S + A, and group rows or columns with Alt + A + G + G. Additional tools include inserting a PivotTable with Alt + N + V, adding a chart via Alt + N + S + F, freezing or unfreezing panes using Alt + W + F + F, showing or hiding gridlines with Alt + W + V + G, splitting the worksheet window via Alt + W + S, auto-inserting SUM with Alt + =, and inserting a line break inside a cell using Alt + Enter. Convert a range into an Excel Table with Ctrl + T, turn filters on or off via Ctrl + Shift + L, and edit the active cell by pressing F2.

3w

Timofey@timofey

关注

Excel Keyboard Shortcuts Guide

Excel shortcuts for managing your data directly from the keyboard. Press Alt + H + O + I to auto-fit column width, which adjusts the size to fit the longest content and helps clean up large reports quickly. Use Alt + H + O + A to auto-fit row height instead. If you need text wrapping, hit Alt + H + W. Changing font color is as simple as Alt + H + F + C, while opening the Fill Color menu requires Alt + H + H. Apply all borders with Alt + H + B + A or remove them entirely using Alt + H + B + N. Merging and centering cells works via Alt + H + M + C, whereas unmerging uses Alt + H + M + U. Aligning text left, right, or centered follows Alt + H + A + L, Alt + H + A + R, and Alt + H + A + C respectively. Deleting selected columns takes Alt + H + D + C and deleting rows is Alt + H + D + R. Insert a new column with Alt + H + I + C or a new row using Alt + H + I + R. For data management, open the Text to Columns wizard with Alt + A + E, remove duplicates via Alt + A + M, sort A to Z using Alt + A + S + A, and group rows or columns with Alt + A + G + G. Additional tools include inserting a PivotTable with Alt + N + V, adding a chart via Alt + N + S + F, freezing or unfreezing panes using Alt + W + F + F, showing or hiding gridlines with Alt + W + V + G, splitting the worksheet window via Alt + W + S, auto-inserting SUM with Alt + =, and inserting a line break inside a cell using Alt + Enter. Convert a range into an Excel Table with Ctrl + T, turn filters on or off via Ctrl + Shift + L, and edit the active cell by pressing F2.

3w