How to Save Selection in Excel as PDF (3 Easy Methods)
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 …
Excel VBA / Macros
How to Sum Positive Numbers in Excel – Easy 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 – Easy 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? 3 Simple Methods
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 Move a Chart to a New Sheet in Excel
Charts are a great way to get a visual representation of your data. Excel provides a host of options to create and customize charts. It usually displays your created chart …
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 in a 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 …
How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)
A neat looking worksheet is always better than a shabby and unorganized one. You can tell if a sheet has been handled repeatedly by different people by just one look …
How to Delete Filtered Rows in Excel (with and without VBA)
Excel provides a wide range of functionality, a lot of which most users are not even aware of. One of its most fascinating features is the versatility of its Filters. …