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 …
Steve Scott
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 …
How to Select Every Other Row (Alternate Row) in Excel?
Selecting every other row in Excel could be useful when you want to manipulate alternate rows in your data set. For example, you may want to highlight every other row, …
How to Get Total Days in Month in Excel?
Calculating the total number of days in a month in Excel is essential for tasks involving time, scheduling, or budgeting. For example, we might want to compute the total days …
How to Add Axis Titles in Excel?
When making charts in Microsoft Excel, we need to add titles to the horizontal and vertical axis so the reader can know what the axis represents. Excel is an excellent …
What Does F9 Do in Excel?
When using Excel, F9 is a function key that performs specific actions depending on the context in which it is used. This tutorial shows seven uses of F9 in Excel. …