View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Xane Xane is offline
external usenet poster
 
Posts: 1
Default Make Excel see columns as rows and rows as columns

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!