![]() 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. ![]()
0 Comments
Leave a Reply. |