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
