Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2014, 11:27 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: 106
dylansmith is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 05-16-2014, 05:15 AM
gebobs gebobs is offline how to apply table style WITHOUT setting it as a table? Windows 7 64bit how to apply table style WITHOUT setting it as a table? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Under Table Tools: Design, select Convert to Range.
Reply With Quote
  #3  
Old 05-16-2014, 07:04 AM
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: 106
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
Under Table Tools: Design, select Convert to Range.
thanks for the answer to Q1 - how about Q2?
Reply With Quote
  #4  
Old 05-16-2014, 09:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how to apply table style WITHOUT setting it as a table? Windows 7 64bit how to apply table style WITHOUT setting it as a table? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,398
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #5  
Old 05-16-2014, 01:46 PM
gebobs gebobs is offline how to apply table style WITHOUT setting it as a table? Windows 7 64bit how to apply table style WITHOUT setting it as a table? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #6  
Old 05-16-2014, 06:38 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: 106
dylansmith is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
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.
is the usual best practice to put each table in a separate sheet (and even if the tables are highly relevant to one another)?

if not, is there any other way i could format all tables within a single sheet nicely?
Reply With Quote
  #7  
Old 05-16-2014, 06:51 PM
macropod's Avatar
macropod macropod is online now how to apply table style WITHOUT setting it as a table? Windows 7 32bit how to apply table style WITHOUT setting it as a table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,036
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote
  #8  
Old 05-16-2014, 07:04 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: 106
dylansmith is on a distinguished road
Default

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

Reply With Quote
  #9  
Old 05-16-2014, 07:19 PM
macropod's Avatar
macropod macropod is online now how to apply table style WITHOUT setting it as a table? Windows 7 32bit how to apply table style WITHOUT setting it as a table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,036
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Quote:
Originally Posted by dylansmith View Post
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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #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: 106
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
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 01:59 AM.


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