How to Make a Time Sheet in Excel
- 1). Open Excel. Click the first cell on the grid, A1. Type the name of the person the time sheet will track. Highlight the text, which more than likely stretches across multiple cells. Click the "B" icon on the ribbon. Click the "A" icon with the red line under it and select a color to make the name stand out on the time sheet.
- 2). Click into the cell below the name. Type the time frame which the time sheet tracks, such as June 20 to 27, 2011, for a weekly time sheet.
- 3). Leave an empty line to divide the top from the main section of the time sheet and click into cell A4. Type the first part of the time to track. With the above example, type "Monday, June 20." Double-click the line separating the "A" and "B" columns in the header row to adjust the column width to fit the header size.
- 4). Press the "Tab" key. Type the next column header in B4, such as "Tuesday, June 21." Continue pressing "Tab" to move one column to the right each time. Add all categories to track as headers.
- 5). Highlight the headers, click the "B" icon and choose the same color for them as you did the time sheet owner's name.
- 6). Click the "File" tab. Click "Save As." Select a place to save the time sheet where it'll be easy to access frequently. Type a name for the time sheet template and click the "Save" button.
- 7). Close the time sheet or leave it open and enter the first set of data. If the data is for another time period, change the date at the top of the spreadsheet. Enter time in the cells under the correct headers. Resave the time sheet over the original to keep one single document or, for versioning and archiving purposes, type a new time sheet file name each time before clicking "Save."
Source...