HomeMicrosoft OfficeMicrosoft ExcelExcel: Automatically Size Columns to Fit Data

Excel: Automatically Size Columns to Fit Data

Excel can automatically size a column or columns which you have selected, based on their longest entries. This gives you a quick and easy way to display your data in a worksheet.


To size a single column, use the following steps:

1. Position your mouse pointer on the right edge of the desired column in the column header.

2. The pointer will change to a double-headed arrow. When it does, double-click the mouse.

To size multiple columns, use the following steps:

1. Select the columns by dragging through them in the column header (or by holding down the Ctrl key and clicking the column letters).

2. Position your mouse pointer on the right edge of one of the selected columns.

3. The pointer will change to a double-headed arrow. When it does, double-click the mouse.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

7 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android