Welcome to all members, who wants learn excel. Please join this community to lear the excel fomulas & tips.

Mr. vikas

hello

yes i want to learn some tips & formula in excel

can u help?

Hello,

Please give some Tips of Excel.....

hello, sir

please give us excel tips to create expertise,,,,,,,i will be greatly thanksful to u,,,,

Hello Friends, lets start ourself some Tips of Excel to share with other Members....

Please give me some excel tips

Hey frnds Can you tell me about the Vlookupfunction

can some body give the tips on excel....

@vineet: vlookup function is difficult to explain over here...u can contact me at 9873446258. i l explain u its procedure and its usage....

Oho !!!!! no tips till date ???????

Dear Mr. Vikas,

I wanted to know that when we use subtotal function in excel, we get three sheets viz:-grand total in sheet one with no details, subtotal details in sheet - 2, and all data with subtotal in sheet- 3.

Now, I want that how can I copy only sheet - 2 to any other sheets without copying any hidden rows / column.

Awaiting for your reply.

Regards,

Dhananjay

Dear Mr. Vikas,

I wanted to know that when we use subtotal function in excel, we get three sheets viz:-grand total in sheet one with no details, subtotal details in sheet - 2, and all data with subtotal in sheet- 3.

Now, I want that how can I copy only sheet - 2 to any other sheets without copying any hidden rows / column.

Awaiting for your reply.

Regards,

Dhananjay

till date, no tip has been updated

TIPS -

1) If in Excel U have some datas in Row and u want to copy the same data and to paste in column wise it is possible in Excel

Here is the Steps,

1. Select the data which u want to paste in Column wise

2. Place the cusor where u want to paste

3. Left click the mouse in that select the PASTE SPECIAL

4. In that put tick mark in TRANSPOSE

5. Click ok

The same steps for doing Viceversa

Thanks for sharing