Become an Author for this blog just by a Click

A Tool in MS Excel

Written By Vignesh on Sunday, June 5, 2011 | 1:21 PM

Hello Readers,
I 've got Some interesting Information about Microsoft Excel. I hope in most of the PC's, almost Everybody would have worked in Microsoft Excel. but there are many information which people might not know about Excel. There are lots and lots of information about Excel and people may not be aware of it.

Excel has its own features which the other softwares don't have. You can do what ever you want in Excel using Formulas. There are many formulas with which even many MNCs Exists. All their datas are being calculated, recorded and maintained in Excel.
One of the powerful software is Excel.

Here iam going to ask you a question and check whether you can answer for that question. Put your best Efforts and find the answer. If you can't Get the answer you need not check anywhere. Iam giving you the answer also, but not here!!! some where below the question. Now immediately don't Scroll down and see the answer.

Your Question is here:
In Excel you might have come across the words "CELL", "ROW", "COLUMN" etc. As many of you know that there were 65000 rows and 256 Columns in Microsoft Excel2003.
As Shown Below:

In Microsoft Excel 2007 we have many rows and columns than that of 03. The total no. of Rows are 1048576 and total no. of columns are 16384.

The Question is:
The total no. of rows are easily visible and its directly shown in Excel workbook.

In the similar Lines how to view the no. Of Rows in Numbers. Usually it displays only in Alphabets only. like A,B,C,.... UPTO XFD. Its difficult to Count each and every Row. So to know how many Rows are there we need a numerical display alike Columns. How to change these Alphabets to Numbers?

Lets See how to Bring Nos. instead of Alphabets. Its very Simple but many people may not know.

Go to Excel options by clicking the Office Button.

You will see an inner window showing Excel options.
In that click on the formulas tab which is situated towards left in that window.
In that formulas tab You will find an option called R1C1reference Style. (shown below)

It will not be enabled by default. now tick that R1C1 Reference Style and you are done.

After Doing this your Excel Sheet will be as shown below.

Learn many more like this in my next article...


bogalur teachers said... Best Blogger Tips

Hai i really didn't know .very useful article

Post a Comment

Please Leave your Comments, suggestions, Queries Related to this article Below.

From the Author's Desk

Vignesh, the founder of VikiInfos, is a Commerce Graduate and Pursuing his Chartered Accountant Profession, now in the Intermediate level. Blogging is his hobby and likes to share things. He plans to Update this blog with latest happenings and things that he gets to know at times and worthy information.a friendly user blog can be followed by any person. Join us free and subscribe.
Feel free to say hi to me, or follow @vikiinfos on twitter.

Support US to support YOU!
Dono How To Donate? Click here
Creative Commons License
Healthy Infos... by Vignesh is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License.
Based on a work at
Twitter Bird Gadget