But if you switch to the desktop-style Spreadsheet View, you’ll find many of the controls inoperable, and even something as ordinary as selecting a range of cells might prove impossible. With the mobile version of Google Spreadsheets (the default view on an iPad), you can do only the basics-edit cell values, add rows, and change sort orders. Moreover, editing spreadsheets once they’re converted is problematic.

Although you can upload nearly any format file to Google Docs, if you want to edit spreadsheets online, you must let Google Docs convert them to its own format as with Numbers, that may entail a considerable loss of formatting-and in cases where formulas differ between Excel and Google Spreadsheets, calculations may change. All of this would seem to be a natural fit for the iPad, too. Many businesses have standardized on Google Docs because it’s a convenient platform that requires no software beyond a Web browser, provides automatic backups and versioning, and makes sharing files with co-workers easy. But if maintaining fidelity with original formatting is your top priority when working with Excel documents on an iPad, you’ll want to look for another solution.Īnother approach is to rely on Google Docs, Google’s free Web-based office suite. So, if you’re content to keep your Excel spreadsheets in Numbers format once they’re imported-or give up any unsupported formatting-Numbers is arguably your best choice. xlsx) or export a Numbers file in an Excel format, you permanently lose essential formatting, tracked changes, comments, and other file attributes. Unfortunately, when you import a file in Microsoft Excel format (.xls or.

Numbers has a full-featured, touch-optimized interface that includes a special keyboard with numeric keypad and other special keys.Īs long as you’re running OS X 10.8 Mountain Lion, using the latest version of Numbers for Mac and iOS, and have an Apple iCloud account, transferring documents between a given app on your Mac(s) and iOS device(s) is simple thanks to iCloud’s Documents in the Cloud feature.

How to enable editing in excel on ippad