+ Reply to Thread
Results 1 to 10 of 10

Excel table filter buttons printing

  1. #1
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    138

    Excel table filter buttons printing

    Hello. For a moment, all was fine. But, now the linked Excel worksheet object I have in a Word doc shows and prints the filter buttons. Anybody know best way to print Word doc without the buttons showing? Thanks!

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel table filter buttons printing

    In your button properties can you set the Print Object to False?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel table filter buttons printing

    Thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  4. #4
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    138
    Quote Originally Posted by xladept View Post
    Thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    It's been so long and I haven't needed to do this in a while. To be honest I don't know if it solved the problem or not. Sorry for the neglect with this thread. I'll have to check.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel table filter buttons printing

    Yeah, I lost track of it too.

  6. #6
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    138

    Re: Excel table filter buttons printing

    Ok. Went back to the issue. I don't know what Button Properties you're talking about. This is a typical table or pivot table that is printing to pdf or pasted as a picture in a doc. We're not talking about VBA userforms, etc.

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel table filter buttons printing

    Are they command buttons? - If so, they should have attendant properties

  8. #8
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    92

    Re: Excel table filter buttons printing

    Go to the Data tab and click once on the funnel. This should hide the dropdown buttons. If that doesn't work, see if you can clear them by clicking on the cliear button to the right of the funnel.

  9. #9
    Forum Contributor
    Join Date
    10-05-2017
    Location
    Altamonte Springs, FL
    MS-Off Ver
    Office 365
    Posts
    138
    Quote Originally Posted by XL&ME View Post
    Go to the Data tab and click once on the funnel. This should hide the dropdown buttons. If that doesn't work, see if you can clear them by clicking on the cliear button to the right of the funnel.
    The filter buttons for the tables are used often so I keep them. The problem is that when pasting a picture of the table into Word, the filter buttons are visible.

  10. #10
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    92

    Re: Excel table filter buttons printing

    Okay, try this. Use the Camera tool to copy and paste the table in Word. I had the filter buttons showing in Excel, but when I pasted the table into Word, the filter buttons did not show. If the filter buttons do show up, use the funnel to turn them off and it should turn them off in the picture copy of the table.

+ 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. Print Button that removes columns before printing from custom pivot table filter
    By TheWhiteJamal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2015, 11:14 AM
  2. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  3. Replies: 1
    Last Post: 02-07-2014, 03:04 AM
  4. Excel Table Print Filter Buttons
    By goss in forum Excel General
    Replies: 3
    Last Post: 01-02-2014, 02:07 AM
  5. [SOLVED] buttons for saving, printing and publishing in excel
    By andyb63uk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2011, 10:15 AM
  6. Adding Filter Buttons to a Pivot Table
    By bakes1 in forum Excel General
    Replies: 2
    Last Post: 04-09-2008, 04:24 PM
  7. [SOLVED] How do I stop VB buttons from moving in Excel after printing
    By etcrv in forum Excel General
    Replies: 1
    Last Post: 05-19-2005, 02:06 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