Take your data intensive spreadsheets with you and work from anywhere. With Excel for Android, your team will think you’re working at your desktop. Show
Here’s a list of 12 useful tips for Microsoft Excel for Android. Add these tasks to your resume of spreadsheet skills and you’ll be the coolest Excel mobile user on your team. Note: The following directions apply to Excel for Android on phones and tablets. Type Text with EaseEntering text in a spreadsheet cell is a bit different in Excel for Android. Those familiar keystroke you use in Excel on your desktop will need a bit of an adjustment when you make the switch to your mobile device. Here are a few typing tips:
Tip: If you use an external keyboard with the Excel app, the keyboard shortcuts you use with Excel for Windows will work on your Android device. Type Multiple Lines of Text in a CellIt's possible to create multiple lines or paragraphs inside a cell, but, unlike Excel on your desktop, you’ll have a few more keys to press. To create multiple paragraphs in a cell:
Note: There are many ways to move around in Excel for Android. Learn the Android touch gestures for Excel for Android to take full advantage of the app. Add Numbers QuicklyWhen you want to add a row or column of numbers, use AutoSum to get the job done quickly. To add numbers, tap and drag to select the cells in the row or column you want to add together. Then, tap Formulas > AutoSum > Sum to display the total at the end of the row or column. Tip: If you’re having problems selecting a large section of data, tap Home > Select Range and type the range of cells you want. Use Filters to Sort DataWhen you want to organize your data, sort the data with filters. Filters allow you to sort data in alphabetical or numerical order. To display the Filter Buttons, tap Home > Filter > Show Filter Buttons. The Filter Buttons appear in the top row of the spreadsheet. To filter a spreadsheet, tap a Filter Button for the column you want to sort and choose a sort option. Draw on a SpreadsheetThe touchscreen on your Android phone or tablet makes it easy to draw on a spreadsheet and highlight important information. All it takes is a swipe of the finger to draw lines, circles, and other shapes. To access the drawing tools:
Use Your Camera with ExcelYou can use your camera to insert pictures directly into your Excel spreadsheet. To take a picture, tap the place in the spreadsheet where you want the photo to be, then tap Insert > Pictures > Camera. When you have the perfect picture, select OK and it will appear in the spreadsheet. Tip: Use the Picture tab to add styles and effects, resize the image, and crop out unwanted parts of the picture. Turn Data into a PictureThere are several ways to protect your data from changes. An easy way is to turn it into a picture that can't be edited. It’s as easy as copying the data and pasting it somewhere else in your spreadsheet as a picture. To turn data into a picture:
Tip: Do you have a printed spreadsheet or table you want to input into Excel? Take a photo of it and crop the picture so only the data appears. Excel converts the picture into text and adds it to your spreadsheet. Get Research HelpYou don’t have to leave the Excel app for Android when you need to do some research. Finding information, definitions, history, and other resources is simple when you use Smart Lookup. To use Smart Lookup:
Add Comments to a SpreadsheetYou and your team are working on a data project. When you want to ask questions about the spreadsheet data, add a comment. To make a comment:
Tip: To view a comment, tap the comment icon on the spreadsheet area. Tap Close when you’re done reading the comment. When you want others to view or edit your Excel workbook, share it with them. To share a workbook, tap Share, enter the email addresses of the people you want to share the file with, and choose a sharing option:
Get Help Creating ChartsYou’ve got data and you want to visualize it, but where do you begin? When you need help creating charts, use the recommended charts to find the best way to chart your data. To let the Excel app choose a chart for you that best represents your data:
Tip: When you select a chart, the Chart tab appears. Use these options to change the layout, color, size, and other attributes of your chart. Create a Map with Your DataWhen you have geographical data, use a map to show comparisons. To create a map chart:
Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Can you download Excel on an Android tablet?You can get all of the Microsoft Office suite apps on an Android device through the Google Play Store. Microsoft offers two ways to get the Office suite on Android — you can install the new integrated Office app or you can install separate apps for Word, Excel, PowerPoint, and OneNote.
Is Excel free on Android tablet?The Android app for Excel spreadsheet is free for non-business and requires a free Microsoft Outlook email account. Excel for Android contains the most used features of Excel. But that doesn't mean it's a watered-down version.
Can you put Excel on a tablet?Excel for Android tablet is very similar to the Excel you already know. But there are some differences if you are used to using a mouse and keyboard. This video will show you how to get up and running.
How can I get Excel on my Android?Excel for Android phones is a free download from Google Play.
|