Excel bolds one column in the subtotal rows. This short episode shows you how to bold all of the columns. Recap:
Excel bolds one column on the Subtotal Rows
How do you bold all columns?
The intuitive way does not work
Collapse to #2 view
Select from first to last row
Select Visible Cells (Alt+
or QAT Icon for Select Visible Cells
Format the subtotals
Go back to #3 view
Excel bolds one column on the Subtotal Rows
How do you bold all columns?
The intuitive way does not work
Collapse to #2 view
Select from first to last row
Select Visible Cells (Alt+
or QAT Icon for Select Visible CellsFormat the subtotals
Go back to #3 view
Transcript of the video:
Learn Excel from MrExcel podcast, episode 1996 - Format the Subtotals!
Alright, for the past couple of episodes we've been talking about subtotals, data subtotal.
Each change in: Customer, add the use of sum function, and you see, the problem is that they bold column C, but they don't bold the rest of it.
Your manager's like "Well, bold the whole line!" And, the intuitive way to do this is, like this, CTRL+B, but unfortunately, you'll see that that has bolded everything from the first subtotal on down, looks really bad.
So undo, undo, here's what you have to do: Select from the first subtotal down to the last subtotal, and then either Alt+; , or Home, Find & Select, Go To - Special, Subtotals.
OR, we can do, Customize the Quick Access Toolbar, All Commands, and then, down into the S, Select Visible Cells, add that to the Quick Access Toolbar, any of those to select just the things we can see, then CTRL+B, that will bold just the rows we can see, maybe even add a little bit of color. We're going to a nice light orange here, and you see, when I go back to the #3 view, that's very obvious where the subtotals are.
Makes the whole effect look much, much better.
This is just one of the bonus tips, this is not even tip 14, this is the second bonus tip after tip 13, buy the book, get all 40 tips, plus all the bonus tips, order online now.
All right, episode recap: When you add subtotals, they bold one column.
How do you bold all the columns?
The intuitive way, it doesn't work, you have to collapse down to the #2 view, select from the first row to the last, and then either Alt+; or use Select Visible Cells, and then go ahead and format the subtotals.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Alright, for the past couple of episodes we've been talking about subtotals, data subtotal.
Each change in: Customer, add the use of sum function, and you see, the problem is that they bold column C, but they don't bold the rest of it.
Your manager's like "Well, bold the whole line!" And, the intuitive way to do this is, like this, CTRL+B, but unfortunately, you'll see that that has bolded everything from the first subtotal on down, looks really bad.
So undo, undo, here's what you have to do: Select from the first subtotal down to the last subtotal, and then either Alt+; , or Home, Find & Select, Go To - Special, Subtotals.
OR, we can do, Customize the Quick Access Toolbar, All Commands, and then, down into the S, Select Visible Cells, add that to the Quick Access Toolbar, any of those to select just the things we can see, then CTRL+B, that will bold just the rows we can see, maybe even add a little bit of color. We're going to a nice light orange here, and you see, when I go back to the #3 view, that's very obvious where the subtotals are.
Makes the whole effect look much, much better.
This is just one of the bonus tips, this is not even tip 14, this is the second bonus tip after tip 13, buy the book, get all 40 tips, plus all the bonus tips, order online now.
All right, episode recap: When you add subtotals, they bold one column.
How do you bold all the columns?
The intuitive way, it doesn't work, you have to collapse down to the #2 view, select from the first row to the last, and then either Alt+; or use Select Visible Cells, and then go ahead and format the subtotals.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
