Recent Posts

This website has been moved to new blog Please wait for 2 seconds to redirect to new blog

July 27, 2010

Exploration of Microsoft Excel

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...