Excel Tips and Tricks

How to use Clipboard in Excel

How to use Clipboard in Excel

Copy and Paste is essential in daily computer use. If you copy and paste a lot, like most people, you can find yourself pasting the same information again and again. Excel’s Clipboard feature lists the items you've copied before and allow you to paste them whenever...

How to copy sheet in Excel with VBA

How to copy sheet in Excel with VBA

You can easily copy sheets in Excel manually with a few simple mouse clicks. On the other hand, you need a macro if you want to automate this process. In this guide, we're going to show you how to copy sheets in Excel with VBA. [button...

How to customize ribbon in Excel

How to customize ribbon in Excel

The ribbon is the name of Excel’s toolbar since Excel 2007. It displays commands as icons in a strip that are grouped into tabs based on their functions. It became customizable with Excel 2010. You can hide unnecessary tabs and commands, or add new ones easily. In...

How to sort birthdays in Excel

How to sort birthdays in Excel

Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won't work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to sort...

How to sort dates by month in Excel

How to sort dates by month in Excel

Sorting is a crucial part of organizing data. Being everyone's go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with sorting...