Similar Posts

Video – How to Use Conditional Formatting?
This video will help you to understand how you may use conditional formatting to highlight row based on conditions. Subscribe us for more updates

Excel Cell Reference – 3 simple ways
What is Excel Cell Reference? Excel Cell references are the names of cells. A cell reference has a letter and a number. The letter comes from the column (A, B, C…) and the number comes…

Practice XLOOKUP Function Online in Excel
XLOOKUP can find a value that matches exactly or is the closest approximation. It can also look to the left, right, or both, which is an alternative to the VLOOKUP function

How to Count Color Cells in Excel- Step by Step Tutorial
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…

Few Simple Excel Tips – Excel Learner Should Know
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…

How to Print Row Header on Each Page in Excel – 3 Easy Ways
Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…