MS Excel 2007 Pivot Table Question
Posted on 2011-03-20
As I spend most of my time buried in databases I rarely use Excel. I have two questions.
I have an Excel spreadhseet containing four rows of data but each row consists of about 85 columns. I would like to switch the rows to the columns and the columns to the rows. Is there a basic tutorial on how to do this?
Also, every time I open this spreadsheet it keeps telling me certain options have been disabled and I then click on the Options button to enable them. After saving the spreadsheet and reopening it asks the same damn fool question again. How do I stop that?