How to Freeze the Top Row and First Column in Excel?
We often work with very large datasets in Excel. One issue many users face is that when you scroll too far down or too far to the right, the first …
Steve Scott
How to Round Time to the Nearest Quarter Hour in Excel?
Time tracking is useful when trying to improve efficiency in your projects (or even your personal life). If you work with time datasets in Excel, it would be useful to …
How to Remove First Character in Excel?
Excel is an excellent choice for storing and managing small databases efficiently. However, sometimes in order to clean Excel raw data and extract some meaningful information from a data set, …
How to Translate in Excel
You’ve got text in Excel that you need in another language, but you’ve been copying every translation by hand. This used to be a pain, especially when you had a …
Subscript Out of Range Error in VBA – How to Fix!
Sometimes when we write and attempt to run sub-procedures in Excel VBA, Excel VBA returns a message box with the error message “Runtime error 9: Subscript out of range.” The …
How to Copy Column Widths in Excel?
Microsoft Excel is an excellent choice for creating a small database for storing information such as employee records, test scores, or even small inventory items. In some scenarios, we want …
Pivot Table Field Name is Not Valid – How to Fix?
A Pivot Table is an interactive table that can summarize vast amounts of numeric data enabling us to analyze data in finer detail. Therefore it can be frustrating when you …
Row vs Column in Excel – What’s the Difference?
Many people beginning to work with Excel wonder what the difference is between Excel rows and columns. This tutorial will highlight the differences between Excel rows and columns. Difference #1: …
How to Delete Defined Name in Excel? (Name Manager + VBA)
We define and use names in Excel formulas to easily understand, reference, and maintain data. For example, we can define a name for a table, a cell range, a constant, …
How to Remove the Last Digit in Excel?
When cleaning data in Excel, you will often come across situations where you need to remove the last digit from the data. If you only have a few data entries …
How to Fix #NUM! Error in Excel?
We are all visited by the unwelcome #NUM! error in our Excel worksheets from time to time. What’s annoying about the #NUM! error in Excel is that the error message does …
How to Convert Date to Serial Number in Excel?
Most Excel users work with dates on a daily basis. Working with dates can be a bit challenging as the same date can be formatted differently. However, in the back …