Expand all hidden cells in Excel in just one click

As an analyst, a lot of the data I receive is  not mine to analyze.  They come from different sources. Sometime, because the width of the cells is too small, the data is not viewable.  Below is an example of the data set with some hidden values because the cell width is too small.

Instead of resizing the columns individually, you can click on the yellow top left corner of the Excel document to select the entire worksheet.  Then, hover your mouse between any two columns until you see a “T”. Once you do, double click. That would automatically expand the entire workbook in one single click.

Advertisements
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s