Tags : Excel

Tutorials

How to Change Units of Measurement in Microsoft Excel

By default, Microsoft Excel uses the units of measure used by the operating system. This means that if Windows is set to use centimeters, Excel will also use centimeters. This can of course be changed and you are free to choose to use any units of measurement that you want. Watch our video tutorial where […]Read More

Tutorials

How to Make a Drop Down List in Microsoft Excel

Drop-down lists are a convenient way to enter data, and that’s why we see them everywhere. Simply click on a field and a list of items will open for you to select. In Microsoft Excel, it is possible to create a drop down list and this is quite easy to do. Watch our video tutorial […]Read More

Tutorials

How to Find Duplicates in Excel Spreadsheet

If you want to find all the duplicates in one Microsoft Excel spreadsheet or only in certain rows or columns, this is easy to do. In this way, all cells that contain duplicates will receive special formatting, which you can configure yourself. Check out our video tutorial where we show you how to find duplicates […]Read More

Tutorials

How to Convert a Row to a Column in Microsoft Excel

If you created a spreadsheet in Microsoft Excel, adjusted the fields neatly, formatted the columns and entered the data, and then concluded that the spreadsheet would look better if the rows and columns were reversed, we have good news for you. You don’t have to delete the whole table and redo it because there is […]Read More

Tutorials

How to Leave a Comment in Microsoft Excel

Have you ever wanted to leave a comment in a cell in Microsoft Excel that explains what a function does or what that cell is for? The good news is that this is possible and very easy to do. It is possible to leave comments on an unlimited number of cells, and each comment will […]Read More

Tutorials

How to Merge Two Cells in Microsoft Excel

Data contained in multiple Microsoft Excel cells often need to be merged and displayed in a single cell. There are several ways to do this, but the best way is to use a function. Other methods may be a bit simpler, but with the function, you will have the most flexibility, so we suggest you […]Read More

Tutorials

How to Add Header and Footer in Microsoft Excel

Microsoft Excel has the option to add a Header and Footer to the document. This way you can add page numbers, date and time, plain text, and more. The best thing is that you can do this in just a few clicks, as well as set it to, for example, automatically add a page number […]Read More

Tutorials

How to Count Colored Cells in Microsoft Excel

Coloring cells with a specific color in Microsoft Excel can be a convenient way to highlight the data contained in those cells. This is most commonly used to highlight cells that contain data of the same type, such as zip codes, company names, or product prices. In Excel, it is possible to count all cells […]Read More

Tutorials

How to Remove Cell Formatting in Microsoft Excel

When you copy or import a spreadsheet into Microsoft Excel, all table cell formatting will also be copied. If you want to remove the formatting of an individual cell or an entire table, the good news is that this is possible in just a few clicks. Watch our video where we show you how to […]Read More