Browse » Home
Friday, December 14, 2012
How to Make a Log with Microsoft Excel 2003
How to Make a Log with Microsoft Excel 2003
1. Choose the column headings you wish to use and determine the number of columns you will need. If your log requires the headings 'Date,' 'Time,' 'Comment' and 'Initials,' you will need 4 columns.
2. Open Microsoft Excel 2003 and type your column headers in the first row. For this example, type 'Date' in Cell A1, 'Time' in Cell B1, 'Comment' in Cell C1 and 'Initials' in Cell D1. Highlight those 4 cells and choose the format and font you wish to use for the text.
3. Highlight columns A through D and right click somewhere on the highlighted cells. Select 'Format Cells' from the menu that pops up and activate the 'Borders' tab. Click the 'Outline' and 'Inside' buttons under the 'Presets' subhead. Click 'OK.'
4. Adjust the row height to meet your needs by clicking 'Format' on the menu bar, than 'Row' and then 'Height...' The default height is '12.75' which yields approximately 50 lines per page. This may be too small for some people's handwriting, so adjust this number to meet your needs and click 'OK.' It may take some experimenting to get it just how you want it. You may use this same method to re-adjust later.
5. Change to the page break view by clicking 'View' on the menu bar and then 'Page Break Preview.' Once there, only the first 1 or 2 rows will be active and there will be a blue border around them. Click and drag the bottom blue border downward until a page divider appears and 'Page 2' appears in the highlighted area below the divider. You may have to release the border and drag again to get this to appear. Click and drag the bottom blue border upward until it aligns with the divider.
6. Adjust the column widths to meet your needs by clicking and dragging the dividers between the column headers. For example, you can change Column A's width by clicking the divider between 'A' and 'B' and dragging it in one direction or the other. Adjust the columns as wide as necessary, but do not exceed one page in width for the whole table. You will know if you have exceeded 1 page if a dotted page divider appears with 'Page 2' on the right side of it.
7. Save the file. Print as many copies as you need. When you run out of copies, you can simply open the file and print out more.