Posts

Showing posts from November, 2015

Know More about AutoSum option in MS Excel

Image
Today, when I was working with MS Excel then I used the AutoSum option many times to make sum of the numbers. I have noticed one thing about this option which was very interesting. This option is available in two places, first in Home tab and second in Formulas tab. Check the images below:


AutoSum in Home Tab                                          AutoSum in Formulas Tab
Shortcut for AutoSum:

In MS Excel, every formula and function have its own shortcut. You can use ALT+ as the shortcut of AutoSum option. To test this option, write down the numbers in the excel sheet and press ALT+ to make its AutoSum. Now I am describing my experience with this function.

First I have created three columns named: Physics, Chemistry and English. Now I entered some numbers along with the columns.


Test of AutoSum Option
Vertically Up: Excel user may use‘=sum(number1,number2)’ formula or AutoSum option to sum-up the data. When I tried the AutoSum option in vertically up then it gives me the following resul…

Prevent Your Excel File by Automatic Creation of Hyperlinks

Image
A hyperlink is important but in few cases it becomes tedious. Automatic creation of hyperlink is like a speed breaker in the document creation process. It creates with the following prefixes:

http:// ftp://file:www.mailto:news:\\
Suppose, you are working with large the number of excel files and each file consists of thousands of hyperlinks then what will do? I think you will try to remove manually but here, we are talking about thousands of hyperlinks. In this case, try these options:

Apostrophe (‘) at the starting of the cell entry: To understand this option. Let’s take an example. Suppose you are trying to write www.google.com in the cell. When you write it then, it becomes hyperlink automatically. In this case, write an apostrophe (‘) at the beginning of the cell entry.
‘www.google.com 
It won’t become hyperlink. This is the first way to prevention of automatic hyperlink. The second option is more interesting which is given below:

Using autocorrect options: Simply follow these simple …