Using Excel from a mobile device seems like a bit of a joke, but after using it, it is easy to get caught up in the game. Of course, we will never create great worksheets like we can with Excel desktop. But opening its files from any location (street, subway, bus) is very interesting.
Excel Mobile has been around for 10 years (November 6, 2014). A lot of improvement has been made, and now it's really easy to work on a worksheet with just a touch screen. Let's see some techniques for working with Excel on Mobile.
Download Office 365 Application
- Go to the marketplace
- Search for Microsoft 365 (Office)
- Install the app
Connection to the cloud
Since Excel 2013, connectivity has become the standard work in Office. We have presented how to work with Excel for free from a browser with Excel Online. But beyond working with Excel in a Web browser, the most important thing is to save your documents in the cloud. This way, you can easily load your documents (Excel, Word, PowerPoint, PDF file) on any device.
The active cell
It's easy to locate the active cell on a mobile. Like on Excel desktop, the cell edges are wider but there is more.
- You have 2 circles to extend the selection and select more than one cell
- You have an extra border at the bottom of the cell. It's the fill handle 😲
The Ribbon and the formula bar
Like in Excel mobile, you can open different tabs from the ribbon.
- Formula bar
- Call the functions library
- The most useful tool (card, fill down, filter, change color, ...)
- Open the ribbon on Excel mobile
Navigation in a worksheet
- On a phone, moving into a spreadsheet is simply by sliding your finger on the screen.
- Similarly, to zoom in or zoom out, simply apply two fingers on the screen as you move closer or further away. This is the same principle as a photo or a map.
In addition, you can view your spreadsheet horizontally or vertically by changing the orientation of your mobile.
To navigate between worksheets in your workbook, have a look at the
Editing a cell
To edit a cell, you have 2 options
- press the icon function
- double-contact with your finger in a cell
These two actions will you bring up the keyboard to enter your data using the virtual keyboard.
Copy Paste with Excel mobile
The technique is not as simple as it is with Excel desktop. You know that you are in the copy-paste mode when the icon of your selection are squares and not circles.