Microsoft Office 2016: The Complete Guide (2015)
Excel for Android
The new Excel 2016 is now on Android phones. It allows you to manage your excel files on your Android phone.
Managing your files from excel on your android is still accessible. It’s just that you won’t be able to delete files from Excel for Android. In order for you to delete files, you would have to go to OneDrive or your team sites.
Sharing Files from Excel
When you need to share a file, it is transformed into a link or placed as an attachment in email. The process of sharing is very simple. All you need to do is click Share and options will appear as Email as link or Email as attachment.
There are going to be times when you want to access a file that is stored on your computer, but you are not near your computer at that moment. You can sync your files from your computer to your phone just by accessing them from your OneDrive, Dropbox or Office 65 team site. This can only be done if you have uploaded your files to your OneDrive, Dropbox or Office 65 team site. You can upload your files by:
Accessing your web browser
Go to your OneDrive, Dropbox or Office 65 team site
Now to access your files on your android device, you would be required to sign in to the app. Once you are signed in, click open, choose the service that your file is saved to, there will find you file.
Working with files Offline
There are only a few scenarios for when you can only work offline. When you are offline, you can create an empty document or workbook. You will not be able to create one from a template because you will need access to internet. If you have created a workbook online from a template, you can work from that workbook when you go offline.
Please note that only a minimal set of fonts are made available to you. Only when you are online you will more fonts to choose from.
If you are offline and want to open a file, you would have to ensure you have already opened it while you were online from the location you have stored it. After it has been opened online, you are free to access it while you are offline.
You may wonder if you can save a file when you are offline. Yes, you actually can. Files that are downloaded from any of the online locations, can be automatically be synced with the online version when changes are made offline. You must ensure you go to file then save to save the file to your disk after you have made you changes in your file.
Using Autosum in Excel for Android
At one point you may want to make calculations in your worksheet in Excel for Android. This can definitely be done. Finding the sum of numbers in your worksheet is easy when it comes to Android devices. You can use Autosum by:
Select cell under the last number in the column
For a tablet, click Autosum on the formulas tab
For a phone, click Formulas
Then click enter
That’s all there is to be done.
Duplicate Data in Row or Column
Instead of re-typing your data in another cell or column, you can just duplicate it. This is most definitely easier than re-typing and you can work faster with this feature. Here is how it can be done:
Select a row or column
Select an empty row or column
Then click Paste
Start a New Line of Text in a Cell
When using Excel on your Android device, you may want to take a next step by beginning a new line in your worksheet. For you to start a new line of text, all you are required to do is double tap in the cell in which you to want to perform your task. Click on the blue cursor then click New Line in the contextual menu.
Freeze Panes to Lock the First Row or Column
Excel 2016 features the freeze pane which is another popular feature that also has been improved for the liking of users. Freezing panes allows you to view the headers of your workbook while scrolling through by locking both the top row and/or first column. This procedure can be done by clicking View then click Freeze Panes after which you are required to tap on the option that you need.
Freeze multiple rows or column
This is another upgraded feature of Excel 2016 that allows users to freeze numerous rows or columns as they wish. They can freeze numerous rows by:
Clicking on the row located below the final row that you wish to freeze;
Tap on View
Click Freeze Panes
If you wish to freeze multiple columns the simple way to do it is by
Selecting the column located the last column to the right
Click on Freeze Panes
To Unfreeze Panes
You not only can freeze panes but you can also unfreeze them if you wish. This can be done by clicking View then click Freeze Panes, then erase the options that were selected.