Auto Fit Row and Column | Excel Tips and Tricks

Published: 18 October 2022
on channel: Rabi Gurung
445
16

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.