Browse » Home
Wednesday, January 19, 2011
How to Make a Checklist on Excel
1. Open Microsoft Excel. Click into the first cell in the second column, B1. Type the first item for the checklist, such as 'Bread' or a task such as 'Clean windows.'
2. Double-click the small line separating the 'B' and 'C' columns. The 'B' column will spread out to the width of the text in the B1 cell.
3. Press the 'Enter' key on the keyboard to move into the cell below, B2. Type the next checklist item.
4. Continue pressing 'Enter' and entering tasks until they are all listed. Resize the 'B' column as necessary.
5. Click into the first cell, A1. Click the 'Insert' tab at the top of the screen. Click the 'Symbol' button on the right side of the ribbon below the tab.
6. Pull down the 'Font' menu and select 'Wingdings,' included with all Excel installations. Double-click the check box icon, in the very bottom right corner. Note the box is added to the cell. Click the 'Close' button.
7. Click once on cell A1 to highlight it. Press the 'Ctrl' and 'C' keys on the keyboard.
8. Click cell A2, hold down the left mouse button and drag vertically until all cells in column 'A' that have a checklist item next to them in column 'B' are highlighted.
9. Press the 'Ctrl' and 'V' keys, which pastes a copy of the check box into all of the cells.
10. Click the 'File' tab. Click 'Save As.' Type a name for the checklist spreadsheet and click the 'Save' button.