DISCOVER
×

How to Make a Log Book in Excel

Updated February 21, 2017

The Excel spreadsheet format is ideal for creating log books. File size is almost unlimited, so there are no restraints on how much information you need to track. Use the first row as a header, and a column for each type of information you are tracking.

Open a new Excel file and place the cursor in the A1 cell, in the uppermost left corner of the spreadsheet.

Type the item you will be tracking, for instance, if you are logging names for registration, type "Name" in the A1 cell.

Cursor across to the left to the next cell, B1, and type another type of information you are tracking, such as date.

Continue across the top row, inserting the title of each piece if information you are tracking in the log.

Format the spreadsheet by adding colour or borders to make the information easier to see. Either click and drag the cursor over an area, or click on the letter at the top of the column to highlight the entire column. Next, click on the area of the "Borders and Shading" area of the formatting palette to see your options. (If you don't see the formatting palette on screen, click on "Toolbox" at the top of the Excel window.) One click on the colour palette, for example, applies that colour to the highlighted area.

Tip

Excel will automatically distinguish text, number and date format as you enter the information, and format them appropriately.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Bill Brown has been a freelance writer for more than 14 years. Focusing on trade journals covering construction and home topics, his work appears in online and print publications. Brown holds a Master of Arts in liberal arts from St. John's University and is currently based in Houston.