Auto Fit Row and Column in Excel

Auto Fit Row and Column

Step 1: Right click on the sheet name you want to auto fit row and column.

Step 2: Click on 'View code'.

Step 3: Click on '(General)' dropdown menu.

Step 4: Click on 'Worksheet'.

Step 5: Write 'Cells.EntireColumn.AutoFit' there and close the view code window (Microsoft Visual Basic window).

Now you can input any data inside that sheet and your row and column will be auto fit.