If you routinely have data that fills up a cell and then some, Excel offers a quick and easy way to see it all.
As you may know, you can easily place your cursor on the line to the right of the column header you’d like to adjust, click and drag to your desired width.
This may be all you need if the data that is visible on the screen is all you have, but what about the data that is down on row #2437? It could be wider still!
My quick and easy way is just a variation of the “click and drag” method and adjusts the column width of all the data in that column. Instead of clicking and dragging the column which you want to adjust, simply double-click the same line. (Just as we adjusted the Row Height yesterday, we can also adjust multiple columns at the same time. Just follow the same instructions of selecting multiple rows, but apply it to columns instead)
As you can see, the column adjusted itself to the width of the largest cell in that column; in this case “September”
Keep Excelling!
No comments:
Post a Comment