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