Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to format a table as a matrix with color striping?

13 Feb 2014   #1

How to format a table as a matrix with color striping?

I want to format a table as a matrix with the rows striped and the columns striped also.
However, I cannot seem to make a table format that accomplishes that.

There are several canned table formats that stripe the rows, but none that stripe the columns.

Creating a custom table format that stripes rows works OK: excel > home > format as a table > new table style > , second row stripe > format (choose color) ...

However, but I cannot get the custom format to apply any column formatting. It shows in the "preview" correctly, but does NOT show up with the same preview pattern when the style is saved as a custom style. (The custom formats appear before the light, medium and dark table formats when created.)

Neither does it appear in the icon for the custom format, nor does it apply to the data in the spreadsheet.

Attached is a demo xlsx of what I am trying to do. Near the top, see the table that I manually colored without a format. Below, is a table I am trying to format using a custom style. Cannot get the style to apply column formatting.

Is this is a bug or am I doing something wrong? Running Office Pro 2010.

How to format a table as a matrix with color striping?-custom_table_format_problem.png

Attached Files
File Type: zip (8.2 KB, 2 views)
My System SpecsSystem Spec
14 Feb 2014   #2

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)

No, this is not a bug.

Please go to Design tab and make sure that check-mark "Banded Columns" is ON (checked).
My System SpecsSystem Spec
15 Feb 2014   #3


Quote   Quote: Originally Posted by Neutron16 View Post
Please go to Design tab and make sure that check-mark "Banded Columns" is ON (checked).
That's it! Thank you!

How to format a table as a matrix with color striping?-custom_table_format_solution.png

My System SpecsSystem Spec


 How to format a table as a matrix with color striping?

Thread Tools

Similar help and support threads
Thread Forum
Windows 7 RAID 0 (Striping) Performance ?
Hi all. First of all if the thread is at wrong side, mods mercy me :) I am new to RAID and yesterday i wanted to try it and i figured out i can do it from disk managment.(I think its call software RAID ?) I have 500 gb hdd with 2 partition (C: F:) (main, the hdd which is os installed) and 80...
Performance & Maintenance
Panasonic Dot Matrix
hi all. im looking for panasonic kx-p1121 win 7 driver. its connected to my pc using LPT printer port. please help
Dot Matrix Printer
Hi, I have a dos program running on a Windows 7 (32-bit) machine that requires a dot matrix printer on LPT1 to print reports. There is no LPT1 port on the machine so I have bought a converter to link the cable to a USB port. What procedure do I follow to set this printer up on this machine? ...
General Discussion
Cant map Dot Matrix to XP from Win7 64
We have been using dot matrix printer over our network of 6 machines for years using the following command. NET USE LPT2:\\Brad\SERVICE/ PERSISTENT:YES Just installed Win7 64 bit machine (1 Win 7 64 bit and 5 XP 32 bit machines on network) and everything runs except the connection to this...
Hardware & Devices
64-bit Dot Matrix Driver ?
I'm looking for a 64 bit Windows Vista/Windows7 Driver for a Old Epson LQ-500 Dot Matrix Printer. I can't find one that is compatible neither can I find a compatible Generic driver.
networked NEC P30 dot matrix printer
Hi, I just installed 7 and am trying to get all my stuff up and running. One thing still missing, is a NEC P30 that's connected to my 2003 Server and shared. Windows Update won't find any drivers, how could I go about to use that printer (though it's just an old dot matrix printer, I badly need...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:40.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App