Look Who it Was Random video

Excel - Create Custom Table Formats: Banded Rows, Conditional Formatting, & More! - Episode 935

1,429 views · Published 23 January 2009 · 3:52 · Indexed 8 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Create Custom Templates for Different Customers in Excel.

Welcome back to the MrExcel netcast! In this video, we will be discussing how to create custom table formats in Excel. This topic was inspired by a question from Lisa on how to format every other row in a table. Throughout the week, we have explored various methods such as using the format autoformat, conditional formatting, and the table functionality to achieve this. However, what if we want to use the table functionality but still replicate the 2 rows of green and 2 rows of white format? Well, I'll show you how to do just that.

To begin, I will use the shortcut key of CONTROL+T to turn on the table. Then, I will click on "New Table Style" at the bottom of the gallery to create my own custom table style. From there, I can choose the first row stripe and specify that it is 2 rows tall. I can then select a color for this stripe, such as green. Next, I will do the same for the second row stripe, making it 2 rows tall and choosing a different color, like light yellow. You can preview the format before applying it to the entire table.

If you want this to be the default table style for your entire document, you can set it as the default by clicking "OK". However, if you prefer to use the table functionality only for formatting purposes and not for its other features, such as the autofilter dropdowns, you can easily convert it back to a range by going to TABLE TOOLS, DESIGN, and selecting "Convert to Range". This will turn off the table tools but still keep the formatting intact.

One thing to note is that when using the table functionality, some features like custom views may be disabled. If this is causing any inconvenience, you can always convert the table back to a range as mentioned earlier. Overall, the table functionality in Excel offers a great way to quickly format your data and have control over the design. So, give it a try and see how it can improve your workflow.

Thank you for watching this netcast from MrExcel. If you found this video helpful, don't forget to like, comment, and subscribe for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


In case 54x20 formats is not enough for you, you can design your own table format. Episode 935 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Ctrl T Table formats in Excel
(00:15) Monday's method: using autoformat
(00:25) Tuesday's method: using fill handle
(00:35) Wednesday's method: using conditional formatting
(00:45) Thursday's method: using table functionality
(00:55) Replicating Monday's method with table functionality
(01:05) Creating a custom table style
(01:45) Setting custom style as default
(02:01) Using custom style to format table
(02:36) Additional features and considerations of table functionality
(03:29) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alternating row formatting in Excel tables
Conditional formatting in Excel
Converting tables to ranges in Excel
Creating custom table styles in Excel
Formatting options in Excel tables
How to format rows in Excel
Removing table functionality in Excel
Setting default table style in Excel
Tips for formatting and using tables in Excel
Using autoformat in Excel
Using fill handle for formatting in Excel
YouTube video on formatting every other row


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152101/

More from this channel