How to Delete Multiple Rows in Excel?
One of the most common tasks that many Excel users do on a daily basis is to delete multiple rows of data. While deleting one single row is quite straightforward, …
Can’t Insert a Row in Excel – How to Fix!
As we work with Excel, we may need to insert a row in a dataset for several reasons. For example, we can insert a row to accommodate new data, improve …
Data Types in Excel
In Excel, there are five basic data types. These are Number, Date and Time, Text, Logical (boolean), and Error. As an Excel user, knowing the different data types is important …
How to Get Sheet Names in Excel?
You may want to get the worksheet’s name while working with Excel. For example, when creating a report that includes multiple worksheets, you may have the sheet name as a …
How to Add Leading Zeros in Excel?
We usually need to enter zeros before phone numbers, zip codes, product codes, and account numbers. Even if we enter leading zeros when we type in Excel, all leading zeros …
How to Remove Add-Ins from Excel?
Microsoft Excel already has some amazing features and functionalities that come in-built with it. To add to it, you can also add some add-ins that can further enhance the functionality …
How to Generate Random Names in Excel
When creating sample data, you may be required to generate random names. You will find that this is a fairly routine task. In this tutorial, I will show you how …
Excel Fill Series Not Working
The Excel Fill Series feature allows you to automatically fill in data in the cells, based on the value or patterns in other cells. This is a useful feature that …
How to Select Multiple Items from a Drop Down in Excel?
A drop-down list in Excel is a data validation tool that allows users to select values from a predefined list of options. The default behavior of a drop-down list in …
How to Swap Columns in Excel?
As we use Excel, we may need to swap columns or exchange the position of two or more columns. For example, you may want to bring together two columns to …
How to Count Filtered Rows in Excel?
We sometimes need to know how many rows have been filtered after applying the filters. Counting the number of filtered rows is slightly different, as we only want to count …
Calculate Days Left in the Year (Formula)
Have you ever found yourself wondering just how many days are left in the year? Whether you’re anxiously counting the days until your next vacation or frantically trying to meet …