How do I get the rows in excel to adjust automatically when new data is entered?

[jaganath]

When I enter in new data, I want excel to automatically autofit the rows. I know I can click autofit after all the data is entered, but I want it to autofit automatically everytime something new is entered in. Thanks.

[contaminated]

Hi
try this
Right click on your sheet and select View Code
Paste thios code into that window

Please Login or Register  to view this content.

[jaganath]

I actually got this code of another website and it seems to work well. But I only want it to adjust cells starting from Column D. How can I modify the code to accomplish my goal.

Please Login or Register  to view this content.

[martindwilson]

Please Login or Register  to view this content.