+ Reply to Thread
Results 1 to 5 of 5

Subtotals - display left + and -

  1. 10-07-2008, 10:46 AM #1
    GlendaP
    GlendaP is offline
    Registered User
    Join Date
    10-07-2008
    Location
    Edmonton
    Posts
    3

    Subtotals - display left + and -

    I know there is some shortcut key that displays the + and - for expanding and contracting subtotals on the left side bar - so you don't have to use the new commands on the ribbon bar in 2007. Anyone know what that shortcut is?
    Thanks
    Last edited by GlendaP; 10-08-2008 at 05:08 PM.
    Reply With QuoteRegister To Reply
  2. 10-08-2008, 02:14 AM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day and welcome to the forum,

    I can not answer your question directly, but the following link may help

    How to Make Custom Keyboard Shortcuts


    This link has further information on keyboard shortcuts

    Excel 2007 Cheat Sheet

    Btw this forum site has a special spot of Excel 2007 users like you and me.


    http://www.excelforum.com/excel-2007-help/

    Hope that all hopes

    Cheers
    Last edited by ratcat; 10-08-2008 at 02:16 AM. Reason: Fix link
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it
    Reply With QuoteRegister To Reply
  3. 10-08-2008, 11:36 AM #3
    GlendaP
    GlendaP is offline
    Registered User
    Join Date
    10-07-2008
    Location
    Edmonton
    Posts
    3

    Shortcut to subtotal + and _

    Thanks - but none of that gave me the answer. I had found it on this site somewhere and then I forgot what it was.
    Reply With QuoteRegister To Reply
  4. 10-08-2008, 12:02 PM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    ALT+A+H to Show detail
    ALT+A+J to Hide detail
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  5. 10-08-2008, 05:04 PM #5
    GlendaP
    GlendaP is offline
    Registered User
    Join Date
    10-07-2008
    Location
    Edmonton
    Posts
    3

    Smile Show + and - on subtotals

    Thanks - also Ctrl 8 will diplay.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rows misplaced when using multiple Subtotals
    By erict in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-15-2008, 05:02 PM
  2. Insert Subtotals Command
    By nicolachen in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-21-2007, 02:26 PM
  3. Refresh Subtotal's Button
    By Lidos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2007, 04:31 PM
  4. Colour display
    By Mr Bean in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2007, 02:07 PM
  5. COUNTA Ignore cells to left
    By dborchardt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2006, 02:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1