Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2013, 10:50 AM
Lebber Lebber is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Advanced Beginner
Save table sytle, NOT a specific table
 
Join Date: Jan 2013
Posts: 44
Lebber is on a distinguished road
Default Save table sytle, NOT a specific table

I have a certain table style I use for a huge document. It includes every even line being light grey and every odd line being dark grey. Formatting all tables to fir this style by hand is of course tedious, so I tried to save the table style. However, all I got was saving a table style as shown here:



http://www.youtube.com/watch?v=L8QoRoDa1fY

Actually, saving a table style does NOT save a table style. It is simply is a paste bin for a specific table I created once. If I use that and try to expand my two-colour table, it will taint every new line in one shade of grey, which is almost as inefficient as formatting every by hand.

So, is there even a function to save table STYLE, not just ease copy-pasting a specific table?
Reply With Quote
  #2  
Old 01-23-2013, 09:42 AM
OTPM OTPM is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Could you not save your document as a template for use in the future. You could then create new documents based on that Table Style.
Hope this helps.
Good luck.
Tony
Reply With Quote
  #3  
Old 01-23-2013, 10:27 AM
Lebber Lebber is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Advanced Beginner
Save table sytle, NOT a specific table
 
Join Date: Jan 2013
Posts: 44
Lebber is on a distinguished road
Default

This would surely help (in fact, I already do that), but it's only so helpful. Picture having a table with a hundred lines. Every odd line is grey, every even line is white. Every time I see that I have forgotten an entry between lines X and Y, I have to insert a line at the bottom and copy-paste all the connect south of the new entry. It's a hassle and inefficient.

Hell, I can't even highlight every second line in a table! That would ease things too.
Reply With Quote
  #4  
Old 01-29-2013, 10:56 AM
Lebber Lebber is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Advanced Beginner
Save table sytle, NOT a specific table
 
Join Date: Jan 2013
Posts: 44
Lebber is on a distinguished road
Default

So, I guess Word 2010 simply lacks this function?
Reply With Quote
  #5  
Old 01-30-2013, 04:23 AM
konopca konopca is offline Save table sytle, NOT a specific table Windows XP Save table sytle, NOT a specific table Office 2003
Novice
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default

Hi Lebber - I don't use table styles so I can't help you with that. But I do have some code that I use to highlight every other table row. I hope it works for you; if it doesn't I probably can't help you there either as only dabble in macros. Here it is: First, remove all shading and then put your cursor in the first row that you want to apply shading.

Code:
 
Sub ShadeEveryOtherTblRow()
'
' Macro1 Macro
'
'This counter performs the shading on the stated number of rows
Do While intCounter < 7
intCounter = intCounter + 1
'The following highlights the row the cursor is on (the first row that you want shaded)
Selection.EndKey Unit:=wdRow, Extend:=True
'The following formats the row as a shade of grey
With Selection.Cells
With .Shading
.BackgroundPatternColor = -603930625
End With
End With
'The following moves the cursor down two rows
Selection.EndKey Unit:=wdRow
Selection.MoveRight Unit:=wdCell
Selection.EndKey Unit:=wdRow
Selection.MoveRight Unit:=wdCell
Loop
End Sub
Reply With Quote
  #6  
Old 01-30-2013, 04:28 AM
konopca konopca is offline Save table sytle, NOT a specific table Windows XP Save table sytle, NOT a specific table Office 2003
Novice
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default

Oh and I forgot to mention that you have to change the number in the first line of the code to be equal to half of your total rows. If the code creates a couple of extra rows, just undo (control + z) a couple of times.
Reply With Quote
  #7  
Old 01-31-2013, 12:36 AM
eNGiNe eNGiNe is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

I agree it would be a pain having to adjust row shading through a whole table each time you added a row; also, I'd sooner have this sort of thing under my control than just press a button and hope for the best … but have you taken a look at Insert > Tables > Quick tables? and/or Page layout > Table tools > Design? Some code-monkey may already have come up something that does what you're supposed to want ;-} (not that I use any of these options myself)
Reply With Quote
  #8  
Old 01-31-2013, 03:03 AM
Lebber Lebber is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Advanced Beginner
Save table sytle, NOT a specific table
 
Join Date: Jan 2013
Posts: 44
Lebber is on a distinguished road
Default

Thanks for the replies!

@eNGiNe: The main issue is that all of that is completely static. There is no function where you just highlight existing table X and slap design Y on it. Quick table inserts a pre-made table. It's copy-pasting an existing one. It's really just a paste bin. And the fact that minor scripting knowledge is required to select every bloody second row is ridiculous (thanks anyway, konopca).
Reply With Quote
  #9  
Old 01-31-2013, 06:36 AM
OTPM OTPM is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
I think I have just had a "lightbulb" moment (I get them occasionally ).
You can apply table styles to tables in your document and when you insert new rows the style adjusts automatically.
Follow these steps:
1. Click inside your table anywhere.
2. The Table tab will then appear at the top of your screen.
3. Click on the Design option.
4. You will then be presented with built in styles for your table which you can select.
Hope this helps.
Good luck.
Tony
Reply With Quote
  #10  
Old 02-01-2013, 12:31 AM
eNGiNe eNGiNe is offline Save table sytle, NOT a specific table Windows 7 32bit Save table sytle, NOT a specific table Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Ah – never having used these ready-made tables, I was assuming they were dynamic.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save table sytle, NOT a specific table Mail Merge to create specific number of table rows flackend Mail Merge 4 12-01-2023 02:49 PM
Save table sytle, NOT a specific table Layered or Nested Table difficulty--can't edit the table underneath theheartsmaster Word Tables 1 12-10-2012 04:10 AM
Save table sytle, NOT a specific table Update Word table based on another table input mpdsal Word VBA 10 10-29-2012 07:40 AM
Insert table in document - automatically updates second table in summary? Mechanic Word 2 08-01-2012 09:44 PM
Easy send/save Excel data to Database Table or Stored Procedure TonyHarvard Excel 3 07-11-2012 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:15 AM.


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