Creating Better Underlines - Podcast #1259

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Oct 5, 2010.
Paul from Las Vegas offers a great workaround to underlining your headings! Some managers resort to adding tiny little columns between their columns to avoid this problem. Using the trick in Episode #1259, create better looking headings in Excel.
maxresdefault.jpg


Transcript of the video:
This Excel podcast is sponsored by Easy-XL.
Learning Excel from MrExcel podcast episode 1259, Better Underlines.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Again, if you have questions for the podcast, send them in Bill@MrExcel.com.
This today is not a question.
This is just one that I talk about in my seminars all the time.
You know I...
I always hate when managers make people add the tiny little columns between the columns.
Like this blank column B and the blank column D and the blank Column F and the reason that they generally do that is that they've used the bottom border to underline their headings.
And they want a little break between the borders of each column.
They think that looks better.
All right, well, this is dangerous because someone's going to sort part of this data, and not all of this data and of course if you have tried this...
If you try it and just use the regular underlines, the underlies only fall underneath the words and it doesn't, you know, make the manager happy.
That's not what they're looking for.
But today, I have a great trick, this trick is from Paul.
Paul was in one of my seminars in Las Vegas last spring and Paul taught me what I think is a beautiful trick.
Underneath the underlying option up here, we have underlined and double underline.
I don't want either of those, I want to go into Format Cells.
So, I'm going to click the dialogue launcher here, or press Ctrl+1, and we get into the format cells dialog box.
Now, here on the Font Tab, check this out.
Although, single and double underline were available, there is two other types including single accounting and double accounting.
Let's check out single accounting and click OK.
And, oh wow, hey, single accounting underlines almost the entire column but, it doesn't underline the entire column.
So, there actually then appears to be a break between each of the items.
So, if you have a manager who is trying to get the breaks between the underscore, don't use the bottom border, don't insert the blank column between each column.
Just go and use what they call the accounting underline to solve their problem.
There you have it.
I wanna to thank you to stopping by.
See you next time with another netcast from MrExcel.
 

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top