You can quickly format your worksheet data by applying a predefined table style. However, when you apply a predefined table style, an Excel table is automatically created for the selected data. If you don't want to work with your data in a table, but keep the table style formatting, you can convert the table back to a regular range.

1. Microsoft Excel Table Formatting
2. Free Excel For Mac
3. Microsoft Excel Mac Download
4. Excel For Macs

Excel provides numerous predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style. Although you can delete only custom table styles, you can remove any predefined table style so that it is no longer applied to a table. This Excel tutorial explains how to remove grand totals for rows in a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions). On a pivot table, how do I remove the grand totals for rows in Microsoft Excel 2011 for Mac? To press the delete button on Mac computers you have to hold down the fn key and the Delete key at the same time when you want to delete something on a Mac. (Skip to video) After a while, you get used to the idea that the Delete key on a Mac is really a backspace key.

Note: When you convert a table back to a range, you lose table properties like row shading with Banded Rows, the ability to use different formulas in a Total Row, and adding data in rows or columns directly adjacent to your data will not automatically expand the table or its formatting. Any structured references (references that use table names) that were used in formulas turn into regular cell references.

Select a location where you would like to save your OneDrive files and click Choose this location. When you see the This is your OneDrive folder screen, you’ll now see a path to the folder you selected. Click Next to continue. On the Sync Files from Your OneDrive screen, you can choose the folders you want to sync to your computer, and click Next. This conserves space on your computer, and reduces. The first time that you use Office, a folder named Microsoft User Data is created in the Documents folder provided by the Mac OS. The Microsoft User Data folder contains an Office 2011 Identities folder that stores the Office database for each identity in its own folder. You can move the folder for an identity. Go to the Office 365 Portal, and sign in with your user name and password. From the App launcher, select OneDrive. In OneDrive, team members can store their own business-related files. You can share either individual files, or a whole folder. Office 2016 MAC Where is the (new) Microsoft User Data folder Hi, previously you wonderfully could always include the Microsoft User Data folder to your backup and if there was some trouble, the defective DB could be simple be replaced by the 'old' one. Microsoft user data folder mac office 365 download. Mar 19, 2020  I just upgraded from Office 2011 for the Mac to office 2016 (via an office 365 subscription). Can I delete the old 'microsoft user data' folder in my documents folder. My understanding is that office 2016 doesn't need it. Since I didn't use Outlook, the folder is small, but it is still clutter I'd like to get rid of if not needed.

Create a table, then convert it back into a Range

1. On the worksheet, select a range of cells that you want to format by applying a predefined table style.

2. On the Home tab, in the Styles group, click Format as Table.

3. Click the table style that you want to use.

   Tips:

   • Auto Preview - Excel will automatically format your data range or table with a preview of any style you select, but will only apply that style if you press Enter or click with the mouse to confirm it. You can scroll through the table formats with the mouse or your keyboard's arrow keys.

   • Custom table styles are available under Custom after you create one or more of them. For information on how to create a custom table style, see Format an Excel table.

4. Click anywhere in the table.

5. Go to Table Tools > Design on the Ribbon. On a Mac go to the Table tab.

6. In the Tools group, click Convert to Range.

   Tip: You can also right-click the table, click Table, and then click Convert to Range.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

How to clear table formatting style without losing table data in Excel?

Sometimes you may need to clear the table formatting style from a table but reserve table data in Excel. Apart from copying the table and pasting as values, this article will introduce a couple of ways to clear/delete table formatting style without losing table data in Excel.

Clear table formatting style without losing table data by Kutools for Excel

One click to convert a table to plain text of range in Excel

When applying Home > Clear > Clear Formats to a table, it will remove fill color, font color or other formats from the table. However, the selected range is still a table. But you want to remove all kinds of formats from the selected table and convert it to a normal range with plain text. In this case, try the Clear All Cell Formatting utility of Kutools for Excel. Full Feature Free Trial 30-day!

Microsoft Excel Table Formatting

• Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
• More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
• Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
• Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
• Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
• Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment..
• More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Clear table formatting style without losing table data by Convert to Range feature

Actually we can apply the Convert to Range feature to remove table formatting style from a table easily. Please do as follows:

1. Select any cell in the table you will clear table formatting from to activate the Table Tools, and then click Design > Convert to Range. See screenshot:

Note: You can also right click any cell in the table, and then click Table > Convert to Range from the right-clicking menu. See screenshot:

2. In the popping up Microsoft Excel dialog box, please click the Yes button.

And now you will see the table formatting style has been removed/cleared from original table. However, original table’s fill color, font color and other formatting styles are reserved. See screenshot:

Clear table formatting style without losing table data by Kutools for Excel

If you need to remove all table formatting styles, including fill color, font color, etc. from a table, you can try Kutools for Excel’s Clear All Cells Formatting utility.

1. Select the entire table that you will remove the table formatting style from, and click Kutools > Format > Clear All Cells Formatting.

Now you will see all table formatting styles, including the fill color and font color are removed from original table as below screenshot shown:

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

Demo: Clear table formatting style without losing table data

Free Excel For Mac

Kutools for Excel’s Transpose Table Dimensions utility is designed to convert between two-dimensional table and one dimensional list in Excel. For a table, this utility will convert it to a 3-columns list without retaining tale formatting. Full Feature Free Trial 30-day!

Related articles:

Microsoft Excel Mac Download

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Excel For Macs