Hi, I am using excel 2016 version currently. I want to copy my horizontal data in sheet 1 to vertical data in sheet 2. When I use formula sheet1!A$27 it does not fixed my column and vary my row. Instead, when I drag, it will become sheet1!A$27 again instead of sheet1!B$27. How should I fix that?
Bookmarks