![]() 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.ĩ. 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.Ĩ. 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.ħ. 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.Ħ. 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.ĥ. 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.Ĥ. 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.ģ. To expand the width of a column to fit its contents, simply double-click on the right-hand border of the column header.Ģ. That's why we've put together this list of 15 essential Excel shortcuts for expanding and collapsing 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |