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. 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. 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. 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. 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. To access the drawing tools: 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. 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. To use Smart Lookup: 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. 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.
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. To create a map chart:
