- 1). In the "Start" menu, locate "All Programs" and click on it to open the "All Programs" window. Once the "All Programs" window is open, a list of various installed programs will appear. Locate the "Excel" icon or title and left click on it to open the Excel program.
- 2). Once the Excel program is opened, a blank spreadsheet will appear in the window. Looking at the blank spreadsheet, locate the cell A1 in the left top corner of the spreadsheet. Click on the A1 cell and type the title of the attendance sheet or simply type the word "Attendance."
- 3). Skip down and over to cell B3 and click on it. Type the first date of the attendance schedule. For example: Jan 1 or 1/1. Click on cell C3 and type the next date. Continue the dates in order across row 3 in cells D3, E3 and so on until all of the dates for the attendance sheet are on the spreadsheet. If the number of days exceeds the printing space, go to the "File" menu and move the cursor to "Page setup." In the "Page setup" menu, select "Landscape." This will change the position of the page from vertical view to horizontal view.
- 4). Locate cell A4 on the spreadsheet and click on it. In cell A4, type the name of the student, worker or member. Click on cell A5 and type the next name. Continue clicking on the cells and typing the names in each cell located in the A column, starting with cell A6, A7, A8 and so on until all of the names for the attendance sheet are on the spreadsheet.
- 5). When the attendance sheet is complete, locate the "File" menu at the top left of the Excel program window. Click on "File" and move the cursor down to "Save." The "Save" window will then appear. Double click on the file folder in which the attendance spreadsheet is to be saved. On the bottom of the "Save" window type a name for the spreadsheet in the rectangle labeled "File." Click on the "OK" button on the bottom of the "Save" window. The attendance spreadsheet is now saved.
previous post
next post