Excel gridlines do not appear when you print a Microsoft Excel worksheet. This is a default setting in Excel that can be changed when you modify the display settings of your worksheets. But when you do this, Microsoft Excel will only show borders around cells containing actual data. Here we show you the different methods […]
How to print in Excel with lines Read More »
When working in Excel, there may be instances where you need to move, delete, or insert cells in a worksheet. When cells are moved, deleted, or changed in any way, the cells will move alongside the content within the cells. By default, Excel moves and copies all data that is within the cells when moving
How to move cells in Excel to the right (Easy Guide) Read More »
You can easily delete items in one cell using delete button. In addition, you can delete data adjacent other cells following same procedure. But what if you have a big worksheet and he data you wish to delete is all over? Worry not, in this article I will show you how to find and delete
How to find in Excel and delete: 3 easy methods Read More »
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 »
