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
Watch video Auto Fit Row and Column | Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 18 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 445 once and liked it 16 people.