#1
|
|||
|
|||
how to apply table style WITHOUT setting it as a table?
1. i'd like to have the style (alternating blue shades) applied to my cells, but i don't want it to function as a table (because then i wouldn't be able to split cells within my table). how can this be achieved? 2. i have multiple tables/content within 1 sheet, and often some cells have a lot of content that forces me to expand the cell width. This in turn affects the formatting of the other tables I have (on the right and below the original table). is there any way i could use to retain proper width on the other 2 tables, while still keeping the original table (with long text) as-is? Thanks in advance for your help! |
#2
|
|||
|
|||
Under Table Tools: Design, select Convert to Range.
|
#3
|
|||
|
|||
thanks for the answer to Q1 - how about Q2?
|
#4
|
||||
|
||||
If your Q2 is " can you have a colmun in Excel with different widths ?", the answer is no.
But you could play around with merged cells ( which are very difficult to use to retrieve information), or the horizontal formatting "center across selection". Of course you then use multiple columns
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Right. But messing with merge can be dicey as well as completely unnecessary. It only solves the problem until another column needs to be resized throwing the whole mess into disarray. The only time I do that is for forms that absolutely must fit on a 8.5x11 sheet. Since sheets have practically unlimited columns and a workbook can have many sheets, why anyone would want that bother if they didn't need to is beyond me.
|
#6
|
|||
|
|||
Quote:
if not, is there any other way i could format all tables within a single sheet nicely? |
#7
|
||||
|
||||
If you want to have multiple 'table' formats that are independent of each other, you basically have two options - use a:
1. separate worksheet for each table; or 2. single worksheet, with each table diagonally offset from the others. Of course, if your data are suitably arranged for output to Word and you're amenable to that, a Word document can have tables with multiple-width columns and multiple-height rows, including support for merged & split cells. And, of course, Word tables simply appear sequentially in a document and you can use Tables of Contents, etc, for navigation between them.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
Quote:
Quote:
Quote:
--- back to Q1, i notice the solution "convert to range" doesn't work if I have a few extra lines at the bottom to be formatted in the same style. is there a solution that can be used for the example below too? |
#9
|
||||
|
||||
Quote:
Quote:
It's not clear what your issue is with 'Convert to Range'. If you want the Sub-Total, Tax & Grand Total cells shaded, simply copy & paste the formats from the rows above to just those cells, or include those entire rows in the table beforehand.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
Quote:
the issue with 'convert to range' is that i cannot highlight the extra portion (where the subtotal part is) and simply apply the formatting. in this case, i would need an additional step to copy/paste the formatting from table to the portion below.. appreciate your help, thanks. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting: How to dynamically apply to an expanding table? | tinfanide | Excel | 0 | 10-18-2013 06:34 AM |
Assigning table style colors with VBA | bremen22 | Excel Programming | 1 | 10-01-2013 05:23 PM |
How 2 Save Table Properties & Apply to other table | Popeye.Tom | Word Tables | 1 | 04-24-2013 09:44 PM |
Macro to Table Style | ubns | Word VBA | 1 | 04-16-2012 05:01 AM |
Setting cursor after last Table of Contents | DugganSC | Word | 1 | 09-07-2011 11:42 AM |