How to put a number below a letter in Excel

How to put a number below a letter in Excel

Subscripts are numbers or texts that sit below the line of a text. Excel allows users to add subscripts in their dataset like any other Microsoft application. This article will guide you on ways of adding subscripts in Excel. Using the Format Cell Tool Format Cells is an in-built tool used to modify values and

How to add space above and below text in Excel

How to add space above and below text in Excel

One of the mighty ways of making Excel's texts and other values more visible is by adding space above and below the text. There's no direct way of adding space above and below in Excel, so many Excel users are unaware of this feature. Thankfully, this article will guide you on how to add spaces

How to delete blank rows at the Bottom in Excel

How to delete blank rows at the Bottom in Excel

Excel is made up of numerous empty columns and rows. Sometimes, your dataset may not fill in all the rows of your worksheet, and thus you may need to eliminate the empty bottom rows. Delete blank rows at the bottom of your dataset improves the visibility of the sheet, as only the active cells are

How to locate the cell that contains the MAX

How to locate the cell that contains the MAX

MAX is the largest value in your dataset. Sometimes, you may need to check which is the largest value or mark in your dataset. This may involve the cell's address with the maximum value or the value itself. Several in-built functions can be used to check the cell with the maximum value. Let us now

How to Fill Down Blank Cells Until the Next Value in Excel – 3 Easy Ways

How to Fill Down Blank Cells Until the Next Value in Excel - 3 Easy Ways

Once in a while, you might come across a data set in excel with blank spaces and filled spaces. This is a common challenge for Excel users. This tutorial will show you how to fix such a problem quickly. Method 1- Fill Blank Cells with Go To Special + Formula 1. Select the Blank Cells

How to make three cells into one in Excel

How to make three cells into one in Excel

Excel allows users to combine two or more cells. This feature allows users to combine cells horizontally, thus creating one large cell or combining the data in these cells into one. You can combine cells with data or without data. In the case of combining cells with data, you can use various excel formulas to

How to Find the Last Used Cell in Excel

How to Find the Last Used Cell in Excel

You can find the last used cell in Excel, which contains data or formatting on a worksheet. There are various ways you can do this, depending on the cell you want to locate. How to locate the last used cell which contains data or formatting on a worksheet Use the following steps; 1. Click anywhere