Copy formatted horizontal cells to empty vertical cells
If I have formatted data inputted from the most top-left cell to the right (A1, A2, A3, A4, A5), how do I copy it to SHEET 2 but in a different direction, this time from top to bottom (A1, B1, C1, D1, E1). What I need is the formula itself.
When I try to copy-paste, it always ends up pasting on the copied direction.
Thanks for the help!
Last edited by mishxco; 06-07-2013 at 02:46 AM.
if i understanding the question properly
copy and paste special >>transpose
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
What do you mean by that?..What I need is the formula itself.
Did you tried?
Copy>>Paste Special>>Transpose>>ok.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Originally Posted by Fotis1991
The cells I want to copy is in vertical form, but I want to paste in a horizontal way. Is that possible?
When you click a cell, you can see a little box on the lower right, isn't that right? If I write << =Sheet1!F62 >> on the formula bar, when I drag the little box button to the right, I want it to continue on as F63, F64, etc... Not G62, H62, etc... But because of the direction of where I drag it, it always end up as G62, H62, etc...
=INDEX(Sheet1!$F$62:$F$100,1+(COLUMN(A1)-1))
Copy across.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks