Sometimes you may wish to keep a part of an Excel worksheet stick on top while you are working or scrolling through your worksheet. To do this, you will need to freeze the area so that it remains locked and constant when you are scrolling through your workbook. This is an easier task to achieve […]
How to keep one row in Excel on top Read More »
You can easily look up a value in a table using one criterion. Here you will apply the VLOOKUP formula. But at times, you may need to use more than one criterion. This may seem like a pretty hard thing to achieve in Excel but it is not the case. Excel offers several functions you
How to LOOKUP Value in Excel with Multiple Criteria – 6 Methods Read More »
Microsoft Excel is one of the most reliable spreadsheet programs when it comes to dealing with data. You can perform a lot of mathematical computations using the different functions in Excel. One of the functions Excel offers is the DATE function, where you can calculate the additions and differences between dates. You can minus or
How to minus dates in Excel-3 easy methods Read More »
When you round up a number, you remove the non-important values. In Excel, you can round your figures to the nearest tens, hundreds, or thousands when you do not need an exact figure. This is one of the useful skills any Excel user should know. Luckily, Microsoft Excel offers many functions that help handle the
How to round in Excel the nearest thousand Read More »
After working on Excel worksheets, you may need to print out your workbook. Printing comes with different editing features. You can specify custom margins, change margins, or even center your worksheet to be printed vertically or horizontally. Excel also offers users printing features that enable them to print workbooks in the middle of the page.
3 easy ways to print Excel in the middle of a page Read More »
Inserting location in Excel enables you to find a specific file when you want to use it. It is easier to trace and access your Excel file once you have inserted a location in it. You do not have to enter the location manually. It is easy to insert a location in Excel. Despite the
How to insert location in Excel (3 easy ways) Read More »
Sometimes, when working with Excel documents, you may need to keep a spreadsheet section visible as you scroll through the rest of the worksheet. It is especially handy when you are working with a large Excel worksheet. Keeping a row or column locked makes your work easier as you can view the contents of the
How to freeze panes in Excel top and side Read More »
Excel’s MID Function is categorized under Excel TEXT Functions. The MID Formula returns a specified value of characters from the middle of a given text string. The function requires three arguments which include: the n numbers of characters to return, text to extract from the original text string, and a start point. Generally, you can
How to FIND MID in Excel Read More »
Microsoft is a great program that allows users to store and analyze large and even small amounts of data for interpretation. Apart from using only numerical values in Excel, you can also have cells that contain text within your data. To understand your data better, you need to differentiate cells that contain numbers and those
How to count Excel cells with text (with examples) Read More »
The idea of copying and pasting is common in computers and other electronics like a mobile phones. Apart from using the case, individuals can use the CTRL key and then press C to copy. To paste, people also use the CTRL key, followed by V to paste. Those formulas also apply in Excel to copy-paste
How to paste in Excel as values (5 simple methods) Read More »
