How to hide and unhide columns in excel
In some cases, you may want to hide certain columns in Excel. This is particularly useful if you don’t want your spreadsheet users to see particular information or if you [...]
May 2019
How to hide and unhide rows in excel
In some cases, you may want to hide certain rows in Excel. This is particularly useful if you don’t want your spreadsheet users to see certain information or if you [...]
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 [...]
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 [...]