How to Remove Formulas in Excel (and keep the data)
Watch Video – How to Remove Formulas in Excel Sometimes you may want to remove formulas from the worksheets but keep the data. It is also recommended to remove formulas …
Excel VBA / Macros
How to Hide Columns Based on Cell Value in Excel
Excel provides features such as filters that let you hide rows based on cell values. However, if you want to hide columns based on cell values, there’s, unfortunately, no dedicated …
How to Flash an Excel Cell?
There are a variety of ways in Excel to let you highlight or draw attention to important information in your worksheet. You can use highlights, make the font bolder, change …
How to Save Selection in Excel as PDF?
Excel has some great features that make it really easy to export workbooks, worksheets, and even parts of a worksheet to a number of other formats. Some of these formats …
How to Sum Positive Numbers in Excel (Formula)
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
How to Count Negative Numbers in Excel (Formula)
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Remove Macros from Excel?
Macros provide a great way to automate repetitive tasks. In this way, they help get things done quickly, but there may be times when you want to remove macros from …
How to Convert Serial Numbers to Date in Excel
When you bring in data from other sources, it is not uncommon to get the dates in the form of serial numbers, like 42088. Moreover, Excel inherently stores dates in …
How to Add Text to the Beginning or End of all Cells in Excel
There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …
How to Reverse a Text String in Excel (Using Formula & VBA)
Reversing a string may not have many real-world applications, especially when working with spreadsheets. That is why you will not find any built-in function for this in Excel. But there …
How to Convert Radians to Degrees in Excel (Easy Formula)
When working with mathematical data, there might be instances where you need to work on angles. Excel has a number of built-in trigonometric functions that let you easily calculate the …
How to Paste into Filtered Column Skipping the Hidden Cells?
Copying and pasting are probably one of the most used actions in an Excel spreadsheet. But when it comes to filtered data, copy-pasting data is not always smooth. Ever tried …