How to insert multiple rows in Excel
There are several methods one can use to insert multiple rows in Excel. But first, you need to know how to insert a single row in Excel. Option 1: To [...]
May 2019
How to add a column in Excel
There are several methods one can use to add a column in Excel. Below explain these methods. Option 1: To add a column in Excel: Find the column where you [...]
Tips about Excel Rows and Columns
In this guide, you’ll learn every tip you need to know about Excel rows and columns. including how to delete or insert new rows and columns, how to adjust column [...]
Petty cash book template excel
Just before you begin reading this guide, let me inform you that this Excel Petty Cashbook tutorial is an ultimate guide. This means that I’ll try my best to exhaust [...]
How to keep a cell constant in a formula (lock cells)
Here are some quick steps to lock cells using this formula: =C5*D5*E2. Say you want to lock cell E2 to remain constant as you copy the formula to adjacent cells. [...]
April 2019
How to lock cells in excel
To protect cells from being edited, you need to lock them so that anyone using your spreadsheet will not be able to edit the locked cells. Locking cells in Excel [...]
How to Apply Accounting Number Format in Excel
A quick Steps on how to apply accounting number format in Excel: Step #1: Highlight the cells you wish to formatStep #2: Go to Home→Number→AccountingBonus: Alternatively, just click the dollar [...]
How to use VLOOKUP wildcard in Excel (partial text match)
If you are reading this, I guess you already know how the VLOOKUP function works. This function is so sensitive that it can detect even trailing and leading spaces [...]
The three main VLOOKUP Limitations in Excel
VLOOKUP is one of the popular functions in Excel. It is very helpful to many Excel users who want to look and retrieve information from a table (or dataset). [...]
How to show cell formulas in Excel
How to show cell formulas in Excel is one of the frequently asked questions about formulas. As soon as you enter a formula in a cell, Excel shows the [...]