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.
More Formulas and Functions in Excel 97/2000/2002XP/2003/2007
What Is An IS Function?
Ever wondered how to use the IS functions
in Excel? This article explains how to use IS and IF functions.
IsError Function
The IsError function is one of the most useful
features of Excel. Find out how you can use this function to get rid of Excel's ugly error messages.
Excel Printing
Find out how to prepare your excel worksheet for printing and how to print large spreadsheets in Excel.
Merging Cells in Excel
See how to make your worksheets more "readable" by merging cells.
Excel 97/2000/2002XP/2003/2007 Full Tutorials
If you are interested in more advanced formulas and functionalities of Excel 97/2000/2002XP/2003/2007 Click on the link above
Suggested Reading
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
