Excel 2.0 is the first version of Excel for the Intel platform. Versions prior to 2.0 were only available on the Apple Macintosh. Excel 2.0 (1987) The first Windows version was labeled '2' to correspond to the Mac version. This included a run-time version of Windows.
What's Hot at TechRepublic. Mac users can access the early version of 64-bit Office applications (Word, Excel, PowerPoint, OneNote, and Outlook for Mac). To sign up for the Office Insider Program, follow these steps. Open Microsoft AutoUpdate by opening a Mac Office 2016 32-bit application, clicking Help, and selecting Check For Updates. Select the Join The Office Insider Program To Get Early Access To New Releases checkbox within Microsoft's AutoUpdate window ( Figure C).
Elect to receive Fast Insider Builds. Accept the Office Insider Program terms. You should be able to access the 64-bit Office for Mac applications.
Downloading and installing the 64-bit versions required only 15 minutes or so on my office network and MacBook Air. Image: Erik Eckel/TechRepublic SEE: (Tech Pro Research) My test results In my immediate tests, the 64-bit versions of Word and Excel appear to open about a second more quickly than their 32-bit predecessors (four seconds vs. Five), while Outlook seems to open equally fast, but my tests weren't conducted in an isolated laboratory, double-blind tested, or reviewed by a panel of peers. The Office apps already performed very well, in my experience, thanks in part to OS X's advances improving CPU performance and managing RAM. And, I don't rely upon third-party plug-ins, which can pose some potential incompatibilities with the 64-bit apps.
So my experiences using the 64-bit version are essentially identical to those using the 32-bit counterparts. But you can bet additional functionality, new features, smoother app integration, and improved overall performance are coming, thanks to the 64-bit upgrade.
Create gorgeous spreadsheets with Numbers for Mac. Get started with one of many Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more. Add tables, charts, text, and images anywhere on the free-form canvas. As soon as you start typing a formula, you'll get instant suggestions and built-in help for the over 250 powerful functions.
Animate your data with new interactive column, bar, scatter, and bubble charts. Easily filter through large tables. Automatically format cells based on numbers, text, dates, and durations with new conditional highlighting.
And with an all-new calculation engine, Numbers is faster than ever before. With iCloud built in, your spreadsheets are kept up to date across all your devices. And with real-time collaboration, your team will be able to work together at the same time on a Mac, iPad, iPhone, or iPod touch — even on a PC using iWork for iCloud.
Use Smart Categories to quickly organize and summarize tables to gain new insights. Group your data based on unique values and date ranges, including day of week, day, week, month, quarter, and year. Instantly show count, subtotal, average, maximum, and minimum values for columns in each group. Create charts of your summarized data. Easily reorder categories to see your data in a different way. Support for Dark Mode gives Numbers a dramatic dark look. Toolbars and menus recede into the background so you can focus on your content.
Requires macOS Mojave. Support for Continuity Camera allows you to take a photo or scan a document with your iPhone and have it automatically appear in your spreadsheet on your Mac. Requires macOS Mojave and iOS 12. Easily record, edit, and play audio right in a spreadsheet. Enhance your spreadsheets with a variety of new editable shapes. Performance and stability improvements.
5.1 Jun 14, 2018. Collaborate in real time on spreadsheets stored in Box. Requires macOS High Sierra. Use donut charts to visualize data in an engaging new way. Add an interactive image gallery to view a collection of photos.
Enhance spreadsheets with a variety of new editable shapes. Improved, customizable import of CSV and text data, with support for custom delimiters and fixed-width files. Additional options for reducing the file size of spreadsheets. Full bidirectional support for Arabic and Hebrew. 4.3.1 Nov 9, 2017.
Easily add current or historical stock information to spreadsheets. Use the new My Stocks template to easily track your portfolio. Quickly open password-protected spreadsheets using Touch ID on the new MacBook Pro with Touch Bar. New leader lines make pie charts easier to read.
Easily replace fonts throughout an entire spreadsheet. While collaborating on a spreadsheet, you can now cut, copy, paste, and duplicate sheets. Customize dates, times, and currencies for your language or region. 4.0.5 Oct 27, 2016. All-new design inspired by OS X Yosemite. Instantly switch between iPad, Mac and iPhone with Handoff. Support for iCloud Drive.
Updated file format makes it easier to send spreadsheets via services like Gmail and Dropbox. Instantly rearrange data in tables with new transpose feature. Inter-table alignment guides.
Improved cell border styling. Print floating comments. Usability improvements for resizing and positioning charts.
Improved bi-directional language support. 3.2.2 Aug 21, 2014. Sort by multiple columns.
Sort a subset of rows. Text autocompletes when editing cells. Chart date and duration values. Optionally highlight rows and columns on mouseover. Progress indicator for calculations. Custom number formats in charts are preserved on import of Numbers ’09 and Microsoft Excel spreadsheets.
Share password-protected spreadsheets via iCloud link. Export password-protected spreadsheets to XLSX format. Improvements to AppleScript support. Improved compatibility with Microsoft Excel 2013 spreadsheets. Bug fixes and stability improvements. 3.0.1 Nov 21, 2013.
This update includes the features listed below. To use these features, update your Mac to OS X Mountain Lion. iCloud: Store spreadsheets in iCloud and keep them automatically up to date across your Mac, iPad., iPhone., iPod touch., and the web. Changes made to a spreadsheet on one device automatically appear on all your other devices. Dictation: Speak words, numbers, or sentences and watch them appear in your spreadsheet. Numbers 2.2 is also enhanced to take advantage of the Retina display on the new MacBook Pro so spreadsheets appear sharper and more vibrant.
Requires Numbers 1.6.1 or later installed on iOS device. Blue Buckeye, Lock Cells and Opt to Show Reference Cells Please So glad you brought Categories back. Terribly inconvenienced by their absence since iCloud Drive came onboard.
I’ve had to continue using Numbers from iWork’09 and reconstruct scores of them after misguidedly moving them from Dropbox to iCloud Drive and then back again after realizing a hidden suffix was added to the filename extension by iCloud (or by Numbers5?). This last insult rendered my files unopenable except in Numbers 5, wherein the Categories and their subtotals were unceremoniously deleted. (I don’t know yet whether the ’09 files will now open in one piece in v5.3, will they?). Also helped by your improved import of CSV formatted alphanumeric data. Meanwhile, three features common in other spreadsheet apps I greatly need in Numbers as a power user are to be able to 1) Lock individual or groups of cells; 2) Show Linked Cells, by that I mean being able to CtlClick in a cell, for example, to wee what other cell(s) reference it in it's formula.
It is an excessive time-waster at best to accidentally overwrite a formula or to invalidate a necessary input to another cell; and 3) Pivot Table, that is to be able to switch Rows to Columns. Very helpful in analyzing downloaded tables from various accounts. Blue Buckeye, Lock Cells and Opt to Show Reference Cells Please So glad you brought Categories back. Terribly inconvenienced by their absence since iCloud Drive came onboard. I’ve had to continue using Numbers from iWork’09 and reconstruct scores of them after misguidedly moving them from Dropbox to iCloud Drive and then back again after realizing a hidden suffix was added to the filename extension by iCloud (or by Numbers5?). This last insult rendered my files unopenable except in Numbers 5, wherein the Categories and their subtotals were unceremoniously deleted. (I don’t know yet whether the ’09 files will now open in one piece in v5.3, will they?).
Also helped by your improved import of CSV formatted alphanumeric data. Meanwhile, three features common in other spreadsheet apps I greatly need in Numbers as a power user are to be able to 1) Lock individual or groups of cells; 2) Show Linked Cells, by that I mean being able to CtlClick in a cell, for example, to wee what other cell(s) reference it in it's formula. It is an excessive time-waster at best to accidentally overwrite a formula or to invalidate a necessary input to another cell; and 3) Pivot Table, that is to be able to switch Rows to Columns. Very helpful in analyzing downloaded tables from various accounts. Sharonthoms, Thank goodness! A spreadsheet I can use!
After spending considerable money on several budgeting apps which turned out to be far too complicated for me to use and which didn’t really fit into my daily work habits, I decided to go into do-it-yourself mode. What I needed was an easy-to-use basic budget where I could get a general overview of my income and expenses as well as keep more detailed records of my expenditures and also make balance sheets for my daily expenses and bank and credit card accounts. Numbers came to the rescue with one of their templates called “Simple Budget'! It took a little bit of doing, as I am no genius and certainly no expert when it comes to accounting and using spreadsheets, but Numbers made it easy for me to organize the information I needed and to make the calculations required as well as transfer information from one sheet to another to keep information consistent over a number of spreadsheets.
I was also able to make beautiful pie charts of my expenses as well as color-code my columns and headers. Numbers is a beautiful application I now couldn’t live without. Sharonthoms, Thank goodness! A spreadsheet I can use! After spending considerable money on several budgeting apps which turned out to be far too complicated for me to use and which didn’t really fit into my daily work habits, I decided to go into do-it-yourself mode. What I needed was an easy-to-use basic budget where I could get a general overview of my income and expenses as well as keep more detailed records of my expenditures and also make balance sheets for my daily expenses and bank and credit card accounts. Numbers came to the rescue with one of their templates called “Simple Budget'!
It took a little bit of doing, as I am no genius and certainly no expert when it comes to accounting and using spreadsheets, but Numbers made it easy for me to organize the information I needed and to make the calculations required as well as transfer information from one sheet to another to keep information consistent over a number of spreadsheets. I was also able to make beautiful pie charts of my expenses as well as color-code my columns and headers. Numbers is a beautiful application I now couldn’t live without.
Razortron, Great visually, needs help technically I use this to help with my small business. I use it for inventories, food orders etc. It is perfect if I am the only one using it and understand where to put data and where not to.
I have made spreadsheets for other business owners and they have all come back with the same complaint. We would like a way to lock/protect specific cells with out having to create multiple seperate table and then lock them individually. While this is an ok option, it is not the most efficient way to do things. If we could get a way to lock/protect specific cells it would make things MUCH easier. All the hard work making the formulas could not be cleared out by a simple mistake from anyone else using the spreadsheet, i.e. My employees. Apple seems to be focusing more on the visual aspects of what you can do with Numbers and not on the people that use Numbers for data collection and manipulation for results that don’t need to be in graphic or any visual form.
I LOVE that Numbers is free, if we could just lock/protect individual cells I think it would be perfect!!! Razortron, Great visually, needs help technically I use this to help with my small business. I use it for inventories, food orders etc. It is perfect if I am the only one using it and understand where to put data and where not to. I have made spreadsheets for other business owners and they have all come back with the same complaint. We would like a way to lock/protect specific cells with out having to create multiple seperate table and then lock them individually.
While this is an ok option, it is not the most efficient way to do things. If we could get a way to lock/protect specific cells it would make things MUCH easier.
All the hard work making the formulas could not be cleared out by a simple mistake from anyone else using the spreadsheet, i.e. My employees. Apple seems to be focusing more on the visual aspects of what you can do with Numbers and not on the people that use Numbers for data collection and manipulation for results that don’t need to be in graphic or any visual form. I LOVE that Numbers is free, if we could just lock/protect individual cells I think it would be perfect!!!