Steve Scott, Author at Spreadsheet Planet

Excel Showing Formula Instead of Result

Have you ever been working on an Excel spreadsheet, only to find that the formula you entered isn’t showing the result you expected? Sometimes, Excel shows the formula instead of …

When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …

How to Print Multiple Tabs/Sheets in Excel

Excel has the option to print the active sheet, any selection on the active sheets as well as the entire workbook. But what if you want to print multiple sheets …

How to Unhide All Rows in Excel with VBA

If you’re in the habit of hiding rows in Excel, you may also sometimes, have a need to unhide all rows in a worksheet in Excel. In this tutorial, I …

Using Application.EnableEvents in VBA in Excel (Examples)

Application.EnableEvents is a property in Excel VBA where you can specify whether you want events to take place when the VBA code is running or not. An event is usually …

How to Clear Contents in Excel without Deleting Formulas

Excel allows you to clear content in the worksheets selectively. So, you can clear the contents in all the cells except the ones that have formulas. This can be useful …

How to Delete a Comment in Excel (or Delete ALL Comments)

Comments in Excel are great when you’re working with multiple people and need to tag a few cells with some important notes. And with comments, you can have multiple people …

How to Unsort in Excel (Revert Back to Original Data)

Data sorting is one of the most common tasks people do in Excel. But what if you want to un-sort in Excel – i.e., is to revert back to the …

How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …

How to Set a Row to Print on Every Page in Excel

If you often print your work in Excel, you would benefit from knowing how to make sure a row (or multiple rows) print on every page that you print. This …