To make a copy of an Excel worksheet on your Mac without bringing its unwanted cell formatting along, create a blank sheet and copy the source cells using a paste option that excludes formatting. Choose Values to transfer displayed results, or Formulas to keep calculations. A normal paste or a duplicate-sheet command carries formatting with the cell content; Excel does not offer a single “duplicate sheet without formatting” option in the documented Mac controls.

Choose what the new sheet should preserve

A worksheet contains more than its visible numbers and words: cells can also contain formulas, number formats, borders, comments, data validation and conditional formatting. The right paste choice depends on which of those you need. Microsoft documents Paste Special options in Excel for Mac, and says attributes other than the selected option are excluded. Copy and paste specific cell content in Excel for Mac

Use Values when the destination should contain the displayed results without the source formulas or cell formatting. This suits a static handoff or snapshot, but copied formula cells will no longer recalculate. Use Formulas when calculations should remain live and you want to leave the source cell formatting behind. This copies formulas only, so confirm that the destination’s number presentation is suitable; a date or percentage may not display the way you expect without appropriate number formatting. If you need values and a particular number format, choose Values and number formats in Paste Special, then review the result because that option does carry number formatting.

The procedure below is for Excel for Microsoft 365 for Mac, Excel 2024 for Mac and Excel 2021 for Mac, the versions listed on Microsoft’s Mac-specific paste documentation. Menu names and available options can vary with the data selected and app version.

Copy the data into a clean worksheet

  1. In the source worksheet, select the cells you want to copy. To transfer a complete data area, select that range rather than relying on a whole-sheet selection if the sheet contains unrelated content. This helps you avoid copying extra cells or objects by accident.

  2. Press ⌘C to copy. Add a blank worksheet using the new-sheet control beside the sheet tabs, then select the top-left cell where the copied range should begin. Microsoft’s worksheet guidance describes adding a blank worksheet and pasting data into it; the precise keyboard shortcuts in that guidance are Windows shortcuts, so use the Mac menu and keyboard controls described here. Move or copy worksheets or worksheet data

  3. On the Home tab, open the arrow beside Paste, then choose Paste Special. Select Values to preserve displayed results, or Formulas to retain calculations without the source formatting. In some versions or contexts the Paste menu presents options such as Paste Values or Formulas directly. Microsoft notes that available choices depend on the copied data, and that menu option names can differ while producing the same result. Microsoft’s Excel for Mac paste options

  4. Check the new sheet before replacing or deleting the original. Compare several representative cells: a plain number, a date, a percentage, a formula result and any cells that had special rules. Confirm that the expected text and values arrived, formulas still calculate if you chose Formulas, and number formats are readable. Set up destination formatting separately if you want a consistent layout. You can select cells and apply a cell style from Home > Cell Styles, or format the cells using the Home tab controls. Apply, create, or remove a cell style in Excel for Mac

If you want to keep formulas but change only formatting

A second option is to duplicate the worksheet, then clear formats on the copied cells. In Excel for Mac, hold Option while dragging the sheet tab to the desired position; release the mouse button before releasing Option. Microsoft documents this gesture as a way to copy a sheet. Move or copy worksheets or worksheet data

On the copied sheet, select the range to clean up and choose Home > Clear > Clear Formats, if that command is available in your version. Clearing formats preserves contents, unlike Clear All or Clear Contents. It removes cell formatting from the selected cells, which can include number formats, borders and conditional formats. It may therefore remove useful presentation as well as the unwanted styling. Clear cells of contents or formats

This approach is useful when you need to retain formulas or worksheet structure but want a fresh cell appearance. It does not create a fully plain worksheet: sheet-level settings and other objects are not the same as cell formatting, and you may need to adjust column widths or review charts, shapes, tables and print layout yourself. If those objects or structures matter, inspect the duplicate carefully before using it as the new working sheet.

What these methods do not preserve

Pasting values is a one-way simplification: formulas become their displayed results. If a copied cell calculates a total, the pasted number will not update when its source values change. Keep the original workbook or duplicate sheet until you have confirmed that a static copy is what you intend.

Pasting formulas has a different limitation: formulas that refer to other cells may adjust when moved to a new location. Check important references and calculated results in the destination. If your goal is an identical, functioning worksheet, a full sheet copy is usually the better starting point; then clear selected formatting only where necessary.

Conditional formatting deserves special attention. Microsoft’s worksheet-copy guidance warns that copying worksheet data into a new sheet can lose conditional formatting. If color scales, alerts or other rule-based appearance communicate meaning in your sheet, verify whether those rules remain and recreate them if needed. Move or copy worksheets or worksheet data

Excel does not document a single Mac command that duplicates an entire sheet while automatically excluding every unwanted format and retaining all other sheet features. For cell data, choose Values or Formulas through Paste Special. For an intact sheet structure, duplicate the tab and clear selected formats, then inspect the result. These choices keep the task in Excel; Wallo can organize open Mac windows and to-dos by goal, but it does not change Excel’s paste behavior.

Sources