Precedent? What is this in Excel? Yesterday , one of our reader ask me how to highlight cells referred in formula? There is popular method is select cell with formula & on the Formulas tab, in the Formula Auditing group, click Trace Precedents. It will show tracer arrow to each cell that directly provides data […]

## Writing Basic VBA code

We have learned to record macro before this article. If you missed it check it here How to Record Excel Macro? Learn some VBA Macro Now, we will see how to write small macros without recording in module. How to add module to write code? So first open Excel sheet. Press “Alt + 11” to […]

## Download Excel Shortcut PDF & become Rockstar

Excel Shortcut PDF Yes, you read it right. Download Excel Shortcut PDF which will make you a Rockstar in Excel. In this pdf file, you will find very useful excel shortcuts in graphical forms. So easy to use & easy to remember. What more? You can even take print & paste on your desk too. […]

## Text histogram using Rept Function

Rept Function (Excel Formula) Before some day, I have the seen use of Rept function. Generally this function repeats a text string for any number of times. For Example =REPT(“Fun”,3) It will give output “FunFunFun”. I was thinking that this formula we can’t use in our daily use.But I was wrong. I get the idea […]

## 10 Jobs Everyone will love to do it!

## Remove User Name from All Comments in Excel Sheet

Utkarsh needs to make KPI dashboard on every month. A lot of times he needs to add comments in Excel to explain some reference, some explanation etc. But every time he adds comment(s), he needs to remove his name from the comment box. As you all of know, by default comment box add username in the […]

## Truths of Roman Reigns which you don’t know

Leati Joseph Anoa’i is birth name of Roman Reigns. He is Samoan-American wrestler & joined WWE as member of The Shield. Reign is a Catholic. He uses the sign of the cross every time he enters in the ring. He was a co-founder of The Shield with Seth Rollins and Dean Ambrose.Roman Reign […]

## Too Many Worksheets Hidden? Unhide all worksheets with simple VBA code

I have seen many complex excel files with lot of sheets & these sheets are related to each other by formula or reference.My favorite thing for complex file is doing research on that file. How it is made? What formulas are used? Is there any reference hidden? So first I unhide all worksheets. If they […]