Do you need to work on some spreadsheets on the go, with your iPad, and would you like to understand how to proceed? Well, nothing could be simpler: download and install Excel on your Apple-branded tablet and start using it right away. How do you say? Would you like to receive some tips on what to do as you are still not used to using the famous device of the Cupertino company? No problem: luckily for you you have landed on the right guide, at the right time.
In fact, in today's guide, I will explain how to use Excel on iPad, in order to take advantage of all its features also in the mobile environment. Its operation is quite similar to that of the popular PC variant, so you shouldn't have any particular problems getting familiar with its mechanics.
Then? May I know what are you still standing there? Make yourself comfortable, take a few minutes of free time just for yourself and immediately start focusing on reading what is written below. I am sure that in the end you will be able to tell yourself very happy and satisfied with what you have learned as well as, obviously, that you have finally succeeded in your intent. What do you say, we bet?
Before getting into the tutorial and find out how to use Excel on iPad, you need to worry about downloading the famous app on your device.
In this regard, it should be noted that, unlike the classic version of Excel for computers, which is part of the Office package, the Excel app is totally free for devices with dimensions equal to or smaller than 10.1 " and can be downloaded individually.
On devices larger than 10.1 ", to use Microsoft Office apps, you need to subscribe to a Office 365 subscription (with prices starting from 6,99 euros / month). The same subscription on smaller devices gives you access to Excel extra functions, such as the ability to insert and edit SmartArt in spreadsheets. For more details on this, refer to my guide on how to install Office.
That said, to download Excel on your iPad, just visit the relevant section of the App Store directly from the tablet, press the button Ottieni / Installa and authorize the application download via Face ID, touch ID o password dell'ID Apple.
Then start the app by pressing the button apri appeared on the screen or by selecting the relevant icon which was added in Home Screen.
Use Excel on IPad
After downloading and installing Excel on iPad, you are finally ready to take the real action and, therefore, find out how to use the famous Microsoft app. Find everything explained below.
Create and Open a Spreadsheet
If you are interested in understanding how make changes to a spreadsheet saved locally on the iPad or in the cloud (e.g. on iCloud Drive or on OneDrive), the first move you need to do is to press the button apri found in the left sidebar on the main Excel for iPad screen.
Next, you need to select the item iPad, if the file is saved locally; that Other if it is present in iCloud Drive, or that Add a location, to connect to another supported cloud storage service, and download the document from there. Then click onpreview of the file of your interest and that's it.
If, on the other hand, you want to create a new document, you have to press the button New located at the top of the left sidebar, after which you have to select the option Blank workbook (on the right) and you can start working on a new blank spreadsheet. Alternatively, you can select one of the preset templates available in the app.
Once you open a document or have created a new one, you will find yourself in front of the Excel sheet screen which, as you can see for yourself, is characterized by a table divided into column e lines which go to constitute celle. Columns and rows are marked with respectively letters e USEFULL, which allow them to be identified.
In the upper part of the screen, however, you will find the toolbar on which, in fact, the buttons to perform the main operations on the spreadsheet, while even higher there are the cards to access the various functions of the app. At the bottom, then, there are other buttons, useful for access the various sheets that make up the file and for add new ones.
Fill in and Format the Cells
Let's see, now, how to do it fill in the cells present in the spreadsheets. To proceed, double tap on the cell in which you intend to go to act. You will then see the virtual keyboard on screen to fill in the cell.
Pressing on the button ABC found in the upper right part of the virtual keyboard, you can access the keyboard with the letters, while tapping the button 123 adjacent you can access the numeric keypad to enter values and you can use the buttons that allow you to view the logical operators and symbols to create formulas manually.
Other buttons available are those to perform therounding up or down. For more information on this, you can consult my guide dedicated specifically to how to round in Excel.
Please note: as easily understood, if you have connected a physical keyboard to the iPad, you will not see any keyboard appear on the screen, as you will have to work from the physical keyboard.
Once you've entered the data into the cells, you can format the text using the buttons in the toolbar at the top of the tab Home: using them you can change the font, size and color of the font, set bold, italics and underline. In addition, you can mark cell borders, change text alignment, set a background color for them or change the format of the values contained in them.
Using the function Sort and filterinstead, you will be able to filter a list of data or sort them in ascending / descending order. You can also add the function Auto Add, which allows you to perform a sum of all positive and negative values of a given range of cells.
Insert Graphics, Images, Shapes and Other Elements
If you need to insert graphics, images, shapes and other elements in your Excel sheet, all you have to do is go to the tab Inserisci, which you find at the top of the application screen, and use the buttons on the toolbar always located at the top, to insert the elements of your interest in the spreadsheet.
To be precise, the button Graphs allows you to add different types of graphs (eg histograms, line, pie, etc.), the button Table allows you to insert tables, while the button Photos and that Camera they allow you, respectively, to insert the images saved in your iPad photo gallery and to use the photos taken on the spot.
Il pulsating Forminstead, it allows you to insert geometric shapes (eg squares, circles, triangles etc.) in the worksheet. Instead, by tapping on the button with the letter "T" and the text you can create boxes in which to enter text by pressing the button with the duck and the leaf you can insert icons while pressing on the button connection you can add links.
If you need to insert freehand drawings, go to the tab Design and use the tools to draw placed at the top according to your needs: you can choose the color of the stroke, its thickness, whether to use the pencil, the highlighter etc.
Enter the Formulas
Le formula are one of the flagship features of Excel: using them is very useful to process and manage the data entered in the spreadsheet. To use the feature in question, simply access the tab Formulas found at the top of the application screen.
Based on what your needs are and, clearly, depending on the data on which you need to work, you can choose between various types of formulas, by tapping on the relevant buttons in the bar at the top: Auto Add, Financial, Logics, Text etc.
So, tap the button for the typology formula of your interest, then select the formula exact you want to use from the menu that opens to add it to the currently selected cell and its generic shape will be visible at the top.
At this point, replace the information present by default in the formula with the values or cells of your interest and tap the button with the check (on the right), in order to confirm the insertion in the selected cell.
For further information on this, I recommend reading my specific tutorials on how to sum 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 screenshot showing the spreadsheet in Excel on iPad can possibly be changed using the options available in the tab View, placed at the top.
From there, in fact, you can enable the display of the formula barand grid, headers, cards, you can choose whether to activate the view from right to left, whether to increase or decrease it zoom and yes freeze panes: just tap on the appropriate switches and buttons. For more about the last function, you can read my tutorials on how to lock a row in Excel and how to protect cells in Excel.
Instead, by going to the card Give (which you always find at the top of the screen), you can change the sorting of the data entered in the spreadsheet in a increasing o descending, you can apply appropriate filters and, again, you can choose to make visible or not the details.
Save, Share and Print a Spreadsheet
You have finally figured out how to use Excel on iPad, you have finished the work done on your spreadsheet and you wish save the file or share it? I'll explain immediately how to do it, it's child's play.
In the first case, just exit the sheet by pressing the button with the left arrow that you find at the top left. By doing this, the saving will be done automatically. What you will get is a document in the standard format XLSX.
You can also save the document by pressing the button with the symbol […] and the sheet (which you always find at the top left) and, subsequently, on the button Save. Then indicate the name you want to assign to the file and the location in which you want to store it and that's it.
If you want to save the document in PDF or in ODS, press the button with the symbol […] and the sheet, select the voice Export and choose the format you prefer from its menu.
As for sharing, however, press the button with the arrow collocato in alto a destra, selects the voice Invite people from the menu that appears and choose whether to save the workbook you are about to create to share it, by tapping on the button Save, or whether to send a copy of the document via email or other app, by selecting the wording Send a copy.
I also point out the possibility of print the spreadsheet directly from your iPad. To do this, tap the button with the symbol […] and the sheet at the top left, select the item Print from the menu that opens and then the wording AirPrint. Finally, adjust the printing options (orientation, paper size, etc.) and tap the button forward and on the voice Print. If any steps aren't clear to you, check out my guide on how to print from iPad.
More Apps to Use Excel on IPad
The use of Excel on your iPad has not particularly convinced you and you would like to know if there is any app alternativa by which to work on spreadsheets? Well, of course there are, and below are listed the ones they believe to be the best.
- Numbers - this is the app distributed directly by Apple to create, view and edit spreadsheets. It is also compatible with files created with Excel and the operation is not so dissimilar to that of the famous Microsoft application. It's free.
- Google Sheets - application distributed by Google that allows you to work on spreadsheets both locally and online, using the Google Drive proprietary cloud storage service. Free.
- WPS Office - app that allows you to manage text documents, spreadsheets and presentations, both locally and through the most popular cloud storage services. It is free, but to take advantage of all the functions offered, you need to sign up for a special subscription through in-app purchases (starting from € 3,99 / month).
- Polaris Office - excellent app thanks to which you can manage documents created with Microsoft Office and Google Drive. It's free, but through in-app purchases (at a basic cost of € 3,99) you can unlock additional functions.