How can I convert a column into a row? In my research project, I am facing this problem. If data are given into columns, I mostly need to convert it into rows. How can it be done?

Good evening,

I have to prepare a table of accounting states. It contains about 40,000 records. And it takes more then 300 pages. But the problem is I have to set the row headings for every page manually. It is a burden for me.

How do you set it automatically? Is there any macro available for this?

Thanks

John Bryant

When I was working in my MS-Excel 2007, I got a regular error message relating to Privacy warning. What is the this? It's very irritating to me. I tried to solve this in many ways. But, It is not possible for me. You can see in my picture.

Microsoft Office Excel

Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed by the Document Inspector.

OK Cancel

I have a big problem here with Microsoft Excel.  

As I was doing my work, my laptop suddenly shut down and I lost all the work.

What should I do now?

Please help.

I can't do that again from the start.

Anyone can help.

I have a MS Excel sheet and my project is to create a MS Excel tools where consumers can enter a certain quantity of multiple different products at given rates. That's very simple for me, just a few multiplication formulas.

But what I want to happen is that the final price be displayed on Sheet 2. Can anyone help me?

How can I calculate in MS Excel where the answer will be displayed on another sheet?

I have a Microsoft Excel document by using Office 2003. This document content is very important for me because its data is very sensitive. If any person can change it will create many problems but other persons need to use this document data.

Now I want to use password protection for this data only. Nobody can change any data without password.
 

What is the process to protect my data?

You would like to restrict the values that can be entered into a cell so that only whole number between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?

I am using a Microsoft Excel document by using office 2003.

Here, I have three fields (Name, Total Number, Result).

Now I want to use a formula in result field which can be displayed that 40% out of 1000 will Pass and below 40% will Fail.

What can I do to solve this problem?

Suppose if a workbook is places in the XLSTART folder, then the same workbook will open each time Excel is launched. Is the mentioned statement true or false?

Dear all,

I am using MS Office 2007 and computer Operating system Windows 7.

I cannot find a way to link a PDF file within Excel 2007 in a specific cell.

How can I this problem?

Can anyone please advise me how I can solve this problem?

Need your kind assistance.

With best regards.