With Numbers for Mac, sophisticated spreadsheets are just the start. The whole sheet is your canvas. Just add dramatic interactive charts, tables, and images that paint a revealing picture of your data. You can work seamlessly between Mac and iOS devices. And work effortlessly with people who use Microsoft Excel. Updated for OS X El Capitan, Numbers is now more powerful than ever.
A spreadsheet doesn’t have to look like a ledger. That’s why Numbers starts you off with a blank canvas instead of an endless grid. You can choose fonts and style cell borders. Add, resize, and apply styles to tables. Move everything around your canvas at will. And use the new Split View feature in OS X El Capitan to match your charts to the corporate style guide PDF. Next thing you know, you’ve turned budgeting into an art form.
Over 30 templates to start with. Just add your numbers.
Drop your data into one of the gorgeous, Apple‑designed templates. Suddenly, the numbers look better than they ever have.
Spreadsheets. Outside the lines.
A Numbers sheet is a blank canvas, so you can place multiple tables, images, and shapes anywhere you want. Pixel‑accurate rulers and alignment guides make it easy to do precisely that.
Design your data.
Preset styling options let you choose table designs right when you create them. And you can quickly customize the look of your tables with easy-to-use cell border styling controls.
Split and conquer.
The new Split View feature in OS X El Capitan makes quick work of multitasking. Now you can confirm sales figures from your notes while updating your projections. Or bring up a staffing chart while checking your project management app.
Starting with Numbers is as easy as 1, 2, 3. There are prebuilt templates for all your most common tasks. Coaching tips that pop up right when you need them. And an intuitive interface that simplifies the equation of finding the tools you want. Underneath it all, there’s an advanced calculation engine that makes full use of the 64-bit power of OS X El Capitan. So nothing will slow you down once you get going.
The right tools, right at hand.
The format panel automatically displays relevant controls based on what you’ve selected. So you have the controls you want, just when you want them. And a simplified toolbar makes quick work of finding the tool you’re looking for.
A better handle on tables and cells.
Selecting and editing tables, columns, rows, and cells is second nature in Numbers. Which makes working with your data just as intuitive. And with the new Transpose feature, you can instantly switch columns and rows with a quick click.
Math tutor included.
Turn on coaching tips, and help will pop up just when you need it. There’s no better way to figure out how to work with Numbers.
Numbers supports over 250 functions. And it’s built with sophisticated tools that make using them way simpler than you’d think. With a few clicks, you can perform complex calculations, filter the data, and sum up what it all means. Running the numbers is now a simple operation.
Formulas, solved.
The functions browser lets you search over 250 functions, see example formulas, and get help. It’s really more like a formula genius.
Numbers knows what function you want before you do.
Function auto-complete suggests formulas as you begin to type them. It’s the fastest way to find the right function for whatever you need to do.
The quickest way to find the answer.
Quick calculations appear along the bottom when you select a range of cells. Just drag and drop the one you want. You can even customize calculations so your favorites are always close by.
Cells that almost think for themselves.
Just select a cell to see live formula results, error checking, exact values, and cell format in one place. See, you know a lot more already.
Numbers gives you dynamic methods to visualize your data. So you can spot patterns, recognize trends, and notice relationships. When you use the impressive charts, graphs, and tools, seeing becomes understanding.
Interactive charts and graphs. With a flat learning curve.
Make your data tell a story with animated charts that you control. Just drag the slider to spotlight important changes in the numbers. It’s remarkably revealing. And strikingly simple.
Highlight important data automatically.
Conditional highlighting automatically formats cells when they meet certain numerical, text, date, and duration criteria. Now critical information calls attention to itself.
Slice and dice the data. By filtering it.
Just right-click any column or open the filter panel. Numbers shows you ways to filter the data. There’s no quicker way to sort out what the numbers are saying.
Quickly focus your attention.
Press the Option key as you hover over tables to highlight just the cell you’re looking for and easily scan the related data in the same row and column.
You don’t work in just one place on just one device. The same goes for Numbers. Spreadsheets created on your Mac look exactly the same on your iPhone or iPad and vice versa. And it’s effortless to move your work from one device to another. You can even access your spreadsheets from the web, share them, and collaborate with others in real time.
Always at hand.
Now with iCloud Drive, you have a place in the cloud where you can store all kinds of files, organize them however you want, and access them from any of your devices. Put a spreadsheet in an iCloud Drive folder on one device and you’ll find it in the same folder on your other devices with your latest edits — so you never have to wonder what’s where or which is the latest version.
See it here. See it there.
With Handoff, you can seamlessly switch from Numbers on your iOS device to Numbers on your Mac and vice versa. Whatever spreadsheet you were last working on will be there waiting for you with all your latest edits. Thanks to a single file format shared by Numbers for Mac and Numbers for iOS, your spreadsheet will look the same no matter the device.
Welcome to the world wide workplace.
With iWork for iCloud, you can access all your spreadsheets from iCloud.com in any Mac or PC web browser. You can also share a spreadsheet with others and edit it together in real time — whether they’re in the next room or on the other side of the world. It’s amazing. And amazingly productive.
Learn more about iWork for iCloudNumbers makes it easy to work closely with faraway colleagues. Just click Share to send a copy of your file. Or share a link to your spreadsheet with anyone you want. You can even work on files that are stored with third-party services. And spreadsheets can be sent via services such as Gmail or Dropbox. Which means everyone sees — and works on — the same spreadsheet. How’s that for an ideal data distribution?
The ways to share your numbers just multiplied.
Quickly and easily share a link to your work via Mail, Messages, Twitter, or Facebook. So colleagues can conveniently view the shared document in any browser — even on iOS or Android. Your options are almost countless.
AirDrop. Just click Share and it’s there.
AirDrop lets you instantly and securely send your document directly to someone nearby over Wi‑Fi, without having to attach it to an email or a message.
Convert Numbers into multiple formats.
Export your spreadsheet in Microsoft Excel, PDF, CSV, or Numbers ’09 formats.
It’s easy to spread your spreadsheets around.
Teaming up with someone who uses Microsoft Excel? Numbers makes it a great working relationship. You can save Numbers spreadsheets as Excel files. Or import and edit Excel spreadsheets right in Numbers. Most popular Excel features are supported, too. Now it’s no problem to work on the same project. Even if you use different apps.
Learn more about Microsoft Excel compatibility