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.
0 kommentar(er)
