FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. AutoFit Column Width-changes the column width to hold the largest value in the column.

Detailed explanation-2: -To fit the columns to the text (or page margins if cells are empty), click [AutoFit] > select “AutoFit Contents.” To fit the table to the text, click [AutoFit] > select “AutoFit Window.” To keep Word from automatically adjusting your column size, click [AutoFit] > select “Fixed Column Width."

Detailed explanation-3: -Luckily, there is a shortcut you can use to automatically adjust column widths in Excel so that everything fits perfectly. To use the autofit column width shortcut, simply select the column(s) you want to adjust, then press Alt + O, C.