How to Delete a Sheet in Excel Using VBA
Deleting worksheets in Excel is a fairly easy task. All you need to do is just right-click on the sheet’s name at the bottom of the Excel window and hit …
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 Select Every Other Cell in Excel (Or Every Nth Cell)
If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …
How to Convert Decimal to Fraction in Excel
Ever opened an Excel Sheet and felt completely put off by a sheet laden with decimal points? If you feel that way about decimals, you’re not alone. In fact, a …
Why does Excel Open on Startup (and How to Stop it)
If you are using MS Excel on a Windows 10 Operating system, you might have come across this problem of your computer automatically starting MS Excel at startup. This is …
How to Remove Apostrophe in Excel?
You might have come across Excel documents created by someone else that contains the apostrophe symbol in front of text, numbers, or dates. You might have also noticed this happening …
Excel Showing Formula Instead of Result (How to FIX!)
Sometimes, it may happen that your Excel workbook shows formulas instead of the result. Something as shown below: But there is no need to panic… All’s well! This is something …
How to Auto Format Formulas in Excel?
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 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 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 …