How to Paste without Formatting in Excel (Shortcuts)
When you copy and paste text from one place to another in Excel, the formatting of that text is often copied along with it. This can be a pain when …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Press Enter and Stay in the Same Cell in Excel
By default, whenever you’re in a cell in Excel and hit the Enter/Return key, the cursor would go down one cell. In most cases, this is what you want (especially …
How to Add Calculated Field to Pivot Table?
Pivot tables in Excel provide a powerful tool to group and summarize large datasets, helping you get a bird’s eye view of your data. They come equipped with a variety …
How to Remove Drop-down List in Excel?
A drop-down list provides a great way to let your user choose from a list of options. It makes data entry quick and easy, which is why it is often …
How to Add Developer Tab in Excel?
If you’ve been following our Excel tutorials for a while, you would have come across a reference to the ‘Developer tab’ quite a lot of times. You might also have …
How to Add Bullet Points in Excel
You sometimes need to represent text data as bullet points in Excel. For example, you might need to display bulletin boards, to-do lists, etc. However, Excel was primarily designed for …
Circular References in Excel – How to Find and Fix it!
Circular references in Excel can be quite a source of annoyance. If you’ve come across this error, you’re not alone. Numerous Excel users face this problem every day, but the …
How to Compare Two Cells in Excel? (Exact/Partial Match)
When you have a lot of data in a spreadsheet it becomes quite difficult to compare the contents of two cells without just staring closely into the screen. Moreover, if …
How to Calculate Cumulative Percentage in Excel?
Imagine you bring home your test scores and you’re really happy with how you’ve scored…up until one of your parents asks you ‘what percentile is it?’ or ‘what’s the cumulative …
How to Delete/Remove Checkbox in Excel?
Checkboxes provide an easy way to get yes/no type inputs from the user quickly. However, you might struggle while trying to delete these checkboxes (especially when you got multiple checkboxes …
Get Unique Values from a Column in Excel
Unique values are those that appear on a list just once. When working with data in Excel, you will often come across datasets that have duplicates in the column and …
How to Merge Two Excel Files?
Accessing data from multiple Excel files can be time-consuming and hard. You often have to switch between multiple open windows, it’s messy and you feel like there’s data all over …