I have been using Excel to perform all my stock market record-keeping and stock-tracking activities. I use it to daily get the stock numbers using the external data functionality to know what my daily gains and losses have been. Lately I tried adding another functionality to it and during that I came across a need to use a function that helps create Hyperlinks to web pages. For this I used Hyperlink() function.

Auto fill is the ability of Excel to identify and fill a series of text or numbers, automatically, in a given range. For example, you want to fill down a row, a series of numbers from 1 to 10. There are 2 ways to do it:

One is that you type these numbers manually yourself. This method is fine, if in this case, as there are only 10 numbers to be manually-punched. But what if the series to be filled was 1 to 1,000? …or 10,000?

Match function is used to get the relative location of a text or value within a specified array.

Syntax:

= Match (Lookup_value, Lookup_array, Lookup_type)

Lookup_value: This value in the function specifies the value or the text (an item) that is to be looked up in the array (or a range of cells)

This post is in continuation to my previous post on Excel Keyboard Shortcut. This time I have chosen shortcuts for ‘Formatting’ commands.

• Activate the Formatting dialog box: The shortcut key for this command is CTRL+1. This command will activate the Formatting dialog box which can then be used for applying any kind of formatting to the selected cells.