Login  |  Register  |  Forgot Password 
Below Login Ad

Quick Links

Excel Tips


Owner : Vikas
295 Members
Created : 10-Jun-2011, 06:44:35


Create New Community
Communities I've Joined

Browse by Category

Accounts
Audit
Career
Corporate Law
Direct Tax
Exams
Finance
General
General Knowledge
GST
Income Tax
Income Tax Software
Students
Technologies
testing

Popular Communities

Excel Tips
ACCOUNTS GURU PARVEEN SHARMA SIR
CA World Of RAJPUT'S
VG Sir
TOOLS OF TAX PLANNING
Famous Quotes
TOP CA Firms
Delhi 6 CA's
CA STUDENTS
ICAI

Topic Title

Community : Excel Tips
Topic : Welcome

By : Vikas
  

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



By : Ca Sanjay Kumar
  

Mr. vikas

hello

yes i want to learn some tips & formula in excel

can u help?



By : Anjali Arora
  

Hello,

Please give some Tips of Excel.....



By : VIC
  

hello, sir

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

 



By : Anjali Arora
  

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



By : Rohit Gupta
  

Please give me some excel tips

 



By : Cavineet Sharma
  

Hey frnds Can you tell me about the Vlookupfunction

 



By : Anjali Arora
  

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



By : Ankit Singla
  

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



By : RK Birahi
  

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

 



By : Dhananjay Choudhary
  

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

 

 



By : Dhananjay Choudhary
  

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

 

 



By : Rohit Agarwal
  

till date, no tip has been updated



By : Vikas
  

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

 

 

 



By : Kshitij Nijhawan
  

Thanks for sharing


 
   

Reply to this Discussion

Sorry . You need to member of the community to post any message .
 
www.casansaar.com
...keeps you updated

Home

  |  News

  |  Articles

  |  Discussion

  |  CA Firms

 |  Members

 |  CA Community

 |  Jobs

 |  Empanelment

 |  Files

 |  Matrimonial

 |  Students zone

 |  Queries

 |  Classified Ads

 |  Events

 |  About us

 |   Top Members

 |  Coaching Centres

  | Testimonials

 | Judiciary

 | Videos

 | Notifications/Circulars

 | Book

 | eDirectory

 | Interview

 | Website

 | Emails

 | Software

 |  Score Board

 |   Press Release  

 |   Blood Bank  

  |   Opinion Poll  

  |   Feedback
 |   Advertise us

 |   Terms & Conditions

 |   Refund Policy

 |   Contact us
 |   Blog

  |   Sitemap

  |   Auditing

  |   Bank

  |   Bank branch audit

  |   Banking

  |   Black Money

  |   CA

  |   CA Announcement

  |   TDS

  |   Students Zone

  |   Custom

  |   VAT

  |   Service Tax

  |   Corporate Law

  |   General

  |   Excise

  |   SEBI

  |   Finance

  |   GST

  |   ICAI

  |   FEMA

  |   ICWAI

  |   ICSI

  |   DGFT

  |   RBI

  |   IFRS

  |   CAG

  |   Budget

  |   Merger & Acquisitions

  |   International Business

  |   Shares & Stock

  |   Excel Tips

  |   International Taxation

  |   ITR

  |   Chartered Accountant

  |   Tax Audit

  |   Companies Act

  |   Money Laundering

  |   MCA

  |   Income Tax Refund

  |   NPA

  |   Income tax software

  |   CST

  |   CA Exams

  |   CA Results

  |   CBDT

  |   Accounting Standards

  |   DIN

  |   Judical Announcement

  |   MDP

  |   PAN

  |   Whats App

  |   Secretarial Standards

  |   NGO

  |   CA Convocation

  |   Finance Bill

  |   ICAI Notification

  |   CARO

  |   COMPANIES SECRETARY

  |   Accounts

Follow Us : Twitter Icon Facebook Icon Orkut Icon Linkedin Icon Linkedin Icon
Developed By: CASANSAAR Copyright © casansaar

Top Accounting Firms,CA COMMUNITY,CA SANSAAR,Chartered Accountant,Ca Networking Firms,Partner Portal,Ca Assignments,CA,Online Communities For Chartered Accountant,Circle For Ca,CS,CMA and FINANCE,Articles By CA / CS / CMA,accounting news articles,Ca Firms In Delhi,CA ANNOUNCEMENT

accounting jobs,article trainees,best website creator,empanelment,income tax slab, ITR, TDS Chart,budget of india 2014-15,gst,auditing,Income tax,students zone,cpt,community matrimony for ca,Classified Ads,Community Matrimony For Ca,Students Zone,Coaching Classes,Company Secretary,Cost Accountant,Judiciary.