excel tips: expand all

excel is an incredible tool when you know how to use it properly, and a splitting headache when you don’t. when you’re working with large amounts of data, saving time using formulas (see our last post on excel formulas) and shortcuts is paramount.

one easy way to save time is the ‘expand all’ function which helps you quickly expand every cell to match the widest content.

here’s how to expand all cells in microsoft excel:

• click in the top left cell to highlight the entire page

• then double click in between any two columns

• watch as excel instantly widens each cell to match the width of the widest content