How to Remove Year from Date in Excel?
There are times when you may need to remove the year component from a date in Excel. For example, before you send the list of company employees’ birth dates to …
Steve Scott
How to Remove Blank Columns in Excel? (Formula + VBA)
Sometimes you may get an Excel dataset that has blank columns. In most cases, this is undesirable and you would want to delete them. While there is no dedicated feature …
How to Rename a Table in Excel?
In Microsoft Excel, whenever you create a new Table, by default Excel will name it Table1, Table2, and so on. This would work fine when you have one or two …
How to Sort by Length in Excel? (Formula)
When working with Microsoft Excel, you may often come across a situation where you need to sort data based on the length of characters in a cell. For instance, let’s …
How to Remove Borders in Excel?
You may have an Excel dataset that has borders that are no longer appealing, useful, or necessary. You may want to remove them. This tutorial shows you six easy ways …
How to Remove Watermark in Excel (Image and Text)?
Sometimes when you print or print preview an Excel file that you have received from maybe a colleague, you notice that it has a watermark. You may not want the …
How to Remove Question Marks from Text in Excel?
If you import data into Excel from other sources, the data may come in with unwanted characters such as question marks. You will need to clean the data by removing …
How to Convert Columns to Rows in Excel?
Sometimes, you may get data that needs to be transposed. For example, you may get a data set where the data is listed in columns, and you want it to …
How to Apply Formula to Entire Column in Excel?
Excel is essentially a calculation engine. Just like a calculator, it takes questions in the form of formulas, for example, =8+4, and returns answers. Formulas are essential to manipulating data …
How to Add a Percentage to a Number in Excel?
In Excel, we often came across a situation where we have to add a percentage to a number. This is often the case when we want to increase or decrease …
How to Round to Nearest 100 in Excel?
Sometimes in Excel, we want to convert the number to the nearest 100 instead of an exact value. Rounded-off numbers are often easier to read and comprehend. For instance, if …
How to Copy and Paste in Excel Without Changing the Format?
We format data in Excel to change its appearance to make it more readable and appealing. The process of formatting can be tedious and time-consuming. In the event we need …