+ Reply to Thread
Results 1 to 2 of 2

Formatting Tables in Excel for Mac - need advice!

  1. #1
    Registered User
    Join Date
    02-06-2024
    Location
    middle east
    MS-Off Ver
    mac 16.81 365
    Posts
    1

    Cool Formatting Tables in Excel for Mac - need advice!

    Hi Everyone,

    I hope I can find an answer in this forum

    I'm working on formatting 20 finance tables in Excel for Mac and want to create a system for future use. The goal is to make it easy for our finance team to format tables consistently.
    So I've formatted a table with various styles including font color, background color, borders and cell height, and now I want to save the entire formatting as a custom style for future use. However, the "Format as Table" menu seems to preserve only text styles, not the complete formatting.

    Is there a way to create and save a custom style that includes all formatting aspects mentioned above in Excel for Mac?
    I'd appreciate any guidance or workarounds to achieve this. 

    mei

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,835

    Re: Formatting Tables in Excel for Mac - need advice!

    Is your Mac 16.81 an Excel 365 product? If so, please add 365 to your forum profile.
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formatting CSV data to excel for easy pivot tables - Advice needed
    By noobnoob in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-30-2020, 06:13 AM
  2. Excel and Conditional Formatting Mess (with Tables)
    By NewYears1978 in forum Excel General
    Replies: 8
    Last Post: 07-19-2018, 09:14 AM
  3. VBA code advice/Excel advice for summing groups of numbers
    By paulblower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2014, 05:47 AM
  4. Access Tables not using Excel formatting
    By kevindub in forum Access Tables & Databases
    Replies: 4
    Last Post: 11-11-2013, 03:34 PM
  5. Conditional Formatting - Excel 2010 - Need Advice to save time
    By seftonbarn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2013, 08:22 PM
  6. need advice on formatting issue
    By needhelp1243 in forum Excel General
    Replies: 1
    Last Post: 01-31-2007, 12:02 AM
  7. [SOLVED] Importing data, and need formatting advice
    By Bob in Charlotte in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-24-2005, 01:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1