Skip to Content
author's profile photo Former Member
Former Member

Drill Down In Excel like in web

Hi Friends

Can we have drill down facility in input scheule in Excel like wise in Web?

For Eg:

If i have 3 levels:

Initially Input schedule (Excel) need to display 1st level items next i click then need to drill down and final

base members will be in 3rd level.

I could do this in WEB.

Ex:

Other Income

Duty drawback benefit

Sale of scrap

Lease rentals

Miscellaneous income

Cost of Sales

Raw materials and components consumed

Traded goods

Stores and Packing materials consumed

Initially i need to display

Other Income

Cost of Sales

once i click other income need to drill down and display base members then i give input & save

Rgds

Srinath

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 08, 2011 at 03:53 AM

    Hi,

    In 7.5 you can do as follows :

    Workbook Options>Drill Down Options>select Expand by Inserting new rows.

    By double clicking on cell we can Expand or Collaps

    In 10 , Its auto no need to set any options. Just double click will do.

    Hope it helps...

    regards,

    Raju

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2011 at 01:30 AM

    Even In BPC 10 we have setting in Options:

    (Default may be selected, but we can uncheck also)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.