Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 05-16-2014, 07:25 PM
dylansmith dylansmith is offline how to apply table style WITHOUT setting it as a table? Windows 8 how to apply table style WITHOUT setting it as a table? Office 2013
Optimizer
how to apply table style WITHOUT setting it as a table?
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
 



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 to apply table style WITHOUT setting it as a table? 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
how to apply table style WITHOUT setting it as a table? Setting cursor after last Table of Contents DugganSC Word 1 09-07-2011 11:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft