If you are reading this right now...
...I’m sure you haven't explored Excel’s Mobile App that much...
...or, you haven’t heard about it.
Am I right?
Say “Yes” in the comment section if you are one of those people.
If you have this question in mind that why I need to have the Excel’s Mobile app in my smartphone.
Well, let me remind you, Excel is not a spreadsheet program anymore, it’s a medium to view, store, use and, analyze data.
So, it’s MUST to have it in all the devices.
…in this post, I’m gonna share with you options which you can use to get better at Excel using your smartphone.
25 Things You Can Do with Excel’s Mobile App [Android & iOS]
Below is the list of the options which you can use in Excel’s Mobile App:
- Pre-Made Templates to Capture Data
- Double Touch to Edit
- Search for an Option ?
- AUTO Sum Values
- Fill Handle
- Switch Between Qwerty and Numeric Keyboards
- Sort & Filter Data
- Find & Replace
- Status Bar Analysis ?
- Save a Workbook as a PDF
- Zoom In and Zoom Out
- Yes, You Can Draw in Excel
- Directly Add Pictures from Your Camera
- Add Comment on Cells
- Send Workbook in an Email
- Create a Hyperlink
- Change Print Settings
- All the Functions are here ?
- Rename a Worksheet
- Create a Chart in Single Touch
- Thank-you Excel for the Paste Special Option ?
- Undo Redo Buttons
- Apply/Change Number Formatting
- Select up to the Last Cell
- Hide/Un-Hide Columns and Rows
Quick Tip: Once you start exploring Excel’s mobile app you’ll find that it’s so awesome to use it and, you can also suggest a feature which you think can be useful all the users.
1. Pre-Made Templates to Capture Data
Just like Excel’s desktop app, you have pre-made templates which you can use to track your data straight from your smart phone.
There are more than 10 templates which you can use and open with a single touch.
And after that you can save a template in your smart phone, in OneDrive, or send it to someone in a email.
2. Double Touch to Edit
In Excel’s desktop app, you need to double click to edit a cell…
…and in the mobile app, you need a double touch to edit a cell.
Once you double touch on a cell your keyboard will get activated. You can enter data with by simply typing or you can enter a function by typing “=” sign.
And once you are done with editing a cell touch the “OK” button from the top right side of the screen…
…or, if you want to cancel editing touch the cancel button.
3. Search for an Option
This is my favorite option.
Let’s say you don’t know which option is where in the app or you aren't sure if the option you want to use is there in the app.
You can simply search for the option from the search bar.
Now here's the best thing:
Let’s say you are searching for the option “Bold”…
…and when you select the search result it will not navigate you to the option but…
…apply the bold font style to the selected cell.
4. AUTO Sum Values
In Excel’s mobile app, there is a simple option to apply AUTO sum for the numbers you want to sum.
- First of all, select the next cell from the last cell where you have values and click on the more button from the bottom right corner of the screen.
- After that, select the “Home” from the ribbon drop down and scroll down to the “Auto Sum”.
- In the end, select the SUM.
This will add the SUM formula to the selected cell for the values above it.
If you see, there are other options as well, like Average, Count Numbers, Max, and Min which you can use.
5. Fill Handle
I’m sure you use fill handle in your work a lot.
Let me tell you how you can use fill handle in Excel’s mobile app.
Don’t miss this thing, it’s DAMN useful.
If you look at the below example I have entered the “RANDBETWEEN to get a random number…
…but now I want to drag this formula to the cell below.
- First of all, you need to select the cell with the formula and click on the fill handle [This activates the fill handle].
- After that just drag the handle down to the cell where you want to drag the formula.
Boom! that’s it.
6. Switch Between Qwerty and Numeric Keyboards
f you are like me can’t work without “Numeric Keypad” and must have it in the mobile app as well.
Excel’s mobile app is loaded with it.
You can simply switch between the normal qwerty keyboard and numeric keyboard using the switch button.
7. Sort and Filter Data
In the mobile app, you have a simple way to sort & filter data.
All you need to do is go to the more button and open the “Sort & Filter Data” option by scrolling down.
Here you have the option to sort data in Ascending or descending order
...and for the applying filters, you can simply click on the “Show Filter Buttons”.
8. Find and Replace
This one most useful options from all the tips we have here.
You can simply find and replace a value by using this option as we use in our desktop app.
To use the “Find & Replace” option all you need to do is go to more button…
…and scroll to the end in the “Home Tab” and open the “Find”.
The moment you open it you'll get a search bar at the top where you can type a value and find it.
To replace a value you can open the option from the gear icon from the left and select “Replace”.
There are also some advanced options which you can use here.
9. Status Bar Analysis
Yes, Excel’s mobile app has a status bar. The moment you select a range of cells…
…it appears on the top of the app’s screen with some basic calculations…
…like sum, average count, the numbers count, etc.
10. Save a Workbook as a PDF
You can directly create a PDF version of your workbook.
- First of all, click on the more options button from the top of the app’s screen.
- After that, go to “Export” and click on “PDF”.
- Next, you need to select the orientation and specify which part you want to export as a pdf.
- In the end, name the file and export it.
Excel saves the pdf file at the same place where your original file is stored.
11. Zoom In and Zoom Out
Well, maybe you don’t use zoom in and zoom out option but this can be useful in your smartphone…
…as you have a limited screen (poor me with iPhone SE ).
To use this option all you need to do is touch the more button from the bottom right of the app…
…and select the view tab and then…
…scroll down a bit and there you have “Zoom In” and “Zoom Out”.
12. Yes, you Can Draw in Excel
There is a simple option in the app which you can use to draw in a worksheet.
For this, select the “Draw tab” from the drop-down and there you have the option to draw.
This option gives you multiple options to draw, you can change color + you have other options.
13. Directly Add Pictures from Your Camera
If you want to click a picture using your camera and want to add it to your Excel worksheet.
You have a simple option for this.
All you need to do is, go to “Insert Tab” and select the camera option which opens the camera of your phone…
…and you can click and insert it into the worksheet.
+ when you insert a picture you have the same options to customize it as you do in Excel’s desktop app like adding borders.
14. Add Comment on Cells
Let’s say you need to review some data and need to send it further to someone.
The option to add comments can be helpful for you.
You just need to select the cell where you want to add it and go to the review tab.
And from the “Review Tab”, select the comment to add a new comment.
Every cell where you have a comment will have a red color indicator at the top right edge.
15. Send Workbook in an Email
Sending a workbook in an email is pretty simple from your smartphone Excel app.
All you need to click on “More Button” from the top left…
…and after that select “Send the Copy”.
Select the format to send and the app to use for sending the email.
16. Create a Hyperlink
Excel’s mobile app is quite smart when it comes to adding hyperlinks.
You can add a link to the cell in the existing workbook or worksheet’s cell or to a web address.
All you need to do is…
- Go to the “Insert Tab” and select the “Link”.
- After that, enter the text for the link at the link address.
- In the end, click “Done”.
To add a link another worksheet you need to enter the name of the worksheet before the cell address.
17. Change Print Settings
Yes, you can print from your Excel’s mobile app. There’s an option to do this.
For this, you need to open print setting from the more button…
…go to ‘Print“…
…and after that select the “Air Print” if you are using iPhone.
Next, you need to specify the settings for the printing.
In the ned, click “Next” to get a print.
18. All the Functions are here
All the function which require to use in your daily life, you can use in Excel’s mobile app.
There’s a separate tab for all the functions.
Yes, in the "Formula Tab", you can find all the function you need.
19. Rename a Worksheet
Before you rename a worksheet you need to activate the worksheet tab…
…and for this, touch the worksheet button from the bottom left of the screen and…
…double touch the tab to edit the name and then you rename it.
20. Create a Chart in Single Touch
O Boy! I love this thing.
You just need a single touch to create a chart from your smartphone.
In the “Insert Tab”, there are all the charts as you have in the Excel’s desktop app.
Make sure select the data before you insert a chart.
21. Thank-you Excel for the Paste Special Option
I really want to thanks Excel team to make “Paste Special” option available in the mobile app.
To use this option all you need to do is to copy a cell and go to the cell where you need to paste the value.
Make sure before you paste just select the cell and hold your touch…
…and you’ll get options, click of the right arrow to go to paste special options.
You have four ways to paste values in “Paste Special”…
…select one of those.
22. Undo Redo Buttons
Undo and Redo buttons are simply there for you. Just open the options from the more button from the bottom right of the screen…
…there are your both of the buttons.
23. Apply/Change Number Formatting
Yes, you can change number format from a cell as you do in desktop Excel.
For this, all you need to do is select a cell or a range…
…open the ribbon from the more button at the bottom of the screen and scroll down in the “Home Tab”.
Select the “Number Format” and there you all the format which you can apply to the cell or range.
24. Select up to the Last Cell
As we use a keyboard shortcut in the desktop app to select the data up to the last cell…
…mobile app there an option button for this.
Select the first cell of the data and touch the button from the bottom menu.
25. Hide/Un-Hide Columns and Rows
The moment you select an entire row or a column from it’s heading you get options…
…in those options there’s an option to hide the selected row or column.
You can hide multiple rows or columns by selecting all of them.
To un-hide a column all you need to do is select the rows or columns around the hidden column or row…
…and select the unhide option.
The biggest reason to use Excel’s smartphone app is you can view, edit, share and, create charts from the phone directly...
…and you are must aware if the option to do these things.
That’s why I have listed them here for you…
…and I hope you found this post worth reading.
But now, you need to tell me one thing.
Are you going to Install Excel's Mobile App?
Make sure to share your views with me in the comment section, I'd love to hear from you. And please, don’t forget to share this post with your friends, I am sure they will appreciate it.
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.