How to Use Excel on Iphone

For business purposes, you would like to have access to some spreadsheets directly from yours iPhone but you don't know how? Well, it's easy: install the version of Excel for iOS and you will be able to view, edit and create spreadsheets from your "iPhone by". How do you say? Are you not very familiar with technology and would like to receive some advice on what to do? Don't worry, I can help you out.

If you dedicate a few minutes of your free time to me, I can in fact explain to you, in a simple but not in detail, how to use excel on iphone: an operation that, in advance, is definitely less complex than you imagine. Furthermore, you should know that the Excel app largely incorporates the main functions of the desktop variant, but is optimized for mobile use, so it allows you to work very easily on spreadsheets on smartphones and tablets. .

Then? May I know what are you still standing there? Make yourself comfortable, grab your iPhone and start focusing on the information below. In no time at all, you will learn how to make the most of this app to view your spreadsheets from iOS, but also how to edit and create new ones. Happy reading and good work.

Preliminary Operation

Before getting to the heart of the matter and finding out how to use excel on iphone, you have to download this application on your "iPhone by".

In this regard, it is necessary to specify that, unlike the classic version of Excel included in the Office package for computers, the application for iOS can be downloaded individually and is totally free for all devices with dimensions equal to or less than 10.1 " (dimensions in which obviously all iPhone models fall).

Eventually, you can subscribe to a Office 365 subscription (with prices starting from 6,99 euros / month), to unlock additional functions in the Office mobile apps and take advantage of the Microsoft suite on your computer. For more details on this, I refer you to reading my guide focused specifically on how to install Office.

Having said that, to download Excel on your iPhone, access the relevant section on the App Store directly from your device, press the button Ottieni / Installa and authorize the download via Face ID, touch ID o password dell'ID Apple.

Next, start the application by pressing the button apri appeared on the screen or by tapping on the relative icon added in Home Screen.

Also keep in mind that in order to make changes to documents and to save them you will need to log in to Excel with yours Microsoft account. Without it, you will be able to use the app only in view mode. If you don't have a Microsoft account yet, you can create one by following the instructions on what to do in my guide on the subject.

Use Excel on IPhone

Once you open the Excel app on your iPhone, you are ready to take action and discover all its functions: now I'll talk about it in detail.

Create and Open a Spreadsheet

If you are interested in understanding how change a spreadsheet saved locally on your iPhone or in the cloud, on services such as iCloud Drive, OneDrive or Dropbox, the first thing you need to do is select the item apri found in the bar at the bottom of the application's home screen.

Later, if the file of your interest is saved on the device, select the item iPhone; if it is on iCloud Drive, select the entry Other, while if you want to take it from a different cloud storage service, tap on the wording Add location and access the service of your interest. Then press onpreview of the file of your interest and that's it.

For create a new document, however, selects the item New that you always find in the bar below and tap on the option Blank workbook. Alternatively, choose one of the preset templates included in the app.
After opening the spreadsheet or after creating a new document, you will find yourself in front of the Excel sheet screen: as you can see for yourself, it is a table divided into column e lines, marked with letters e USEFULL that allow you to identify them. Columns and rows, together, make up the celle.

At the top there is a notice indicate the fact that you must carry out theMicrosoft account login to be able to edit the document. So, click on it and log in by typing your details.

Below, however, you will find the toolbar on which i buttons to perform the main operations on the spreadsheet and the field to enter functions, while at the top you find the bar with the buttons for manage the save print and file sharing.

Fill in and Format the Cells

Let's now find out what to do for fill in the cells in the spreadsheet. Firstly, double tap on the cell you wish to act on: by doing so, you will see the virtual keyboard of iOS.

By default, the keyboard with le is shown letters but, by pressing the button 123 placed in the upper left part, you can see the numeric keypad through which to insert numerical values ​​in the workbook.

After typing the data in the cells, you can format the text using the appropriate functions, which you can call up by pressing the button [...] located at the bottom right or on the button with the "A" and the pencil at the top (always on the right). From the menu that opens, you can change the font, colore, font size etc.

Still from the same menu, I point out that you can change the formatting of the cells by changing the style, color, size, format and so on.

Please also note that the function is also accessible from the menu in question Auto Add, which allows you to make a sum of all the positive and negative values ​​of a specific range of cells.

Instead, using the function Sort and filter (the one you can always recall from the above menu, or by pressing the button with thefunnel located below) you can filter a list of data or arrange them in ascending / descending order.

Insert Graphics, Images, Shapes and Other Elements

You would like to understand how insert graphics, images, shapes and other elements in your spreadsheet? So do this: press the button with the "A" and the pencil located at the top right or on the button [...] located at the bottom, tap on the item Home contained in the menu that opens and select the wording Inserisci.

In the additional menu that is shown to you at this point, tap on the item Graphs and choose the type of chart you want to insert. From the same menu you can also choose to insert photo (either by taking them from the iOS library or by clicking them on the spot), forms, icon, text boxes, Comments e connections.

If you want to insert freehand drawings, instead, select the item Design from the list that is shown to you by tapping on the item Home (in the menu below) and tap on the item Start Inking, to view the Excel drawing tools.

Enter the Formulas

Impossible not to understand how to use Excel on iPhone without at least mentioning the formula, very useful for processing and managing the data that is entered in the spreadsheet. To take advantage of this functionality, press the button with the "A" and the pencil located at the top right or on the button [...] located at the bottom, tap on the item Home in the menu that opens and select the wording Formulas.

Depending on your needs, you can choose between various types of formulas by selecting the relevant items that you find in the menu that appears at the bottom of the display: Logics, Text, Date and time etc.

So, select the type of formula you want to use, indicate the exact formula from the list that is shown to you, in order to add it to the currently selected cell, and its generic form will be visible in the field located in the top of the display.

Then replace the default information of the formula with the values ​​or cells of your interest and tap the green button with the check appeared at the top right, so as to confirm and apply the changes.

For more information on what to do, I refer you to reading my guides focused specifically on how to add in Excel, how to subtract with Excel, how to multiply in Excel, how to calculate the percentage in Excel, how to average in Excel and how to raise to power in Excel.

Change the View of the Data

The screen through which the Excel sheet is shown can be modified, if necessary, using the options available by selecting the item View attached to the menu that appears by selecting the wording Home after tapping the button with the "A" and the pencil located at the top right or on the button [...] located at the bottom.

From the additional menu that appears, in fact, you can activate / deactivate the display of the formula bar, the display of the grid, you can adjust the level of zoom and much more. You can also choose to freeze panes, as I explained to you in detail in my specific guides on how to lock a row in Excel and how to protect cells in Excel.

By selecting, instead, the item Give from the list visible by tapping on the item Home (after calling up the Excel menu by pressing the button with the "A" and the pencil or on the button [...] below), you can apply special ones filters, change thesorting of information and choose to make visible or not i details.

Save, Share and Print a Spreadsheet

Now that you finally have a clear idea of ​​how to use Excel on iPhone and that you have finished your work on the spreadsheet, you would like to know how to save the latter? Nothing could be simpler: press the button [...] placed at the top right and then on the button Save, then type the name you want to assign to the file, the location where you want to store it and that's it. What you will eventually get will be a XLSX.

However, keep in mind that, by default, after saving the file for the first time, all changes made to it are saved in a automatic. So when you go to open the document later, you can also avoid saving it manually.

If, on the other hand, you want to save your document as PDF or as a file ODS, after tapping on the button [...] located at the top right, you have to select the item Export from the displayed screen and choose the format you prefer.

Do you want share your spreadsheet with other users? Yes it can do that too. To do this, tap the button with the freccia verse destra located at the top right of the screen, select the item Invite people, type in the contacts of your interest, indicate whether or not to enable the people in question to edit and tap on the item Submit.

Alternatively, you can choose to send the link to the spreadsheet or a copy of the document by selecting the options, respectively Copy link o Send a copy from the screen visible after pressing the button with the freccia verse destra at the top of the screen.

If you want print the spreadsheet, press the button instead [...] collocato in alto a destra, selects the voice Print from the displayed screen and then that AirPrint.

Finally, proceed to adjust the settings related to printing on the next screen, following the instructions on what to do that I gave you in my tutorial on how to print from iPhone and press on the item Print.

More Apps to Use Excel on IPhone

Have you tried your hand at using Excel on iPhone but the famous app did not convince you very much, which is why you would like to understand if there is any valid alternative you can turn to? Of course yes! Those I have listed below, for example. Try them now!

  • Numbers - is the app developed by Apple to create, view and edit spreadsheets. It is free, perfectly compatible with Excel files and its operation is not very different from that of the famous Microsoft solution.
  • Google Sheets - app developed by Google for managing spreadsheets. It's free, allows you to work on files both locally and online, and is based on Google Drive, the “big G” cloud storage service.
  • Polaris Office - allows you to manage documents made with Office and Google Drive and is quite simple to use. It is free but, to unlock all the extra functions, in-app purchases must be made starting from € 3,99 / month.
  • WPS Office - suite that allows you to manage text documents, spreadsheets and presentations. Yes it can use both to work locally and via cloud storage. It's free, but in order to unlock all the functions, you need to subscribe through in-app purchases (at the basic cost of 3,99 euros / month).