You can create and modify charts in iOS, but you won't find all the formatting options that let you fine-tune the visual design you get in the desktop version. For example, you can add sparklines-Excel's miniature one-cell charts-in Excel on your desktop and view them in iOS, but you can't create or modify them in iOS. (Opens in a new window) Read Our Microsoft Excel 2013 Reviewīut don't be misled into thinking the iOS version can do all the similar tricks that the desktop version can-for example, you might expect to use the same autofill option that lets you combine two columns of text (first and last names, for example) into a single column, but that works only on the desktop version.Įverything that you can see in a worksheet when you open it on a desktop or laptop is also visible when you open the worksheet in iOS, but under iOS you're limited in what you can modify. Tap on Fill, and you can then drag the selection down or to the right to fill in as many additional years as you need. Autofill is one example: if you select two cells containing the years 20, a pop-up menu offers an option to Fill, in addition to the usual pop-up items like Copy and Clear. Once you're comfortable with it, you'll begin to find nifty features that duplicate desktop-style features in the iOS interface. When you first try out Excel for iOS, I strongly suggest that you spend some time with a spreadsheet that you don't need to preserve, because you're almost guaranteed to delete the contents of a cell or column while you get the hang of swiping your way around the screen. An Add-Ins button lets you install add-ins from approved vendors, including histograms and functions for live stock-price updates. If you select a range of data, a Recommended button suggests an appropriate chart type. The Insert tab, for example, lets you insert a table, pictures from a file or the tablet's camera, prebuilt shapes, a text box, chart, or comment. Since 1982, PCMag has tested and rated thousands of products to help you make better buying decisions. ( Read our editorial mission (Opens in a new window) & see how we test (Opens in a new window).)Īs in the rest of the Office ($799.00 at ) (Opens in a new window) apps on the iPad, the tabbed interface offers a well-chosen feature set. A spacious screen like the one on the iPad Pro makes it easy to see a large amount of data smaller screens like the one on the smaller iPads and iPad mini tend to feel cramped. You can work with multiple tabs, select data to create a chart, and build formulas either by typing them in or by selecting functions from drop-down menus. Įxcel looks gorgeous on iOS, and its subset of features seems well chosen for the kind of work that it makes sense to do on a tablet. But Excel for iPad does a surprisingly good job of reducing the risk, especially when you work on a high-powered tablet like the iPad Pro ($799.00 at ) (Opens in a new window) with its Smart Keyboard ($799.00 at ) (Opens in a new window). A phone or tablet sounds, therefore, like a dangerous place to edit a spreadsheet containing anything more serious than your to-do list or cake recipes. In a worksheet, an input error could bankrupt your company or destroy your scientific results. When you work on a spreadsheet, it's not using like a word processor, in which you can make a typing error and your meaning will (probably) still be clear. The most impressive thing about the Excel iPad app isn't any one particular feature-it's the fact that it exists at all. Some features (such as sparklines) can be viewed but not created.How to Set Up Two-Factor Authentication.How to Record the Screen on Your Windows PC or Mac.How to Convert YouTube Videos to MP3 Files.How to Save Money on Your Cell Phone Bill. How to Free Up Space on Your iPhone or iPad.How to Block Robotexts and Spam Messages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |