History of Earth (Space)

  Inserting a   checkbox in Excel   is easy. For example, use checkboxes to create a checklist or a dynamic chart. You can also insert a   check mark   symbol. Insert a Checkbox To  insert a checkbox , execute the following steps. 1. On the Developer tab, in the Controls group, click Insert. 2. Click Check Box in the Form Controls section. 3. For example, draw a checkbox in cell B2. 4. To remove "Check Box 1", right click the checkbox, click the text and delete it. Link a Checkbox To link a checkbox to a cell, execute the following steps. 1. Right click the checkbox and click Format Control. 2. Link the checkbox to cell C2. 3. Test the checkbox. 4. Hide column C. 5. For example, enter a simple IF function. 6. Uncheck the checkbox. Note: read on for some cool examples. Create a Checklist To create a checklist, execute the following steps. 1. Draw a checkbox in cell B2. 2. Click on the lower right corner of cell B2 and drag it down to cell...

The tutorial shows how to border cells in Excel by using the predefined options and how to create your custom cell border style. Sometimes Excel worksheets can be difficult to read because of dense information and complex structure. Adding border around cells can help you distinguish different sections, emphasize certain data, such as column headings or total rows, and make your worksheets better presentable and more attractive. What are cell borders in Excel? Border is a line around a cell or a block of cells in Excel. Generally, cell borders are used to accent a specific section of a spreadsheet to make it stand out. For example, you can insert a border to draw attention of viewers to totals or other important data on the sheet. Please do not confuse cell borders with worksheet gridlines. Borders are ticker and more prominent. Unlike gridlines, cell borders do not appear in a worksheet by default, you need to apply them manually. When printing out a document, the borders will app...