I am a newcomer to Microsoft excel therefore I have a little knowledge.

When I type something on a cell it will appear crossing all front cells.

How can I show that sentence in a single column?

If you are an expert in excel, please solve my problem.

I have an excel sheet including loans given to many customers. Repayments should be done daily for these loans. The interest rate is 5% per month (30 days). If loans have been given in previous dates, How to find the total interest payable up to a current date. Can you tell me a formula?

I receive excel sheets from many branches of a company. I want to make a schedule from those sheets. There are about hundred columns and thousand rows of data in a table. I want change that table by converting columns to rows. How can I do it in excel easily using an option?

Hi, If you are an expert in excel please help me on this.

I have an excel sheet including student detail in an institute. Those students are in different ages. I want to categorize student based on the age. If a student is under 15, it should be appeared in a specific column as “under 15”. If over 15 should be appeared as “over15”. Can you create a formula?

I have seen in some excel presentations when a particular word is clicked it goes to another sheet quickly. That means a link has been given to the word to go that sheet.

How can I give a link to another sheet in excel? Can anybody explain me?

I believe that you will understand my problem carefully. I have a Microsoft excel file comprises of about hundred of sheets. 

These sheets include many details. Sometimes I have to change same word which is everywhere in the excel file.

It is difficult to replace one by one.

How can I replace all those words to another word quickly?

Is there any easy way?

I prepare some accounting reports in Microsoft excel. I add header and footer to those excel sheet. I want to add a line under the header and above the footer. Can someone tell me how it can be done?

Thanks.

I have a Microsoft excel sheet which includes payment details to suppliers. I will show you some details as an example. Please see the image below.

I want to get month in to column D at every month end and the month cumulative total to column E. Can anyone tell me a formula?

I have a sheet of Microsoft excels in which I prepared a format to enter the details of the deal.

I came across with this problem when I am going to print some sheets in Microsoft excel file. There are several sheets in that file. But I want to print only few selected sheets. How can I do this?