Autofill Formulas For Excel 2000 to Excel 2003

Adding new data to a spreadsheet with formulas usually involves a lot of copying and pasting formulas into new cells. But did you know that in later versions of Excel you can make the formulas autofill when new data is entered? Here is how you can set it up.

1) Go to the "Tools" menu.
2) Select "Options" and then click on the "Edit" tab.
3) There is a check box for "Extend list formats and formulas". Make sure the box is checked.

Now when you add data to your Excel spreadsheet, you should find that formulas will autofill.