How To Insert A Watermark In Excel – A Complete Guide

Most often you might have come across documents which contain watermarks similar to Draft, Sample, Confidential and few brand logos etc. They are the ways to let people know the document status and few times just to put up your brand all over. Let’s look at how to do it for our documents too. You … Continue reading How To Insert A Watermark In Excel – A Complete Guide

How To Insert Page Number In Excel – A Quick Guide

There might be situations where you need to keep a note of the number of pages. Inserting page numbers in worksheets can help you with that. Let’s see, how to do that quickly… Various possible operations are 1. Insert page numbers on a single worksheet 2. Insert page numbers in multiple worksheets 3. How to … Continue reading How To Insert Page Number In Excel – A Quick Guide

How To Add Leading Zero In Excel

Most frustrating thing in excel is saving Account numbers, Phone numbers and ZIP codes, we end up losing the leading zeroes. Today Let us see how to avoid it What is leading zero? Where excel leading zeroes are used? How to use it with an example What is leading zero? A leading zero is any … Continue reading How To Add Leading Zero In Excel

How To Use Excel FRACTION

Let’s talk about “Fraction” in Excel What is a fraction? Where excel fraction is used? How to use it with an example Where excel fraction is used? It is a part of the whole number and is represented as numerator and denominator i.e.a/b Where excel fraction is used? In everyday life, it can be used in … Continue reading How To Use Excel FRACTION

How To Use AUTOCORRECT In Excel

How awesome will it be, if you get someone who understands you best? Excel has a command called “AutoCorrect” It can be your best partner, you just type two words and it will just display your choice. Helpful in both shorthand data entry and misspelled words… Excel has a few in-built terms which are wrongly … Continue reading How To Use AUTOCORRECT In Excel

Time saving friend Excel Quick Access Toolbar

Have you ever been too lazy to work on something and though of a genie , a magic that can help you work. May be in real life we might not find one, but excel has got you a feature called “Quick access toolbar Great isn’t!!! Lets explore it >> Right Click the Quick access … Continue reading Time saving friend Excel Quick Access Toolbar

Excel main window dissected

Though we have been using excel for quite a long time, we still might not be aware of a few basic elements that we ignore or just don’t explore. Let’s dig deeper into the details: ***Explained***  Title Bar: Displays the current workbook name along with few controls to modify the window. Menu Bar: It contains … Continue reading Excel main window dissected