Hello,
Is it possible to save a table style with cell alignments and numbering styles? I would like the first table on the sheet to be saved and applied to the other tables please. The font sizes are different for the header row, body rows, and bottom row.
Thank you
Go to Format as Table ... on the Home ribbon and select New Table Style. Set your requirements and save, remembering to TICK the box so that it becomes the default.
Hope this helps.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I don't see cell alignments when in the styles for the tables. Am I missing something?
Can the first table be saved "as is" which has all of the formatting I like?
No - unfortunately not. Would be good if it could! There may be a way with VBA - would you like me to move the thread for you?
Click on the Format button to access font and alignment settings.I don't see cell alignments when in the styles for the tables. Am I missing something?
I would have to apply those to each table as I see it. Maybe there are ways with VBA? Can you please see if someone can do it with VBA? Thank you very much.
I've moved the thread and updated the title. This is why explicit thread titles are so important - your "Table Styles" really wasn't indicative of what you were asking - it was too generic.
Great thank you for the advice also.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks