Excel Question (:

Submitted by TKDJamesPakTKD on Sun, 10/01/2010 - 7:29am
I have a spreadsheet of all of the items in my sdb that relate to my category (petpets). On there I have prices of all the prices I have bought it for so when I put it into portal it will be more convienent for me. However, when I made this list I have the items listed vertically and the prices going horizontally.. is there a way to switch this up and have the items listed on the top horizontally and the prices going down vertically..? or do I have to remake the whole thing? Also when I have the items listed is there a way to make the first values at 1 instead of having the names start at 1?
Forums: 
General Chat - NON NEOPETS RELATED
  • 8467 reads

I'm not finished yet, I'm going to separate them into different sheets but anyway here it is :: see the part in ornage? I want it all to shift down so the names aren't #1 .. thats all. and so the first set of numbers start as #1 ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 8:51am |

I dont think you can really do it that way, they are there for formula purposes. If you just dont want to see it you can go into view and uncheck headings. You wont see the a b c or the 1 2 3
perpette | Sun, 10/01/2010 - 9:49am |

ah okay, thanks (: sorry for the late reply was RSing XD ------------------------------- See my new screenie petpage? (: http://www.neopets.com/~TKDChampion www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
------------------------------- www.youtube.com/TKDJamesPakTKD Check out my Martial Arts samplers =)
TKDJamesPakTKD | Sun, 10/01/2010 - 10:13am |

Pages