How To Use Excel On Android Phone

Peak 25 tips to apply excel app on mobile effectively (Android & iOS)

11/20/2019

Below is the list of the options which yous tin utilise in Excel's Mobile App:

Pre-Made Templates to Capture Data
Double Touch to Edit
Search for an Option
Automobile Sum Values
Fill Handle
Switch Between Qwerty and Numeric Keyboards
Sort & Filter Information
Find & Replace
View Status Bar Analysis
Salvage a Workbook as a PDF
Zoom In and Zoom Out
Draw in Excel
Straight Add Pictures from Your Photographic camera
Add Annotate on Cells
Ship Workbook in an E-mail
Create a Hyperlink
Modify Print Settings
View all the Functions
Rename a Worksheet
Create a Chart in Single Bear on
How to employ Paste Special Selection
Undo Redo Buttons
Apply/Modify Number Formatting
Select upwardly to the Last Cell
Hide/Un-Hide Columns and Rows

1. Pre-Made Templates to Capture Data

1. Pre-Fabricated Templates to Capture Information

Just like Excel's desktop app, you have pre-fabricated templates which yous tin utilize to track your data straight from your smart phone.

At that place are more 10 templates which you can apply and open with a single touch.

And after that y'all can save a template in your smart telephone, in OneDrive, or send it to someone in a e-mail.

2. Double Impact to Edit

2. Double Touch to Edit

In Excel'due south desktop app, you need to double click to edit a prison cell…

…and in the mobile app, you need a double bear upon to edit a cell.

In one case you double touch on a cell your keyboard will get activated. You lot can enter data with by but typing or you can enter a function by typing "=" sign.

And in one case you are done with editing a jail cell touch the "OK" push button from the tiptop right side of the screen…

…or, if you lot want to cancel editing touch the cancel push button.

iii. Search for an Option

three. Search for an Option

Y'all cansimply search for the pick from the search bar.

At present here's the best thing:

Permit'southward say y'all are searching for the option "Bold"…

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

…employ the assuming font mode to the selected prison cell.

iv. Car Sum Values

Steps:

First of all,select the adjacent prison cell from the last cell where yous accept values and click on the more than button from the bottom right corner of the screen.

After that,select the "Dwelling" from the ribbon drop down andscroll down to the "Auto Sum".

In the finish,select the SUM.

This volition add the SUM formula to the selected cell for the values in a higher place it.

If yous encounter, in that location are other options likewise, like Boilerplate, Count Numbers, Max, and Min which you lot tin use.

5. Fill up Handle

Outset of all, y'all demand toselect the cell with the formula and click on the fill up handle [This activates the make full handle].

After that merely elevate the handle downwardly to the cell where you want to elevate the formula.

6. Switch Between Qwerty and Numeric Keyboards

f y'all are similar me tin't work without "Numeric Keypad" and must have it in the mobile app likewise.

Excel's mobile app is loaded with it.

You can simply switch between the normal qwerty keyboard and numeric keyboard using the switch push button.

7. Sort and Filter Data

In the mobile app, you have a unproblematic way to sort & filter data.

All you need to exercise is become to the more than button and open the "Sort & Filter Data" choice past scrolling downwards.

Hither yous have the option to sort data in Ascending or descending gild

...and for the applying filters, you can simply click on the "Bear witness Filter Buttons".

8. Notice and Replace

This one almost useful options from all the tips we accept here.

You can simply detect and replace a value by using this option equally nosotros use in our desktop app.

To use the "Observe & Replace" selection all you lot demand to do is become to more than push button…

…and scroll to the end in the "Abode Tab" and open up the "Find".

The moment you open it you'll get a search bar at the top where you can type a value and find information technology.

To replace a value yous can open the selection from the gear icon from the left and select "Replace".

There are too some avant-garde options which you can utilise here.

ix. Condition Bar Analysis

Yes, Excel'due south 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 bones calculations…

…similar sum, average count, the numbers count, etc.

10. Relieve a Workbook as a PDF

You can directly create a PDF version of your workbook.

Showtime of all,click on the more than options push button from the top of the app's screen.

After that, go to "Export" and click on "PDF".

Side by side, you lot demand to select the orientation and specify which part you want to export as a pdf.

In the end, proper noun 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

To utilize this option all you demand to do is affect the more than button from the bottom right of the app…

…and select the view tab and so…

…scroll down a bit and at that place you have "Zoom In" and "Zoom Out".

12. Yep, yous Can Draw in Excel

For this, select the "Draw tab" from the drop-down and at that place you lot have the option to draw.

This option gives you multiple options to describe, you can change colour + you lot have other options.

13. Straight Add Pictures from Your Camera

If yous want to click a moving-picture show using your photographic camera and want to add it to your Excel worksheet.

You lot have a simple option for this.

All you demand to practice is, go to "Insert Tab" and select the photographic camera option which opens the camera of your phone…

…and you tin click and insert it into the worksheet.

+ when yous insert a picture you accept the same options to customize it as you lot do in Excel's desktop app similar adding borders.

14. Add together Annotate on Cells

Yous just demand to select the cell where y'all want to add it and go to the review tab.

And from the "Review Tab", select the annotate to add a new comment.

Every jail cell where yous have a comment will accept a ruby-red colour indicator at the top right edge.

fifteen. Send Workbook in an Email

Sending a workbook in an electronic mail is pretty unproblematic from your smartphone Excel app.

All you demand to click on "More Button" from the top left…

…and subsequently that select "Send the Copy".

Select the format to send and the app to apply for sending the e-mail.

16. Create a Hyperlink

Excel'south mobile app is quite smart when it comes to adding hyperlinks.

You tin add together a link to the prison cell in the existing workbook or worksheet'southward cell or to a web address.

All you need to do is…

Become to the "Insert Tab" and select the "Link".

After that, enter the text for the link at the link address.

In the finish, click "Done".

To add a link another worksheet you need to enter the proper noun of the worksheet before the cell address.

17. Change Impress Settings

For this, you demand to open print setting from the more push à 'Print"…

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

Side by side, you lot need to specify the settings for the press.

Click "Next" to get a print.

18. Come across all the Functions

In the"Formula Tab", you can find all the function you lot demand.

nineteen. Rename a Worksheet

Before you rename a worksheet you demand to actuate the worksheet tab…

…and for this, touch on the worksheet button from the bottom left of the screen and…

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

xx. Create a Chart in Single Affect

In the "Insert Tab", there are all the charts as y'all accept in the Excel'due south desktop app.

Make certain select the data before you insert a chart.

21. How to utilise Paste Special Option

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 lot paste just select the prison cell and concord your touch…

…and you'll get options, click of the correct arrow to go to paste special options.

You accept iv means to paste values in "Paste Special"…

Format
Formula
Values
Picture

…select i of those.

22. Undo Redo Buttons

Disengage and Redo buttons are simply in that location for you lot. Just open up the options from the more push button from the bottom correct of the screen…