Working in Excel can be stressful when you need to refer to several workbooks. You may need to find a way to automatically combine worksheets in one master workbook to make your work easier. Excel offers its users various ways to combine Excel files. You can use some of the in-built commands to make your […]
How to automatically combine Excel files Read More »
You are working on an Excel worksheet, then realize that you need additional rows above. Luckily, you can insert multiple rows using the excel built-in features. Multiple rows can be inserted using the same processes. Therefore, you are at the right place to learn how you can add multiple rows. Let’s get started. Procedure You
How to insert multiple rows in Excel above Read More »
When working with large complex worksheets in Excel, it is quite common to hide some rows. It helps you conceal information you may not need at that particular time. Or you may receive a spreadsheet that has some of the columns and rows hidden. With a simple mouse click, you can hide your rows. But
How to expand the hidden rows in Excel Read More »
Unlike text editing softwares such as Google Docs and Microsoft Word, Excel does not feature change case. For this reason, users rely on functions to change the case of their text string. Excel LOWER function is one of many text functions that you can use to change the case of a sentence string. What does
How to use Excel LOWER Function Read More »
When working on a large spreadsheet locating data becomes more difficult. Thus you need to use a function to speed things up. The search function is one of the functions used to locate and return values on Excel. In this article I will guide you on different ways that you can make use of the
How to use Excel Search Function Read More »
Copying formulas in Excel is one of the most common tasks that is easily done by a simple mouse click. Despite it being easy, there are specific cases that require a user to have special tricks to avoid changing a cell reference. For instance when you need to copy a cell containing a formula. Here
How to copy in Excel with formula Read More »
The name CONCATENATE means to combine or to join. The Excel CONCATENATE function combines or joins text located in different cells to one cell. Microsoft introduced the CONCAT function to replace CONCATENATE in 2016. However, CONCATENATE will remain active in later versions for compatibility issues. The best practice is to use the CONCAT function since
How to use CONCATENATE Function in Excel Read More »
When going through Excel worksheets, you may have come across worksheets that have a line drawn through data and end up wondering how it is done. That is strikethrough formatting. Although it is hardly used, it is a good method to visibly show that something is no longer relevant, it has been removed from your
How to strikethrough in Excel: (4 methods) Read More »
Microsoft Excel offers its users many built-in shortcuts that can easily be accessed using the keyboard. Despite all the marvels of Microsoft Excel, you may want to write your Keyboard shortcuts for specific commands that you constantly use. Unfortunately, Excel does not offer you a simple command where you can create your shortcuts. But, do
How to create a shortcut to a cell in Excel Read More »
Sometimes you may work with large worksheets containing very detailed information. Such worksheets may be hard to read, analyze or visualize therefore calling out the need to organize your worksheet. In Excel, this is possible as you can organize your data by combining subcategory data. You can group rows to enable one to easily understand
How to group rows in Excel under a heading (Easy Guide) Read More »
