Shortcut for Selecting entire row or column

Best Short cut for selecting for an entire row or column in a go!!!!



Shortcut (for selecting row) : Shift + Space

Shortcut (for selecting column) : Ctrl + Space


If you guys fix your fingers on the same....the same can do wonders in saving time while making MIS for management.






Happy Reading!!!!!

Shortcut for aligning excel entire table in one go

This Shortcut will help you to align all the excel columns and rows to its maximum width or length at one Go.....


Shortcut : ALT + H + O + I

The same shortcut holds true for all office version........

first select the entire table!!! and then press the above short cut....the result would be something like this

Shortcut for sending Email from Outlook

Simplest and easiest way to send email from outlook without using Mouse!!!


Shortcut : CTRL + Enter

Happy Reading!!!

Shortcut to copy paste single value or Formula on number of visible cells at a time

Excellent shortcut to copy and paste a single value or formula to number of cells at a time


Dear all many a times its so happen that we need to copy any particular value or formula to paste it on an excel worksheet only on the visible cells at a time. But i guess we fail to do so because when we paste that value it by default also gets pasted on the hidden cells.

Shortcut: ALT :(Colon)

Well! No more worry for the same. The shortcut appended below will take care of the problem very simply!!!!!!

All we need to do is copy paste the value

Now say suppose we want to paste value A in the table having values greater than or equal to 100. for this we hide the cells having value less than 100

Using filter option we only select the cells having value greater than or equal to 100

we type in 100 in that option and what we get would look like this

Shortcut for Text to Column

Short Cut for Text to Column Wizard will help convert the text to number


Shortcut - ALT + A + E (any Version) there after checkbox delimit (by default the same is already check boxed) and press enter thrice

Many a times when we copy or download data from some data base in Excel we get something like this:

Here the number is stores as text which doesn't allow to use vlookup or search option on the same. To get rid of the same the above mentioned Shortcut can be used after selecting the entire column or row something like this:

Shortcut for Freeze Pane

Short cut for Freeze Pane

ALT+W+F+F (windows 2007)

The same shortcut to be used for removing the pane.



Catch: If some rows or columns are hidden and thereafter you want to add or remove pane the same result in shutting down the excel like - Excel Not Responding.....

Shortcut for filter in Excel

Short Cut for putting Filter on table header in Excel!!!! Simplified!!!

Alt+A+T

The same combination can be used for removing the same.......

Remember: if there is a break in between the table, then we need to select the entire table before using the combination to put filter on the entire table or else the filter will work only uptill the break.

Example: as illustrated

If we only select the header and use the combination the filter will work up till the break; in this case up till row no 7

Shortcut for replacing words

Short Cut for replacing words in excel, word and power point


Ctlr H

Find what: Put what you want to replace, even space can be replaced

Replace with: Type what you want in place of find what




Happy Learning!!!!

Short cut for Find / Search in Excel

Shortcut for Find or Search

Ctrl F / Shift F5




Happy Learning!!!

How to use Vlookup in Excel

VLOOKUP SIMPLIFIED!!!!

Basics: Vlookup (vertical lookup) and Hlookup (Horizontal lookup) is a function in excel which allows you to search / transfer data column wise and row wise respectively between two values / tables.
Since Vlookup is the most commonly used function in excel here in this post we will concentrate only on Vlookup.


 Lookup_value: The value we want to search
Table_array: table in which we want to search (rem the value we are looking for must be the first column of the table)
Col_index_num: its column no. from left to right starting from 1st column of the table_array
Range_lookup: defines if we want an exact match or an approximate match (we will discuss both)


Example: We have 10 students with their marks in value as well as percentage

Now in another table we want only marks for 6 pre-selected students. In this case we can easily use vlookup for extracting the data from the database / table_array