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.
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.
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.
