Tag: Microsoft Excel

In this blog post, we’ll delve into a fundamental aspect of Excel usage—checking if a cell is blank or empty. Why Check for Blank Cells? Before we dive into the…

This post shows you how to visualize all formulas on an Excel sheet at once. To see all formulas on a worksheet, go to Formulas > Show Formulas or simply…

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…

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…

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.…

Note: The instructions are for python3.x on Ubuntu There are several different libraries you can use to easily work with Excel. I will be covering openpyxl. Other options include xlsxwriter,…

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…

The following steps show how to transpose data in excel. Transposition refers to switching between rows and columns. For example, if row 1, column1 is A, row 2, column 2…

Excel allows you to write a nested if statements. Following is a typical if statement: To write another condition inside the one returns true:

Sometimes Excel cells contain unwanted data. Removing this data can be a very tedious job. For example, I recently received a data file where the first column cells contained some…