Top 25 Options in Excel’s Mobile App (Android & iOS)

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.

And today…

…in this post, I’m gonna share with you options which you can use to get better at Excel using your smartphone.

excel mobile app android ios tips

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:

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.

top excel tips tricks which can make you a pro this year

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.

excel mobile app android ios pre made templates

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.

excel mobile app android ios tips edit a cell

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”…

excel mobile app android ios tips to search for a option click on the bulb button

…and when you select the search result it will not navigate you to the option but…

excel mobile app android ios tips to search for a option enter words

…apply the bold font style to the selected cell.

excel mobile app android ios tips to search for a option and apply

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.

Steps:

  • 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.
excel mobile app android ios tips auto sum select the cell
  • After that, select the “Home” from the ribbon drop down and scroll down to the “Auto Sum”.
excel mobile app android ios tips auto sum click
  • In the end, select the SUM.
excel mobile app android ios tips auto sum go to home tab

This will add the SUM formula to the selected cell for the values above it.

excel mobile app android ios tips auto sum

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.

Isn’t it?

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.

For this:

  • First of all, you need to select the cell with the formula and click on the fill handle [This activates the fill handle].
excel mobile app android ios tips select the cell to use fill handle
  • After that just drag the handle down to the cell where you want to drag the formula.
excel mobile app android ios tips drag drop t o apply fill handle

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”.
excel mobile app android ios click here to add a hyperlink
  • After that, enter the text for the link at the link address.
excel mobile app android ios insert link and display text
  • 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“…

excel mobile app android ios select print from more option

…and after that select the “Air Print” if you are using iPhone.

Next, you need to specify the settings for the printing.

excel mobile app android ios print setting and then 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.

excel mobile app android ios excel mobile app android ios

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…

excel mobile app android ios click worksheet button to rename a worksheet

…double touch the tab to edit the name and then you rename it.

excel mobile app android ios enter new name to rename a worksheet

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.

excel mobile app android ios excel mobile app android ios

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.

excel mobile app android ios tips paste special

You have four ways to paste values in “Paste Special”…

  1. Format
  2. Formula
  3. Values
  4. Picture
excel mobile app android ios tips paste special options

…select one of those.

Boom!

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…

excel mobile app android ios tips undo redo click more

…there are your both of the buttons.

excel mobile app android ios tips undo redo 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”.

excel mobile app android ios tips change number format

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.

excel mobile app android ios tips select up to last cell

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.

excel mobile app android ios tips to hide unhide rows columns

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.

Conclusion

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.

Content Protection by DMCA.com
2018-11-29T17:23:53+00:00