Reveal formatting

Actually, it's just the opposite. A1 and C1 are bolded, B1 is not. I was trying to achieve the same effect as in B1 by bolding those two. Try unbolding them to see how different they are.

I don't see the white fill you mentioned, but turning on the white fill doesn't seem to make a difference to the visual aspects.

Okay, I see now where the white pattern is selected. But, as you can see, yourself, unbolded Arial 8 with white pattern in A1 is not the same as unbolded Arial 8 with white pattern in B1. Hence my confusion. What's making the difference?

B1 has the hyperlink style applied to it. The vertical alignment is different. Wrap text is different.

Okay, I think the Hyperlink style as it is in B2 is what I want. I'm not familiar with styles; any idea how I'd go about giving a cell that style without actually making it a hyperlink?

I've been trying to do just that, and gave it up because I was getting frustrated. Doing it manually, I can't quite reproduce it. In fact, if I go to Format/Style on the B1 cell, if I change anything, and change it back, the formatting in the cell reverts to the same type as the cells next to it. So, I don't how to get that same formatting, other than to copy it from another report that has it, which seems like a lot of bother.

If I select B1, then go to Format/Style, it shows the "Style Includes", and "Font" is selected. Next to font, it says "Arial 10, Underline Blue" (I don't know how that text gets in there, other than that it's supplied by modifications). If I then hit "Modify", the "Format Cells" dialogue box comes up. If I change anything in this dialogue (for instance, changing font size to 8 instead of 10) my font reverts to the blue hyperlink font. If I try to select the orange color, it DOES turn orange, but the same orange as it's brothers in A1 and C1. I don't know how to manually get that same extra boldedness of the current B1.

Check the style from the file you originally copied this cell/style from.

Good idea, but I don't know that it helps.

The original report was system generated. The labels, if I hover over them, are hyperlinks

Please Login or Register  to view this content.

Going to Format/Style, it's the same setup I just described, but instead of "Arial 10, Underline Blue" it says "Arial 8, Color 46". So where do I go from here?

It is almost as if the font was stretched a little. Like the system you exported from had its own Arial font file it used, and that font was stretched to fit something. And through the magic of copy/paste, it has held that stretched look. But when you apply a bold to it, it re-draws the font.

Or maybe the system has variations of Bold that excel does not support. Like Extra Bold, or something. And this thicker font attribute comes accross, but gets lost when you change the bold setting.

Whizbang, you've pretty much summed it up. I don't know how it did it, but I can copy and paste, but have no idea how to recreate it.

Romper, I'm not sure what the Style dropdown is; I assume you're thinking of the Ribbon, which we don't have in 2003.

Okay Romperstomper, you've floored me.

I can see in your workbook that you've modified the hyperlink style so it can be applied to other cells. I can see in the picture where you're getting your "style" dropdown, but I can't reproduce it. Is this a custom toolbar you've created, or an option somewhere that I need to turn on?

I'm trying to read up on styles, but I'm not finding how to copy a style to my Personal.xls so it will be available in all workbooks. Any ideas?

Well, if it's workbook specific then I guess I better just drop the matter. I wanted to use that same style in other workbooks, but it doesn't sound like it would be an easy thing to do.

BTW, how did you do the customization to add the styles dropdown?

Thanks Romper. I've done some other customizations, but never fooled any with Styles, but it looks like now I might need to.

Thanks,
John