+ Reply to Thread
Results 1 to 3 of 3

Table displaying less information

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    Wink Table displaying less information

    Hello,

    please check the table in the attachment.

    I only want the top row / filters (A1 - H1) to be displayed on Table 1 but keep the functionality of it.
    Is it somehow possible to hide all the information below A1-H1 or put it on another table and let Table 1 refer to it?

    The table is mostly in German but it shouldn't matter.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Table displaying less information

    Two suggestions:
    1) If you are using Excel 2010 or later
    ...Use Slicers to effect the filtering.
    ...You can put the slicer(s) on another sheet and hide the sheet containing the table

    or
    2) Set the row height of all table data rows to some miniscule value (example: 0.1)

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    Re: Table displaying less information

    Thanks Ron, I succeeded by using pivot tables in the first place...didn't need the slicers.

+ 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. Displaying information from 2 directories
    By Harshinee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 10:02 AM
  2. Replies: 2
    Last Post: 07-24-2012, 10:21 AM
  3. Displaying last cell w/ information
    By BrechBohne in forum Excel General
    Replies: 1
    Last Post: 10-03-2009, 11:10 AM
  4. Removing and displaying information from a string.
    By Spitfire999 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2008, 01:01 AM
  5. [SOLVED] Displaying summary information in a workbook
    By Le Tubs in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 12:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1