How to AutoFit in Microsoft Excel

Configurare noua (How To)

Situatie

Solutie

Pasi de urmat

To increase or decrease the size of specific rows or columns, use this method.

First, launch your spreadsheet with Microsoft Excel. Then select the column or rows you’d like to autofit. You can make multiple selections by pressing and holding down the Ctrl (Windows) or Command (Mac) key.

After selecting your rows or columns, in Excel’s ribbon at the top, click the “Home” tab.

On the “Home” tab, in the “Cells” section, click the “Format” option.

In the “Format” menu, if you’d like to autofit your columns, then choose the “AutoFit Column Width” option. To autofit your rows, then choose “AutoFit Row Height.”

Excel will increase or decrease your rows or columns’ sizes to ensure the full content is visible.

Tip solutie

Workaround

Voteaza

(10 din 17 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?