How to Make a Log Book in Excel

Written by bill brown
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Log Book in Excel
Create a log in Excel. (number background image by kuhar from

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.

Skill level:


  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

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

  5. 5

    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.

Tips and warnings

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.