Tag: Microsoft Excel

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…