Auto Fit Row and Column | Excel Tips and Tricks

Auto Fit Row and Column | Excel Tips and Tricks

How to auto fit the row and column is one of the tricks of Microsoft Excel that you must know.

METHOD 1:
Auto-Fit Row And Colum – Using pulldown menu
1) Place cursor in table
2) Ctrl + A
3) Home — Cells — Format — AutoFit Row Height
4) Home — Cells — Format — AutoFit Column Width

METHOD 2:
Auto-Fit Row And Colum – Using short-cut
1) Place cursor anywhere in the spreadsheet
2) Ctrl + A (select the whole spreeadsheet)
3) Double-click any vertical grey line of the cell
4) Double-click any horizontal grey line on the cell

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Close Menu