How to Use Excel for Mac: A Practical Guide

This guide walks you through the essential steps of using Microsoft Excel on a Mac, from opening and navigating the interface to entering formulas, formatting cells, and saving your work. Whether you’re new to Excel or switching from Windows, you’ll learn the key differences and get practical tips to work efficiently.

What You’ll Need

A Mac running macOS 11 (Big Sur) or later, as Excel 2019 and Microsoft 365 require these versions.
Microsoft Excel installed – either the standalone version or through a Microsoft 365 subscription.
Basic familiarity with using a Mac (mouse/trackpad, menus, and keyboard shortcuts).

Step-by-Step

Open Excel and create a new workbook. Click the Excel icon in the Dock or Launchpad. On the start screen, select “Blank Workbook” or choose a template. A workbook is your file; it contains one or more worksheets (tabs at the bottom).
Understand the interface. The top bar has the ribbon with tabs like Home, Insert, Data, and Review. Below that is the formula bar (shows the content of the active cell). The main grid is your worksheet – columns are lettered (A, B, C…), rows are numbered (1, 2, 3…). The intersection is a cell, referenced by column and row (e.g., B2).
Enter data. Click a cell and start typing. Press Return to move down, Tab to move right, or Enter (on the numeric keypad) to stay in the same cell. To edit an existing entry, double-click the cell or press Control + U.
Select cells and ranges. Click and drag to select a range. To select an entire row or column, click the row number or column letter. To select non-adjacent cells, hold Command (⌘) and click each cell. To select a large range, click the first cell, hold Shift, and click the last cell.
Use formulas and functions. Click a cell and type an equals sign (=) to start a formula. For example, =A1+B1 adds the values in A1 and B1. For functions, type the function name and arguments, e.g., =SUM(A1:A10) sums the range. Use the Formula Builder (click the fx button) to search for functions and see descriptions.
AutoFill and Flash Fill. Select a cell with a value, then drag the small square at the bottom-right corner (the fill handle) to fill adjacent cells with a series (like 1, 2, 3 or dates). Flash Fill (on the Data tab) automatically fills patterns based on examples – type the first few values, then press Control + E.
Format cells. Select the cells, then use the Home tab to change font, size, bold, colors, borders, and alignment. To format numbers (currency, percentage, dates), go to the Home tab and click the number format drop-down. For more options, press Command + 1 to open the Format Cells dialog.
Insert and delete rows/columns. Right-click a row number or column letter and choose Insert or Delete. To insert multiple, select the same number of rows/columns first.
Sort and filter data. Select your data range, then go to the Data tab and click Sort or Filter. Filters add drop-down arrows to each column header, letting you show only certain values.
Create charts. Select the data you want to chart, then go to the Insert tab and choose a chart type (bar, line, pie, etc.). Excel will create the chart; use the Chart Design tab to modify it.
Save your work. Press Command + S to save. In the dialog, choose a location and name. The default format is .xlsx (Excel workbook). To share with older Excel versions, choose .xls. To export as PDF, go to File > Export To > PDF.
Use keyboard shortcuts. Learn the most common ones: Command + C (copy), Command + V (paste), Command + Z (undo), Command + F (find), Command + Arrow keys (jump to edge of data), Command + Shift + L (toggle filters).

Common Mistakes

Using Windows shortcuts. On a Mac, use Command (⌘) instead of Control for most shortcuts (e.g., Command+C to copy). Control is used for some specific actions like Control+U to edit a cell.
Forgetting to start formulas with =. Typing SUM(A1:A10) without the equals sign will treat it as text.
Not using absolute references. When copying formulas, relative references change (e.g., A1 becomes A2). Use $ (e.g., $A$1) to lock a reference. Press Command + T to cycle through absolute/relative options.
Deleting data instead of clearing formatting. Pressing Delete removes content but leaves formatting. To clear everything, use Home > Clear > Clear All.
Assuming the Mac version is identical to Windows. Some features (like Power Query) are slightly different, and some keyboard shortcuts differ. Check the Excel for Mac Help menu for specifics.

Tips

Use the Formula Builder. Click the fx button next to the formula bar to get help with functions – it explains arguments and shows examples.
Take advantage of the status bar. Select a range of numbers and look at the bottom-right corner: it shows the sum, average, count, and more without needing formulas.
Freeze panes to keep headers visible. Go to View > Freeze Panes and choose Freeze Top Row or Freeze First Column.
Use the AutoSum button. On the Home tab, click the Σ (AutoSum) to quickly sum a column or row – it inserts the SUM formula for you.
Customize the Quick Access Toolbar. Right-click any command and choose “Add to Quick Access Toolbar” to have your most-used actions one click away.
Learn the trackpad gestures. Two-finger scroll to move around, pinch to zoom, and double-tap with two fingers to right-click (if enabled).

Troubleshooting

Excel won’t open or crashes. First, restart your Mac and try again. If it persists, check for updates (Help > Check for Updates). If the problem continues, try resetting Excel preferences: close Excel, go to ~/Library/Preferences, and delete the com.microsoft.Excel.plist file (this resets settings).
Formulas showing as text. If you see the formula text instead of a result, the cell might be formatted as Text. Select the cell, go to Home > Format > Format Cells, and change the number format to General. Then re-enter the formula.
Can’t find a feature. Use the Search bar at the top of the ribbon (or press Command+Shift+F) to search for commands. Alternatively, check the Help menu.
File won’t open from a Windows user. If the file is .xls or .xlsx, it should open. If it’s .csv, try opening with Excel directly. If it’s corrupted, try opening in Google Sheets as a workaround.
Charts look wrong. Make sure the data is selected correctly. Click the chart, then use the Chart Design tab to switch rows/columns or change the chart type.

Frequently Asked Questions

Is Excel for Mac the same as Excel for Windows?

Most core features are identical, but there are differences in keyboard shortcuts and some advanced features (like Power Query) may have less functionality. The interface is similar, but the ribbon is slightly different in layout.

How do I convert a Windows Excel file to Mac?

You don’t need to convert – Excel for Mac opens .xlsx and .xls files directly. Just double-click the file or use File > Open. If you want to save it in a different format, use File > Save As and choose the format.

Can I use macros in Excel for Mac?

Yes, you can record and run macros using VBA (Visual Basic for Applications). The macro recorder is under Tools > Macro > Record Macro. However, some VBA features may behave slightly differently on Mac.

How do I create a drop-down list in Excel for Mac?

Select the cell(s), go to Data > Data Validation, choose “List” under Allow, and enter your options in the Source box (separated by commas). Click OK. The drop-down arrow will appear in the cell.

How do I print a large spreadsheet on one page?

Go to File > Print, and in the Print dialog, look for the “Scaling” option. Choose “Fit Sheet on One Page” or set a custom percentage. You can also adjust margins and orientation in the same dialog.

Why is my Excel slow on Mac?

Large files with many formulas or formatting can slow down. Try turning off automatic calculation (Formulas > Calculation > Manual), remove unused formatting, or break the file into smaller parts. Also, ensure you have enough free RAM and close other apps.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →