Not sure if you need this but here is my info: computer: custom build - Processor Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz, 2808 Mhz, 6 Core(s), 6 Logical Processor(s); Memory - 16GB DDR4-3000; Video - Radeon RX480 8GB; Storage - Intel 600p Series 1TB M.s-2280 SSD and 500GB SSD 2.5"; OS - MS Windows 10 Pro 64bit; MS Office 2016
I am updating my password spreadsheet and want to move it into the 21st century. I have been using this spreadsheet for years and want to update it and create a new one. My old sheet had 4 columns (SITE, LOGON, PASSWORD & WEB ADDRESS) with the top row in bold and centered with a box around it. Then I would enter my info onto a different row and go on from there. I tried to make a section for specific sites (for example: BILLS) and I would create a row with "BILLS" in the first column and then move to the new row and hit the spacebar 3 times to indent the site name (example: ABC Bank) then tab to next column enter LOGON info and so on. I would go to the next row on do the same until I entered all of the sites. I would then enter the next site normally. I did it this way all though out my sheet. I would have most sites justified to the left until I wanted to create a new section again like MEDICAL and then I would do the NAME and then go to next row and then hit the spacebar 3 times and repeat as needed. After I got done with entering/updating the info I tried to create bold line/boxes around the different sections and the boarder of the spreadsheet. I would do this by selecting an area and then use the "Format Cells > Border" to create the boarder/box/lines around the info. If I needed to add more rows, I would go to the row after where I wanted it inserted and right click and Insert and new row. As you can imagine, this messed up my format and I would have to go back in and try to fix it.
Here is what I am trying to do:
1. create a new spreadsheet
2. have the 4 columns
3. have a bold outline around the entire sheet
4. have the 1st row cells in Bold, Centered with a bold box around each cell
5. have each line in each row a slight dark line
6. be able to create a section for different groups of sites like: Bills, Medical, School classes. etc.
7. have the name of the section in its own row, with a bold box around the whole row, and the inside divider lines removed
8. have the site name indented 3 spaces for each site that is in each section
9. be able to insert a new site and have it format to what area/section it was inserted. Example: when it is inserted as a normal site it has the bold lines at the start & end of the row with the inside normal darkness. If inserted into a section, it would indent the site name and format as needed.
10. have the top row frozen and printed on each sheet printed (I think I have this)
Here is a screenshot of what I am trying to do(I HOPE)
<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I know that I am forgetting something, but chock it up to OLD but getting YOUNGER each day
Thanks,
Smitty
I am updating my password spreadsheet and want to move it into the 21st century. I have been using this spreadsheet for years and want to update it and create a new one. My old sheet had 4 columns (SITE, LOGON, PASSWORD & WEB ADDRESS) with the top row in bold and centered with a box around it. Then I would enter my info onto a different row and go on from there. I tried to make a section for specific sites (for example: BILLS) and I would create a row with "BILLS" in the first column and then move to the new row and hit the spacebar 3 times to indent the site name (example: ABC Bank) then tab to next column enter LOGON info and so on. I would go to the next row on do the same until I entered all of the sites. I would then enter the next site normally. I did it this way all though out my sheet. I would have most sites justified to the left until I wanted to create a new section again like MEDICAL and then I would do the NAME and then go to next row and then hit the spacebar 3 times and repeat as needed. After I got done with entering/updating the info I tried to create bold line/boxes around the different sections and the boarder of the spreadsheet. I would do this by selecting an area and then use the "Format Cells > Border" to create the boarder/box/lines around the info. If I needed to add more rows, I would go to the row after where I wanted it inserted and right click and Insert and new row. As you can imagine, this messed up my format and I would have to go back in and try to fix it.
Here is what I am trying to do:
1. create a new spreadsheet
2. have the 4 columns
3. have a bold outline around the entire sheet
4. have the 1st row cells in Bold, Centered with a bold box around each cell
5. have each line in each row a slight dark line
6. be able to create a section for different groups of sites like: Bills, Medical, School classes. etc.
7. have the name of the section in its own row, with a bold box around the whole row, and the inside divider lines removed
8. have the site name indented 3 spaces for each site that is in each section
9. be able to insert a new site and have it format to what area/section it was inserted. Example: when it is inserted as a normal site it has the bold lines at the start & end of the row with the inside normal darkness. If inserted into a section, it would indent the site name and format as needed.
10. have the top row frozen and printed on each sheet printed (I think I have this)
Here is a screenshot of what I am trying to do(I HOPE)
A | B | C | D | |
---|---|---|---|---|
1 | SITE | LOGON | PASSWORD | WEB ADDRESS |
2 | MrExcel.com | testname | 12345678 | www.mrexcel.com |
3 | home center | 1testname | 987654 | www.homecenter.test |
4 | BILLS | |||
5 | abc bank | 2testname | 345678 | www.abcbanl.test |
6 | water | 3testname | 876543 | |
7 | Dr. testname | 4testname | 456789 | |
8 | computer build | 5testname | 23232323 | |
9 | food store | 6testname | 876545676 | www.foodstore.test |
<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
I know that I am forgetting something, but chock it up to OLD but getting YOUNGER each day
Thanks,
Smitty