How to expand all columns in Excel

Expanding all Excel columns at once to see all data

This is a quick tutorial on how to see all data in your Excel columns.

When you first run a report and export to Excel, a lot of the time the data will be compressed or be shown as '#####', the example below is just the data compressed.expand excel 1

Click the arrow in the top left to highlight every row and column

expand excel 2

Then Double click the Line between 'A' and 'B' columns, this will expand all columns at once! Then you are all done!

excel expand 3