how to apply table style WITHOUT setting it as a table?

dylansmith · #1 05-16-2014, 07:04 PM

Quote:

Originally Posted by macropod

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

not the most ideal option if they are highly relevant to one another

Quote:

2. single worksheet, with each table diagonally offset from the others.

it would look like a poorly formatted sheet in others' opinion..

Quote:

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.

which brings me to another question - is it possible to have a dynamic link between Excel & Word? for example, when we put an Excel file within powerpoint, the excel file can be edited directly and source file is updated accordingly. there doesn't seem to be a similar function in Word.

---

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?

macropod · #2 05-16-2014, 07:19 PM

Quote:

Originally Posted by dylansmith

not the most ideal option if they are highly relevant to one another
...
it would look like a poorly formatted sheet in others' opinion..

Please don't shoot the messenger - I'm merely telling you what your options are. It's up to you to choose what course you take.

Quote:

is it possible to have a dynamic link between Excel & Word. for example, when we put an Excel file within powerpoint, the excel file can be edited directly and source file is updated accordingly. there doesn't seem to be a similar function in Word?

You can both link the content and update it from Word. To link, choose Paste Special with the link option and the link format of your choice. To edit, simply right-click on the linked data, then choose Linked Worksheet Object> Edit (or Open) to open the workbook for editing.

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.

dylansmith · #3 05-16-2014, 07:25 PM

Quote:

Originally Posted by macropod

Please don't shoot the messenger - I'm merely telling you what your options are. It's up to you to choose what course you take.

You can both link the content and update it from Word. To link, choose Paste Special with the link option and the link format of your choice. To edit, simply right-click on the linked data, then choose Linked Worksheet Object> Edit (or Open) to open the workbook for editing.

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.

really sorry, i meant no offence. just wanted to see if there are other ways we could go about this problem.

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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