Hugo has attended:
Excel Intermediate course
Excel Advanced course
Excel Intermediate course
Copy nd paste options - short cuts
Hi,
I am looking for a way to copy data horizontal and paste it vertical for a report that I have to run each month, I am sure there is a quick shortcut to doing this?
Can anyone help? I have an example of the report that I have to run that I can send through - if there is a way to upload?
Thanks,
Hugo
RE: copy nd paste options - short cuts
Hi Hugo
You can send a file by typing the message and clicking Submit then clicking on the Upload option (and follow prompts)
To change horizontal data to vertical:
Copy the horizontal data
Select the report
Click the Home tab
Select Paste Options (arrow below Paste)
Choose the Transpose option
Shortcut key method
Ctrl+c to copy the data
In your report press Alt+h
Then press v followed t
Regards
Doug Dunn
Best STL
