How to merge and unmerge cells in Excel
In this post, you will learn how to merge and unmerge cells in Excel. Select cells and then click on Home tab in the menu followed by Merge and Center…
How to concatenate cells in Excel
This post shows how to concatenate cells in Excel. concatenate() function concatenates cells=concatenate(A1,A2) Suppose we have the following data: The & operator can be used to concatenate cells. The following image show…
How to strikethrough text in Excel
This post shows how to strikethrough text in Excel. Select cells and press ctrl+shift+F simultaneously. You will see the format cells window. Click to check Strikethrough and click on OK. You should see the following:
Merging and unmerging cells in Excel
Steps to merge cells select desired cells click on Format and choose Cells. Format cells window should be open now click on the Alignment tab check Merge cells under Text control click on OK Steps to unmerge cells select desired cells…
Nested if statement in Excel
Excel allows you to write a nested if statements. Following is a typical if statement: To write another condition inside the one returns true: