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

macropod · #9 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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