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)
