+ Reply to Thread
Results 1 to 5 of 5

shortcut key for exploding a cell in pivot table

  1. #1
    Forum Contributor aganesan99's Avatar
    Join Date
    04-26-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    129

    shortcut key for exploding a cell in pivot table

    Hi,
    I have a pivot table. If I need to explode a cell, I need to double click on that cell to explode the data.

    I need to know the shortcut key for that.

    Can some one help me on this.

    Thanks,
    aganesan99

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: shortcut key for exploding a cell in pivot table

    don't think there is a short cut, other than using the key for RightMouseClick (if you keyboard has it) + e

    you could assign a macro to a keystroke combination of your choice

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor aganesan99's Avatar
    Join Date
    04-26-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: shortcut key for exploding a cell in pivot table

    Thanks Andy

    Regards,
    aganesan99

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: shortcut key for exploding a cell in pivot table

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Forum Contributor aganesan99's Avatar
    Join Date
    04-26-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: shortcut key for exploding a cell in pivot table

    Sorry Fotis.

    In future i'll surely follow it.

    Thanks
    aganesan99

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. is there any shortcut key for creating pivot table?
    By shilpa bvs in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-22-2015, 02:10 AM
  2. VBA shortcut to control Pivot Table
    By LB79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2011, 06:20 AM
  3. Replies: 0
    Last Post: 02-24-2006, 07:50 AM
  4. Macro menu item versus keyboard shortcut on pivot table
    By TrevorM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2006, 06:50 AM
  5. exploding a pivot table column into sheets?
    By Greg Loriman in forum Excel General
    Replies: 1
    Last Post: 12-22-2005, 08:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1