Make Excel see columns as rows and rows as columns

  • Thread starter Thread starter Xane
  • Start date Start date
X

Xane

Okay, I have a bit of a difficult problem. I'm using excel to make a map for
a game I'm playing. I've already converted the columns to numbers as well,
however the game's mapping system is inverted from Excel's, meaning that for
example 13,100 doesn't get you to row 13 and column 100, but to column 13 and
row 100.

Can I switch this around somehow in Excel?
Can I make Excel take columns before rows, so 13,100 will actually mean
column 13, row 100?

Thanks!
 
How are you addressing the cells? In a formula, in VBA code? If a formula,
give us an example.
 
Let me try to clarify the problem:

The map I'm working with has a coordinate system that is inversely set up
compared to excel's, meaning that every length coordinate on the map is a
width coordinate in Excel and vice versa.

What I'm trying to do, is take the coordinates of the game map and use them
to fabricate my own map in excel. I'm not trying to calculate anything or use
any formulas. I just want to use all the cells of the map to simulate all the
spaces on the map and enter a name or some text and a colour.

However, since the coordinate system of the game has the X and Y axis
switched, my map would come out tilted 90 degrees if I were to make this map
with the coordinates I take from the game (top would be left, left would be
bottom, etc), which of course is not very practical. I could tell everyone to
print the map, but that would be a huge puzzle and simply undoable, not to
mention that it'll need to be updated constantly.



In short... I just need to somehow rotate my worksheet 90 degrees
counterclockwise...
 
Back
Top