Sunday 16 April 2017

Shortcut for Switching Windows Front & Back

________________________________________________________________________________________
________________________________________________________________________________________

The only Shortcut for switching windows front and back side in any Microsoft version!!



For Front Switching: Alt + Tab (after pressing ALT keep pressing TAB again and again to switch windows

For Back Switching: Alt + Shift + Tab (after pressing Alt + Shift keep pressing Tab again and again to switch windows back side)

Remember: Shift is the key for reverse working in Microsoft.





Happy Reading!!!!

Friday 24 June 2016

How to copy paste Vertical values horizontally in Excel and vice versa

________________________________________________________________________________________
________________________________________________________________________________________
Shortcut Excel copy paste values horizontal to vertical and vice versa!!!

Many a times while preparing MIS in Excel we need to copy / /cut paste the values or text from horizontal to vertical or we might also say from rows to column or vice versa.


Here is the best shortcut for the same using paste special function with checking checkbox transpose. In Excel language transpose is used as log game to copy paste values from one dimension to another, but please make sure that copy and paste area doesn't overlap otherwise the function wont work!!

Example: Say suppose we want to convert this table from vertical to horizontal format or we might say from columns to rows



Now, here we need to select the entire table and copy the same ,thereafter need to select/ click on a cell where we want to transpose the values / text  which should not be overlapping to already selected cells.Use value paste function Shortcut: ALT + E + S and the window that opens looks something like this and checkbox values and transpose, Shortcut: V + E (Rem no Alt this time as we are already in Alt function)


Thursday 23 June 2016

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