Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Archive: Business Applications Archive: Business Applications
Search Search
Search for:
Tech Support Guy > > > >

Solved: Is it possible to filter out certain type styles


(!)

~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 01:35 PM #1
Solved: Is it possible to filter out certain type styles
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?
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
10-Sep-2008, 01:51 PM #2
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?
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 02:12 PM #3
Hi Aj, thanks for the reply.

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

As to creating a macro or hiding the cells 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.
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
10-Sep-2008, 02:16 PM #4
Ok!
you wanna to select only the cells that are bolded or the whole row/column!

BTW what Ms Office version do you use?
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 02:20 PM #5
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.
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-Sep-2008, 02:34 PM #6
Just one question - are the cells bolded manually or by using conditional formatting?
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 02:40 PM #7
I bolded them manually, after typing the name of the movie I knew was in VHS format.
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-Sep-2008, 02:41 PM #8
Here is a link that gives some VBA that will hide all non-bold items (was written for 2003, but should work for you too)
http://www.themssforum.com/ExcelMisc/Hide-only/
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 02:47 PM #9
Did you see what the guy's reply was? That is my reply too.....
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-Sep-2008, 03:26 PM #10
Okay, here is a somewhat simpler method, stolen flat out from here
http://support.microsoft.com/kb/151449
Attached Files
File Type: xls bold.xls (16.5 KB, 619 views)
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 03:44 PM #11
Thanks slurpee.

Let me take a look and see if I can figure out Greek
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 04:29 PM #12
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
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
10-Sep-2008, 07:41 PM #13
Quote:
Originally Posted by Candy
you can speak to me like a 3 year old with this.
OK. First of all, go to your room.



Quote:
Originally Posted by Candy
Did you see what the guy's reply was? That is my reply too.....
The code preceding the guy's reply actually did the opposite to what was requested.

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
File Type: xls candy.xls (23.5 KB, 589 views)
~Candy~'s Avatar
Retired Administrator with 103,708 posts.
THREAD STARTER
 
Join Date: Jan 2001
Experience: Advanced
10-Sep-2008, 08:11 PM #14
Thanks. I'm locked in the kitchen now

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?
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
10-Sep-2008, 08:25 PM #15
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.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑