When you have a lot of data to enter into your Excel 2013 spreadsheet, and that data consists of some type of repeatable pattern or sequence, you can save time by using AutoFill.
To use AutoFill, you select the cell or cells that already contain an example of what you want to fill and then drag the fill handle. The fill handle is the little black square in the lower-right corner of the selected cell or range.
Depending on how you use it, AutoFill can either fill the same value into every cell in the target area, or it can fill in a sequence (such as days of the month, days of the week, or a numeric sequence such as 2, 4, 6, 8). Here are the general rules for how it works:
Is it possible to open an existing Windows Power Pivot Excel on Mac? I have already created a Power Pivot Excel report on Excel 2013.
- When AutoFill recognizes the selected text as a member of one of its preset lists, such as days of the week or months of the year, it automatically increments those. For example, if the selected cell contains August, AutoFill places September in the next adjacent cell.
- When AutoFill doesn’t recognize the selected text, it fills the chosen cell with a duplicate of the selected text.
- When AutoFill is used on a single cell containing a number, it fills with a duplicate of the number.
- When Auto Fill is used on a range of two or more cells containing numbers, AutoFill attempts to determine the interval between them and continues filling using that same pattern. For example, if the two selected cells contain 2 and 4, the next adjacent cell would be filled with 6.
In the following exercise, you AutoFill cell content using two methods.
- In the Lesson 5 Mortgage file from the preceding exercise, select cell A8 and type Amortization Table.
- Type the following:
- In cell A10, type Date.
- In cell B10, type Pmt#.
- In cell A11, type January 2015.(Note that Excel automatically changes it to Jan-15.)
- In cell B11, type 1.
- Click cell A11 and move the mouse pointer over the fill handle.The mouse pointer becomes a black crosshair, as shown in this figure.
- Drag the fill handle down to cell A22.The first year of dates fill in the cells, as shown in this figure.
- Click cell B11 and drag the fill handle down to C22. The same number fills all the cells. That’s not what you want for this exercise, so press Ctrl+Z to undo the fill.
- Click cell B12, and type 2. Select B11:B12 and then drag the fill handle down to cell B22.The figure shows the completed series.
- Select A22:B22 and drag the fill handle down to B190.Both series are filled in, down to row 190, where the date is December 2029 and the payment number is 180.Here you do Step 7 because the number of periods for this loan is 180 (see cell C5), so the number of payments should be 180 in the amortization table.
- Press Ctrl+Home to return to the top of the worksheet.
- Click the Save button on the Quick Access toolbar to save the changes to the workbook.
- Choose File→Close to close the workbook.
From the headline, Microsoft Won’t Bring Office 2013 to Mac, but It Will Add SkyDrive Integration to Office 2011, you’d think that Microsoft was sticking it to Mac users. And from reading the article by Killian Bell, you’d never know that Mac users currently have a newer version of Office than Windows users – or that Microsoft has a long history of releasing new Office for Mac editions a year after every Windows version since 1997.
Macs Had It First
Microsoft Office has three core components: Microsoft Word, Excel, and PowerPoint.
WYSIWYG Word
Microsoft Word was initially developed for Xenix (Microsoft’s version of Unix) and MS-DOS and introduced in 1983. From the start, it was designed to be used with a mouse. Word was ported to the Mac and shipped in 1985; the first WYSIWYG version of Word included support for the Mac’s fonts. Word didn’t get that on the PC side until 1989, when Microsoft introduced Word for Windows.
WYSIWYG Spreadsheet
Microsoft’s first spreadsheet was MultiPlan, introduced in 1982 for practically every personal computing platform. But the following year, Lotus introduced 1-2-3 for DOS, which almost immediately became the top spreadsheet choice on the IBM platform. In 1984, MultiPlan was introduced with the Macintosh, where it quickly became the dominant spreadsheet program.
The first version of Excel arrived in 1985 – and it arrived on the Mac. It wasn’t until 1987 that Excel came to Windows.
PowerPoint
PowerPoint was originally designed for Macs under the name Presenter. Introduced in early 1987, Microsoft bought the company that created it in August 1987. PowerPoint didn’t come to Windows until May 22, 1990, the same day Windows 3.0 was launched.
Microsoft Office
The first version of Microsoft Office wasn’t for Microsoft’s Windows operating system. It was a suite of programs for Mac users. Introduced in 1989, Office for Mac included Word 4.0, Excel 2.2, PowerPoint 2.01, and Mail 1.37. Office arrived for Windows in Late 1990, and the first version didn’t even have an email client.
In short, the Mac was the first platform with a WYSIWYG version of Word, the first with a WYSIWYG spreadsheet, the first to get Excel, and the platform PowerPoint was developed for. Also, Office for Mac included an email client long before Office for Windows.
Microsoft Office History
Office 1.5 arrived in 1991, replacing Excel 3.0 with version 4.0, and version 1.6 was the first to include an email client for Windows PCs.
In 1992, Microsoft released Office 3.0 in separate Windows and Mac versions. Both editions had Excel 4.0 and PowerPoint 3.0. Word for Windows 2.0 was part of the PC bundle, while Macs had Word 5.0. In the future, Microsoft would sync Word version numbers.
Office for Windows 4.0 arrived in 1994, followed by Office for Windows NT 4.2 and Office 4.2 for Mac. These all included Word 6, Excel 4, and PowerPoint 4, although Word 6 for Mac was so poorly received that Microsoft reintroduced Word 5.1 to keep Mac users from defecting.
From this point forward, Mac and Windows versions of Microsoft Office would never again share version numbers.
- Office 95 arrived with Windows 95 in August 1995, followed by Office 97 two years later.
- Office 98 was the Mac version, released in 1998 (as though you hadn’t guessed).
- Office 2000 was for Windows, and 2001 (released in Late 2000) was for Macs.
- Office v. X, the first Mac OS X edition, also arrived in 2001.
- Office XP came in 2002, followed by Office 2003, also for Windows. And then came Office 2004 for Macs (the newest version here at Low End Mac).
- Office 2007 was for Windows, 2008 for Macs, 2010 for Windows, and the current 2011 for Macs.
And that’s where we stand today. Since 2001, the Mac version of Microsoft Office has always come a year after the PC version (excepting Office XP), and today Mac users have a version of Office that’s newer than Windows users have.
Don’t Panic
No, we’re not going to see Microsoft Office 2013 for Mac. That’s the Windows version. Based on history, we should not expect Office 2013 for Mac – which is why I have problem with the seemingly panic-stricken Cult of Mac headline.
We’ll have to wait for Microsoft Office 2014 to bring all the new Office goodness to the Mac (and perhaps iOS as well). This gives Microsoft’s Mac development team time to integrated the new Windows features and workflows to the Mac, which needs to be done so it will be a Mac software suite and not a horrible Windows port like Word 6.0 was.
We should be grateful that Office 2011 users will get SkyDrive integration, making it easy to put documents in the cloud for access from other computers, but there’s no need to panic about not getting Office 2013, because we’ll have something even better in 2014.
Keywords: #office2013 #macoffice2013 #nomacoffice2013 #dontpanic #office2014 #macoffice2014 #microsoftoffice2014
Short link: http://goo.gl/yuvDnr
searchword: nomacoffice2013, dontpanic