How to Make an Attendance Spreadsheet in Excel

Microsoft Excel is a great spreadsheet program that makes various tasks easier. Tasks such as balance sheets, invoices, time cards or attendance spreadsheets can be done in Excel in minutes. It can be done on a PC or laptop at home, the office or on the go. Whether it is for school, work or any organization, an attendance spreadsheet can be made in Microsoft Excel quite easily after learning just a few steps.

Difficulty: Easy

Instructions

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.

Tips & Warnings

• To adjust the font style, size or color of any word or words in a cell, right click on the cell and move the cursor down the menu to "Font." In the "Font" window, make the necessary changes to the font. Within the "Font" window on the bottom right is a "Preview" window that will show you the changes that were made. If the changes are correct, click "OK," and the words or words in the cell will be changed. To add a border to any section of the attendance spreadsheet, right click on the desired cell and move the cursor down the menu to "Format Cells." In the "Format Cells" window, click on the "Border" tab. In the "Border" window, select the desired border style and color and click "OK" to save the border.