Excel Tips and Tricks - Auto Fit Row and Column

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 spreadsheet)
3) Double-click any vertical grey line of the cell
4) Double-click any horizontal grey line on the cell

excel autofit row height shortcut,excel autofit row height not working,excel autofit row height cuts off text,excel autofit row height with padding,excel autofit row height not working merged cells,excel autofit row height merged cells,excel autofit column width shortcut,excel autofit row height extra space,How do you AutoFit cell size to contents?,

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