Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2011, 01:12 AM
pakistanray pakistanray is offline Copy table cell formatting across multiple cells / tables Windows XP Copy table cell formatting across multiple cells / tables Office 2007
Novice
Copy table cell formatting across multiple cells / tables
 
Join Date: Oct 2011
Posts: 2
pakistanray is on a distinguished road
Default Copy table cell formatting across multiple cells / tables


Hello,

I have a table with 3 rows and 5 columns. I've formatted the first cell of the table (text align, background color). I want to copy the cell formatting and use the formatting to quickly set other cells in my table. How to accomplish such a task? (
I've tried:
- Styles - I guess I can only save a whole table style, not a table cell style
- Format Painter - upon copying and pasting the formatting, the tool sets the background color of the text in a new cell instead of a background color of a cell

Regards.
Reply With Quote
  #2  
Old 10-31-2011, 05:45 AM
macropod's Avatar
macropod macropod is offline Copy table cell formatting across multiple cells / tables Windows 7 64bit Copy table cell formatting across multiple cells / tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi pakistanray,

Paragraph Styles should be used to manage anything to do with text formatting (including text background colour). Used correctly, there's then nothing in that regard to copy - simply re-apply the desired Style to the relevant cells. As for cell attributes (borders, shading etc), I think you'd need a macro to do the replication.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-31-2011, 08:07 AM
pakistanray pakistanray is offline Copy table cell formatting across multiple cells / tables Windows XP Copy table cell formatting across multiple cells / tables Office 2007
Novice
Copy table cell formatting across multiple cells / tables
 
Join Date: Oct 2011
Posts: 2
pakistanray is on a distinguished road
Default

Thank you for the response, macropod.
Reply With Quote
Reply

Tags
cell, formatting, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading in Cells in Word Tables Cindy Word Tables 1 01-04-2013 02:38 PM
Copy table cell formatting across multiple cells / tables Multiple VLOOKUP's checking multiple Cells OTPM Excel 11 05-23-2011 11:18 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Copy table cell formatting across multiple cells / tables Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:45 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