Navigation

Innovation & Improvement


Instructions For Using EXCEL Files

Illinois State Board of Education
System of Support Division, N-242
100 North First Street
Springfield, Illinois 62777-0001
  1. Once the file is open in Excel, immediately save it to your hard drive or disk. If you have trouble opening the file, do the following:
    • Hover over the link and click the right button on your mouse.
    • At the pop window, choose Save Target As or Save As.
    • Type file name (if not provided) and save to your hard drive.
    • Open the file from your hard drive with your Excel application.

  2. Each page of the printed application appears (in order) on a separate worksheet in Microsoft Excel. To move from one worksheet to another, click the tabs at the bottom of the screen labeled "Page 1," "Page 2," etc.

  3. In most cases you will enter information in the cells of the spreadsheets and calculations will be done for you. When working with cells, the tab and/or arrow keys can be used to move from cell to cell.

  4. In some cases you will need to enter information in a text box. Click with the mouse to select the text box. Then click to position the cursor within the text box. Enter your response. (Tab and arrow keys can not be used to move from text box to text box. You will need to use your mouse.)

  5. Each worksheet has been protected to prevent the inadvertent deletion of formulas. You may need to unprotect the worksheet to add or delete rows, adjust margins, change the font size, etc. To do this, select "Protection" and then "Unprotect Sheet" from the "Tools" menu. A password has not been used. Once the sheet is unprotected, cell formulas are no longer protected.

For assistance in using the Excel files or completing the forms, contact the System of Support Division at 217/524-4832.