Highlight Cell If Value Exists in Another Column in Excel
One of the best things about Microsoft Excel is that it can be customized to suit your needs and preferences. Excel has Conditional Formatting that allows you to format a …
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 Find Range in Excel (Formulas)
We usually require certain metrics to understand the data that we are working with. There are a number of such representative metrics, like the average, the median, etc. Among these …
How to Add a Total Row in Excel Table
Excel provides some really great features in the form of Tables. Excel tables provide an organized way of viewing and reporting data in a tabular format. Besides other advantages, Excel …
How to Select Multiple Rows in Excel?
One of the advantages of using spreadsheet software like Excel is that you get to perform operations in bulk. Instead of working on one cell or one row at a …
How to Apply Accounting Number Format in Excel
Excel spreadsheets are used for a number of applications, but its most common application is in areas of business and accounting. It only makes sense then for Excel to have …
How to Start Excel in Safe Mode?
If you’re facing problems running an Excel file or if you find your Excel application repeatedly crashing, it might help to open Excel in Safe mode. Microsoft Excel has an …
How to Find out What Version of Excel You Have?
Every version of Excel brings with it new features while making some older features obsolete. As such, we often need to know exactly which version of Excel we are using, …
How to Square a Number in Excel?
Thanks to spreadsheet software like Excel, it has become easier than ever to find squares of thousands of numbers at a time, even if some of them are quite large. …
How to Hide Rows based on Cell Value in Excel?
Working with large datasets that contain rows after rows of data can be quite painful. In such cases, looking for data that match particular criteria can be like looking for …
How to Remove Read-Only From Excel (Fix)
When trying to save changes to an Excel sheet you might find that you are unable to do so, because the file is ‘read-only’. At other times you might see …
3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)
Working with spreadsheets often involves a lot of repetitive tasks. A common way that spreadsheet users save time and energy is by making copies of spreadsheets already created and using …
How to Undo in Excel?
To err is human. Every Excel spreadsheet user at some point makes a mistake and needs to undo a change made. Now, life does not give you a second chance, …