To use the expand all columns shortcut, simply select the range of cells that you want to expand, and then press the following keys: The expand all columns shortcut will expand all of the columns in the selected range, including hidden columns.

Expanding all columns can be done quickly and easily with these shortcuts. Double-click the right border of any column header to expand the column width to fit the contents. Plus, double-clicking anywhere between two columns will auto-fit them both. Pro tip: Save these shortcuts as custom hotkeys for quick access when you need them.

In order to expand the selection, you must select a cell in the same column as the group symbol (in this case, column E). 4. Press ‘ALT’, ‘A’, ‘J’. The grouped columns are now expanded.

If you’re using Windows: Press Alt + Shift + = to select all the groups. Then, simply press Alt + Shift + - to collapse them or Alt + Shift + + to expand them. For Mac users, the process is similar, but you’ll use the Option key instead of Alt. This shortcut is a game-changer when dealing with large, complex spreadsheets.