The custom number formatting feature in Excel changes the appearance of values in a cell without altering the original content. In this training, I will show you how to hide a cell content with value and still reference that cell in a formula – You will notice that even though the cell content is hidden, …
HOW TO HIDE CELL VALUES USING CUSTOM NUMBER FORMATTING Read More »
Inserting page numbers as a footer in an Excel file with more than one page makes it easy for the reader to know the order of the pages and the sequence for better understanding when reading through the document. Having a single-page document with a footer that reads “2 of 5” implies that the document …
HOW TO INSERT PAGE NUMBER FOOTER IN AN EXCEL FILE Read More »
Having a good knowledge of how the printing options in Excel work will help you print document better. To print multiple copies of a multiple-page document in Excel, you have two options to explore: First is the collated option that allows you to print the entire pages of the document in multiple copies. …
Imagine having a large database of employee details and you desire to search for an employee that starts with a particular First Name. You will either have to scroll through the large worksheet to get details of such employees or better still activate the Filter option in Excel. In this tutorial, I will share another …
HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT MATCH IN EXCEL Read More »
Do you know there is an Excel function that easily computes the square root of any number? First of all, let me explain what a square root means. By illustration, here is what a square root mean. 2 x 2 = 4 right, then the square root of 4 is 2 3 x 3 = …
