1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Is it possible to filter out certain type styles

Discussion in 'Archive: Business Applications' started by ~Candy~, Sep 10, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    I have a spreadsheet where I have some items in bold type.

    Is it possible to filter ONLY the bolded items into another spreadsheet page? Or am I wishful thinking? Or even PRINT only the bolded type from the current page?
     
  2. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    You could create a macro which will select only the bold cells and copy them to another sheet and print form there or just hide the cells that are not bolded

    Are the items bolded on some criteria that can be formulated as a condition for conditional formatting or are just bolded by user choice?
     
  3. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    Hi Aj, thanks for the reply.

    They are bolded by my criteria :D So, I guess that would be user choice.

    As to creating a macro :confused: or hiding the cells :confused: you can speak to me like a 3 year old with this. I can fix hardware and windows, but, when it comes to software, I'm clueless.
     
  4. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Ok!
    you wanna to select only the cells that are bolded or the whole row/column!

    BTW what Ms Office version do you use?
     
  5. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    I'm using Office 2007.

    I want to select only the cells that are bolded.

    What I have is a list of movies, it's 2 pages, 3 columns wide. The bolded movies are VHS. The others are DVD. Thus my reason for wanting to print a separate list.
     
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Just one question - are the cells bolded manually or by using conditional formatting?
     
  7. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    I bolded them manually, after typing the name of the movie I knew was in VHS format.
     
  8. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
  9. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    Did you see what the guy's reply was? :eek: :D That is my reply too..... :confused:
     
  10. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837

    Attached Files:

    • bold.xls
      File size:
      16.5 KB
      Views:
      650
  11. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    Thanks slurpee.

    Let me take a look and see if I can figure out Greek :D
     
  12. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    Ok, I'm still confused. I have absolutely no idea what to do, sorry :(

    I do appreciate both of you helping....or in my case TRYING to help :)
     
  13. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,270
    OK. First of all, go to your room.

    :D

    The code preceding the guy's reply actually did the opposite to what was requested. :rolleyes:

    So I stripped that code down, tweaked it, and put it in the attached.

    Download the attached. Copy your worksheet into the attached. Then run the code (shortcut is CTRL+Shift+M).

    (Sheet1 is a test sheet; when I run the code with Sheet1 active, all the A = Y & C = 3 rows are hidden, which seems to be where you want to get to prior to printing. HTH)
     

    Attached Files:

  14. ~Candy~

    ~Candy~ Retired Administrator Thread Starter

    Joined:
    Jan 27, 2001
    Messages:
    103,706
    Thanks. I'm locked in the kitchen now :eek: :D

    So, if I'm understanding this correctly, I open that sheet, then paste my info into a second sheet there, then run the CTRL-SHIFT-M?
     
  15. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,270
    I actually meant move your sheet (& create a copy of it) to the attached; but you can do your way if you prefer.

    Is this a one-off job? You can mail me the file if you like.
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/748728