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

Win 7 Pro 64-bit
 
 
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 demo.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

Win 7 Pro 64-bit
 
 

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
.


Reply

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




Thread Tools



Similar help and support threads for2: How to format a table as a matrix with color striping?
Thread Forum
Panasonic Dot Matrix Drivers
Solved Dot Matrix Printer General Discussion
Cant map Dot Matrix to XP from Win7 64 Hardware & Devices
64-bit Dot Matrix Driver ? Drivers
USB Matrix? Hardware & Devices

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 07:48 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33