+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Autofilterand subtotal

Hybrid View

Jerseynjphillypa Autofilterand subtotal 06-21-2012, 01:38 PM
DBY Re: Autofilterand subtotal 06-21-2012, 01:56 PM
Jerseynjphillypa Re: Autofilterand subtotal 06-21-2012, 02:10 PM
  1. #1
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Autofilterand subtotal

    Hello
    It's a known bug in Excel that it does this. If you add a formula ="" in the blank cell under your item list and keep blanks unchecked it should be okay. The formula is just a reminder that something is there, you could just enter a space with the space bar.

    Hope this helps.
    DBY

  2. #2
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Autofilterand subtotal

    thanks for your help DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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