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.

How to put a password on excel