From the info tab select “protect workbook”. To add a password to the excel file open the file menu. So, let’s secure our password keeper by putting a password on the excel file. Now, how secure would a password file be if it anyone could find and open it? Not very. Now our entire password spreadsheet fits on one page. So, select “fit sheet on one page” from the scaling button. The password log is still too big so it’s carrying over to page 2. Go to file and select print to see the print preview.įrom the preview it looks like our password sheet is too wide for one piece of paper so let’s change the orientation to landscape so it prints on the long side of the paper. So let’s modify the page setup so we can print the password list if we want to. Though I don’t recommend printing and keeping your password book anywhere some people prefer to do it this way.And, since we have the entire worksheet highlighted, every column in the worksheet will automatically adjust to fit the data in each column. This will automatically change the width of column A to fit the data (or text in our case) in column A. When the cursor changes to a line with a left and right arrow coming out of it, double click. Then, once the entire sheet is selected (grayed out), move your cursor over top of the line between the column A and B headers. Highlight the entire worksheet by clicking in the gray rectangle in the upper left corner. Next let’s make some of the columns a little wider so the words are visible.Below is an example with some data entered:įrom the filter dropdown you can search for an item, sort the table or select certain item(s) using the checkboxes. Once you add data you can use these dropdowns to find your data quicker. You’ll notice that there are dropdowns arrows next to each column name. Simply click on any one of the cells in row 1, then, go to the Editing section under the Home tab, click Sort and Filter and select Filter. Excel makes adding filters extremely easy.

Now let’s make finding an account a little easier by adding filters to the headers.So, since only row 1 is above the cursor (and no columns are to the left of it) row 1 will stay at the top of the spreadsheet even if you scroll down to row 300. This will force all rows above and all columns to the left of the current cell to stay fixed as you navigate around the spreadsheet.

Then, under the View menu, click Freeze Panes. To do this, select cell A2 by clicking in it. Next, let’s “fix” our header row at the top of the screen so if we end up creating hundreds of rows (you’d be surprised how many passwords you’ll need to keep) the header row is always at the top and visible.Highlight row 1 by clicking on the gray 1 to the left of that row and click on the bold icon. We want the header row to be more prominent so make the text in row 1 bold.Create the following column headers by typing the words below into the cells indicated:.Now that we know what we want included, how do we create our password keeper in excel? If you’re new to Excel it may be helpful to read through this quick Excel 101 tutorial before you begin. Need a custom excel spreadsheet for your home or business? I can build one for you. Comments – just an extra section for any comments or notes you want to remember.Account # – sometimes there is also an account number you want to remember.Security Questions – did you have to answer security questions, if so, what answers did you give.Username – if there is a username associated with this account.Email – if you have multiple email addresses, which email did you use with this account.

Category – is this for work, online banking, shopping, a hobby, etc.

Account Name – what is this password for?.

My password log has the following information for each entry: The obvious answer is passwords! But, there’s more information that may also be relevant and important to keep together. Key Components of a Password Log Bookįirst let’s talk about what’s important in a password book. Note: This post may contain affiliate links.

Microsoft word login and password book