Browse » Home
Thursday, January 17, 2013
How to Place a Tick in an Excel Spreadsheet
Symbol
1. Open your Excel workbook and navigate to the specific spreadsheet that needs to have a tick. The spreadsheets in the workbook are listed at the bottom of the window. Click the specific cell where you want the tick to be placed.
2. Navigate to the 'Insert' tab at the top of the screen, which is positioned to the left of the 'Page Layout' tab and to the right of the 'Home' tab. Click the 'Symbol' button in the 'Text' heading at the top-right side of the window.
3. Click the 'Font' drop-down menu and select the 'Wingdings' option. Scroll down to the bottom row of the available Wingdings symbols. Click the specific tick option you want to use and click 'Insert' to place the tick in your selected spreadsheet cell.
Check Box
4. Open the workbook you want to use and navigate to the appropriate sheet. Click the 'Developer' tab in the ribbon at the top of the screen. The 'Developer' tab is at the far right side, to the immediate right of the 'View' tab.
5. Click the 'Insert' button in the 'Controls' heading, which is located to the right of the 'Code' heading. Click the 'Check Box' option underneath the 'Form Control' sub-heading.
6. Click the location on your spreadsheet where you want the tick box to be placed. Click the edge of the box and drag it if you need to move it to a different location. Highlight the text in the box and press 'Backspace.' Type whatever text you need to appear next to the tick box.
7. Press 'Enter' to save the tick box. Click the box to add the tick, or click it again to remove the tick.