Excel shortcuts

15 essential Excel shortcuts for expanding columns

If you work with data in Microsoft Excel, you know how important it is to be able to quickly and easily expand or collapse columns. After all, data sets can often be very large, and scrolling back and forth between different parts of the sheet can be time-consuming and frustrating. That's why we've put together this list of 15 essential Excel shortcuts for expanding and collapsing columns.

1. To expand the width of a column to fit its contents, simply double-click on the right-hand border of the column header.

2. To collapse a column, so that it's width is reduced to the minimum necessary to fit its contents, simply double-click on the left-hand border of the column header.

3. To quickly expand or collapse all columns on a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any column header.

4. To expand or collapse all columns to a specific width, select all columns (Ctrl+A), then double-click on the right-hand border of the column header and enter the desired width.

5. To quickly expand or collapse all rows on a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the bottom border of any row header.

6. To expand or collapse all rows to a specific height, select all rows (Ctrl+A), then double-click on the bottom border of the row header and enter the desired height.

7. To expand or collapse all cells in a selection, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell.

8. To quickly expand or collapse all cells in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell and enter the desired width and height.

9. To expand or collapse all cells in a sheet to a specific size, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell and enter the desired width and height.

10. To quickly expand or collapse all rows and columns in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell.

11. To expand or collapse all rows and columns in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell and enter the desired width and height.

12. To quickly expand or collapse all cells in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell, then press the Enter key.

13. To expand or collapse all cells in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell, then press the Enter key and enter the desired width and height.

14. To quickly expand or collapse all rows and columns in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell, then press the Enter key.

15. To expand or collapse all rows and columns in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell, then press the Enter key and enter the desired width and height.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.