From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Control table formatting with custom formats

Control table formatting with custom formats - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Control table formatting with custom formats

“

- [Instructor] The data in this worksheet 2 from columns A through J has been converted into a table. 3 It has that distinctive look 4 that we refer to as banded rows. 5 And by the way, in the contextual design tab 6 that appears anytime the active cell 7 is within a pivot table, 8 you certainly could consider changing that 9 to be banded columns. 10 As you do this by the way, 11 you might have noticed something else 12 happening on the screen. 13 The table styles over here to the right, 14 and you can click the arrow on the bottom, 15 reveal these choices now in banded column style. 16 If we go back to banded rows instead, and by the way, 17 almost nobody wants to have both at the same time. 18 Back to banded rows. 19 If we can go back here, 20 and now the previews as we see them show banded rows. 21 Now there's 61 options here, 22 and I think almost anybody's going to find 23 something out here that he or she…

Contents