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 »
There are different ways Excel users can filter data when working with spreadsheets. One of the ways is greater than function. You can use different ways to filter in Excel greater than. Here, we discuss steps to follow when filtering in Excel greater than. Let’s get started. Filter in Excel greater than a number using
How to filter in Excel greater than Read More »
Excel is a spreadsheet program commonly used to store and organize data, while JPG is an image format commonly used for displaying digital photos and images. If you have a spreadsheet in Excel that you want to convert to an image format such as JPG, you can do so by using Microsoft Office or by
How to convert Excel to JPG: Step by Step Tutorial Read More »
