When to use a check box. Use one or more check boxes when you want to: Enable users to make a true/false or yes/no choice. Display true/false or yes/no information that comes from a database, Web service, or other data source.
You can combine or merge text from two or more cells into one cell. For example, if you have one cell in your worksheet with a personâs first name and one cell with their last name, you can combine the first and last names in a new cell. Click the cell where you want to put the combined text. Type =(. Click the cell that contains the first text you want to combine, such as a personâs first name. Type &â â& (a space enclosed in quotation marks). Click the next cell with the text that you want to combine, such as the personâs last name.
If you need to merge cells that already contain data, then it is a good idea to copy and paste that data to other cells on the spreadsheet, then move the data back after you have merged the cells. Step 1: Open your spreadsheet in Excel 2013. Step 2: Click the Home tab at the top of the window. Step 3: Use your mouse to highlight the cells that you want to merge. Step 4: Click the arrow to the right of Merge & Center in the Alignment section of the ribbon at the top of the window, then select the Merge Cells option. Note that there are several other merge options as well, so you can select one of those instead if it is more appropriate.