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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
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. …
How to COUNTIF Partial Match in Excel?
The COUNTIF function in Excel counts the number of cells within a range that meet the given condition. When we use COUNTIF with partial matching, it counts the number of …
How to Rotate Text in Excel?
Microsoft Excel offers various formatting options that enhance the overall look and structure of the spreadsheet. One of the formatting options available in Excel is text rotation. Using this option, …
What Does Control + R Do in Excel?
Control + R is a great shortcut that you can use in Microsoft Excel, and it allows you to copy the cell/range on the left of the selected cell and …
How to Calculate Variance in Excel?
Variance is a commonly used metric in statistics, and a lot of Excel users need to calculate it as a part of their work. Many people working with financial data …
Not Enough Memory to Complete This Action in Excel – How to Fix?
Sometimes when we carry out an operation in Excel, for example, running VBA and inserting columns, Excel stops working and returns a warning message indicating there isn’t enough memory to …