MS Excel 2007 Pivot Table Question

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?
rwheeler23Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

First question: You can copy the data, then click in a new sheet in A1 and use Paste Special and tick the Transpose option.

Second question: Which options are these?

cheers, teylyn
0
 
rwheeler23Author Commented:
Data Options. It talks about somethng called Trust Center. Microsoft Office Security Center.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
That sounds like a completely different issue. I don't run 2007. Some aspects of 2007 are quite buggy. You may want to start a new question with a title that reflects the problem to draw experts who know about it.

cheers, teylyn
0
 
Rory ArchibaldCommented:
You need to click the Office button (top left) then Excel Options, then look at the Trust Center settings. Which ones depends on which specific messages you are getting.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.