Many people don’t know that you can quickly resize columns in Excel with just a click of the mouse to accommodate the largest cell entry. Just position your mouse pointer over the right border of the column header and double-click.
This trick also works with multiple columns. Select the columns you wish to resize and double-click the column header right boarder of any of the selected columns. All of the selected columns will expand to accommodate the widest cell entry.
Similar Posts:
- Adjusting Column Width in a Word 2007 Table
- Insert Rows and Columns in a Word 2007 Table
- Naming a Range in Excel
- Creating a Table in Excel
- Moving Cells in Excel
- Formatting a Table in Excel 2007
- Modifying Column Layout in Word 2007
{ 1 comment… read it below or add one }
Thanks for the tip, was not aware that this can be done on multiple columns. This has really saved a lot of time for me.