contador web Saltar al contenido

Excel on mobile: seven functions that few people know | Productivity

Excel for Android and iPhone (iOS) looks very similar to the PC version and shares part of the main features. Still, many functions that facilitate the use of the app are unknown to users, especially those that are designed for use with touch screens.

Want to buy a cheap cell phone? Find the best prices at Compare TechTudo

With an eye on that, we bring you a list of seven Excel functions for mobile that are little known. Although the following tips have been tested on a Moto Z3 Play with Android 8 (O), all the features below are also available in the iPhone app.

App offers, for example, a series of ready-made templates to facilitate the creation of spreadsheets Photo: Reproduo / Fernando TellesApp offers, for example, a series of ready-made templates to facilitate the creation of spreadsheets Photo: Reproduo / Fernando Telles

App offers, for example, a series of ready-made templates to facilitate the creation of spreadsheets Photo: Reproduo / Fernando Telles

  You can select ready-made templates to facilitate the creation of spreadsheets Photo: Reproduction / Fernando Telles  You can select ready-made templates to facilitate the creation of spreadsheets Photo: Reproduction / Fernando Telles

You can select ready-made templates to facilitate the creation of spreadsheets Photo: Reproduction / Fernando Telles

If the user does not want to create a spreadsheet from scratch, the Excel application offers several ready-made templates, with a standardized look and predefined formulas. Among the available models, you can choose task sheets, family budget, lists, travel expenses and much more.

To select a ready-made template, create a new document and, instead of selecting the "Blank workbook" option, choose any of the spreadsheets suggested below. Then, just edit the document fields with your information, adapting it to your needs.

Share your spreadsheet in PDF so others can view it, but edit it Photo: Reproduo / Fernando TellesShare your spreadsheet in PDF so others can view it, but edit it Photo: Reproduo / Fernando Telles

Share your spreadsheet in PDF so others can view it, but edit it Photo: Reproduo / Fernando Telles

Not everyone has the Excel application on their cell phones. Therefore, when sharing a spreadsheet, the PDF format can facilitate viewing the file, in addition to preventing the recipient from editing the data.

To use this function, Excel will communicate with Microsoft servers, therefore, the smartphone must be connected to the internet. With the network activated, just open the desired spreadsheet, touch the "Share" "Share as attachment" "PDF" button. Then choose the sharing medium.

The Excel symbol keyboard also brings a shortcut to the formulas Foto: Reproduo / Fernando TellesThe Excel symbol keyboard also brings a shortcut to the formulas Foto: Reproduo / Fernando Telles

The Excel symbol keyboard also brings a shortcut to the formulas Foto: Reproduo / Fernando Telles

When entering information in a cell, it is possible to use a special Excel keyboard with easy access to numbers and symbols. It is suitable for those who perform many mathematical operations. The feature also brings shortcuts to formulas, allowing them to be inserted with just one touch.

To use the keyboard, tap the typing box and select the keyboard icon with the numbers "123" at the bottom of the screen. Finally, if you want to restore your phone's standard keyboard, just tap the same icon again.

Hold and drag the top of the columns to move them Photo: Reproduo / Fernando TellesHold and drag the top of the columns to move them Photo: Reproduo / Fernando Telles

Hold and drag the top of the columns to move them Photo: Reproduo / Fernando Telles

Excel for smartphones and tablets allows you to move entire columns with just one finger. If you want to use this function in one of your worksheets, press the top of the desired column and wait for it to be highlighted. Then, drag to the new position.

It is also possible to move the spreadsheet rows just as easily. To do this, press the left end of the line until it is highlighted. Then just drag it to the desired location.

  You can check the search results without leaving the application Photo: Reproduo / Fernando Telles  You can check the search results without leaving the application Photo: Reproduo / Fernando Telles

You can check the search results without leaving the application Photo: Reproduo / Fernando Telles

A very useful function is smart search. With it, the user can search for texts or spreadsheet terms on the internet. When selecting smart search, the results are offered in Excel itself, without opening another application.

If you want to search for any term in your spreadsheets on the Internet, press the cell that contains the text. After releasing it, a bar will be displayed with the buttons "Cut", "Copy" and the smart search icon, identified by a magnifying glass.

Insert photos, graphics and other elements to personalize your spreadsheet Photo: Reproduo / Fernando TellesInsert photos, graphics and other elements to personalize your spreadsheet Photo: Reproduo / Fernando Telles

Insert photos, graphics and other elements to personalize your spreadsheet Photo: Reproduo / Fernando Telles

As with the PC versions, the Excel application for mobile devices also has graphics, images, links, shapes and other elements. If you want to insert a photo, for example, the user can still choose whether to open the photo gallery or the camera.

At any time, you can add new elements to your spreadsheet. To do this, touch the edit button at the top of the screen. Then, select "Home" "Insert" and finish by choosing the type of content you want.

7. Online file conversion

Converso online allows most files to be opened with the app Photo: Reproduo / Fernando TellesConverso online allows most files to be opened with the app Photo: Reproduo / Fernando Telles

Converso online allows most files to be opened with the app Photo: Reproduo / Fernando Telles

To ensure that spreadsheets created with different versions of Excel (including PC versions) always work in the application, Excel's mobile edition has an online converter. When activating the function, all spreadsheets incompatible with the app are converted on Microsoft servers, allowing the user to view and edit most documents.

To activate the feature, tap the "Accounts" button, go to "Settings" and activate the "Use Microsoft Online Service" option. However, if the smartphone is not connected to the internet when opening the files, the online conversion does not work correctly.