Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2017, 08:09 PM
dylansmith dylansmith is offline Apply Table Style without Table functions? Windows 8 Apply Table Style without Table functions? Office 2013
Optimizer
Apply Table Style without Table functions?
 
Join Date: Nov 2011
Posts: 128
dylansmith is on a distinguished road
Default Apply Table Style without Table functions?

I have made some custom table styles just to make the rows more readable. However, there are some tables which don't require table functions, and it is annoying that they add the headers on top even though I already specified not to.





Is there any way to just apply table styles without the function itself?
Reply With Quote
  #2  
Old 04-02-2017, 01:26 AM
xor xor is offline Apply Table Style without Table functions? Windows 10 Apply Table Style without Table functions? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,078
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

After you have formatted as you want then right click somewhere in the table, press Table and press Convert to Range, Yes.
Reply With Quote
  #3  
Old 04-02-2017, 04:41 AM
dylansmith dylansmith is offline Apply Table Style without Table functions? Windows 8 Apply Table Style without Table functions? Office 2013
Optimizer
Apply Table Style without Table functions?
 
Join Date: Nov 2011
Posts: 128
dylansmith is on a distinguished road
Default

using this method, I'll have an extra step of removing the top "Column 1... 2...3" headers after converting to range. Is there another way to simply apply Table Styles without having table function?
Reply With Quote
  #4  
Old 04-02-2017, 05:20 AM
xor xor is offline Apply Table Style without Table functions? Windows 10 Apply Table Style without Table functions? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,078
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Not that I know of.
Why not enter your own headers?
Reply With Quote
  #5  
Old 04-03-2017, 10:53 AM
gebobs gebobs is offline Apply Table Style without Table functions? Windows 7 64bit Apply Table Style without Table functions? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Don't your tables have column headers?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply styles in word table 1van Word VBA 2 11-17-2015 11:05 AM
Apply Table Style without Table functions? Table style of pasted table ChrisFManchester Word Tables 2 07-05-2015 06:17 AM
Apply Table Style without Table functions? how to apply table style WITHOUT setting it as a table? dylansmith Excel 9 05-16-2014 07:25 PM
Conditional Formatting: How to dynamically apply to an expanding table? tinfanide Excel 0 10-18-2013 06:34 AM
Apply Table Style without Table functions? How 2 Save Table Properties & Apply to other table Popeye.Tom Word Tables 1 04-24-2013 09:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:23 PM.


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