Software & Apps Apps The 12 Best Tips for Using Excel for Android in 2020 Your spreadsheet on-the-go offers nifty AI capabilities plus other cool features by Coletta Teske Writer Coletta Teske is a Lifewire writer focusing on consumer electronics. She has 30 years' experience writing for Adobe, Boeing, Microsoft, and many others. our editorial process Twitter LinkedIn Coletta Teske Updated on January 02, 2020 PeopleImages/Getty Images Apps Best Apps Tweet Share Email 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. 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. 01 of 12 Type Text with Ease Entering 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: Type text: Double tap a cell, type your text, then tap the green check mark. After you’re done typing, tap Enter to move to the cell below.Delete text in a cell: Tap a cell and hold to display a context men, then tap Clear.Edit text in a cell: Double tap the cell containing the text to display the blue cursor. Tap and drag the cursor where you want it and make your changes. 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. 02 of 12 Type Multiple Lines of Text in a Cell It'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: Double tap a cell and begin typing.Tap the cell to display the blue cursor.Tap the cursor, then tap New line.Continue typing.Tap the green check mark when you’re done. 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. 03 of 12 Add Numbers Quickly When 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. 04 of 12 Use Filters to Sort Data When 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. 05 of 12 Draw on a Spreadsheet The 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: Select Draw > Draw with Mouse or Touch.Select a color and a thickness.After you’ve made your selection, tap the spreadsheet and drag to draw. 06 of 12 Use Your Camera with Excel You 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. 07 of 12 Turn Data into a Picture There 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: Select the data.On the context menu that appears, tap Copy.Tap and hold on the cell where you want to paste the image.On the context menu, tap the down arrow next to Paste and tap 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. 08 of 12 Get Research Help You 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: Select a word or phrase.Tap Review > Smart Lookup. This displays the Smart Lookup pane and shows the top web searches.Scroll through the list to find a search result matching your research needs.Tap More to read the rest of the information. 09 of 12 Add Comments to a Spreadsheet You 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: Tap the cell where you want to leave a comment.Tap Insert > Comment to display the Comment pane.Type the text for your comment.Select a blank area of the worksheet when you’re finished. Tip: To view a comment, tap the comment icon on the spreadsheet area. Tap Close when you’re done reading the comment. 10 of 12 Share an Excel Workbook with Others 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: Share as a link: Choose this method to send the link in an email message, copy to the clipboard, or insert into OneNote. You control which people can view or edit the workbook.Share as attachment: Choose this method to attach the file to an email message. You can share the file as an Excel workbook or as a PDF file. 11 of 12 Get Help Creating Charts You’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: Select the data you want to use for the chart.Tap Insert > Recommended. You’ll see a selection of charts that fit your data.Tap a recommended chart to see it in your worksheet. 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. 12 of 12 Create a Map with Your Data When you have geographical data, use a map to show comparisons. To create a map chart: Select the data you want included in the chart.Tap Insert > Chart > Maps.Tap the map chart that appears in the drop-down list.Tap I agree if this is the first time you’ve created a map.From the Chart tab, customize the chart by changing the chart title, color, or style.