DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Home tab
|
|
|
Home tab
|
|
|
Home tab
|
|
|
Home tab-Format
|
Detailed explanation-1: -Select a cell within the row(s) to be hidden. On the Home command tab, in the Cells group, click Format. From the Format menu, in the Visibility section, select Hide & Unhide ยป Hide Rows. The row is hidden.
Detailed explanation-2: -If you want to hide rows based on a formula, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > New Rule.
Detailed explanation-3: -On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.
Detailed explanation-4: -Click the Home tab in the Ribbon or press Ctrl + A (twice if necessary). In the Cells group, click Format. A drop-down menu appears. Click Visibility, select Hide & Unhide and then Unhide Rows.