Google Drive has the ability to convert a file created in Microsoft Excel into a Google Sheets file. The process is simple and all you have to do is open the Excel file using Google Drive and then save it as a Google Sheets file. The advantage of this method is that you do not […]Read More
Tags : 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
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
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
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
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
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
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
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
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