The Note10 makes it easier than ever to update and annotate documents on the fly in Microsoft Office apps. Here are some tips for using Excel on your smartphone.
This is one of a trio of user guides for getting the most out of Microsoft Office apps on your Samsung Galaxy S20 or Note10 device. Be sure to explore our tips for Word and PowerPoint to maximize your mobile productivity.
If you’ve ever wished you could use your Microsoft Office apps as easily on your mobile device as you do on your laptop or desktop computer, you’re in luck. With the new integrated Office Mobile app, Samsung and Microsoft have brought Office productivity to the Samsung Galaxy.
Office Mobile comes pre-installed on both 2019’s Galaxy Note10 and the new Galaxy S20 series. Microsoft Word, Microsoft PowerPoint and Microsoft Excel documents can all be created and edited in one powerful and intuitive application. The integrated approach means you get a single view of all recent documents you’ve opened, regardless of file type, making it easier to locate exactly the document you want on the spot. Meanwhile, OneDrive integration gives you secure and instant access to all of your important files in the cloud. Smart assistants also offer helpful suggestions to help you stay organized, streamlining your workflow as you go.
Need to track changes or add comments to a document you’re editing while en route to that next meeting? Easy. Want to make some quick annotations to a PowerPoint while you’re waiting for your flight or even live during a client presentation? You can do it in a snap with your S Pen. You can keep working when you’re away from a computer, efficiently wrapping up your tasks even as you’re on your way to your next appointment.
What's the Best Phone for Your Business?
Take this quick assessment to discover the smartphone most tailored to your business needs. Download Now
With these tips and tricks for Microsoft Word, PowerPoint and Excel, you can start getting the most out of Microsoft Office on your Galaxy smartphone right away. And they become even more powerful when combined with Samsung DeX, which lets you power a full desktop from your phone.
Microsoft Excel Tips and Tricks
Got a time-sensitive budget proposal to review before you head into your next meeting? You can quickly access it and zoom in on any important detail right on the Galaxy S20 or Note10’s expansive Infinity display. Here are just a few ways you can make the most of Excel while you’re on the move.
As with Microsoft Word, most of the features you would find in Excel on your PC can be quickly accessed by tapping on the A icon with the pencil in your top toolbar.
From there, you will have a view of the Home menu.
From the Home menu, you can fill in cells with specific colors, add borders to cells, merge, format and insert additional cells as you wish.
Insert Tables, Pictures, Charts and More
The Insert menu, which you can access by tapping on Home, gives you a fuller range of options including inserting tables, pictures, charts, links and comments.
Need to do some automated calculations? The Formulas menu is where you can set up complex equations and calculations.
Review and Add Comments
Use the Review menu to view comments made to a spreadsheet or add your own.
If you want to handwrite a comment and have it converted into text in Excel just like in Word, tap on Add Comment, then tap on the three dots at the right-hand corner of the gray toolbar and choose Handwriting. From there, you can begin jotting down your thoughts directly into Excel using the S Pen.
Sometimes, particularly when you’re working with a large spreadsheet, the ability to freeze panes can come in very handy. You can find that feature tucked away at the bottom of the View menu.
Draw Directly on an Excel Document Using the S Pen
You can also draw on a spreadsheet using your S Pen when using a Galaxy Note10. Open the Draw menu, select your drawing tools and begin illustrating. In the screenshot below, we’ve used a red pen to draw attention to regional sales.
View an Excel Spreadsheet in Landscape Mode
Although there is no Mobile View option in Excel like there is in Word, you can get a more expansive view of a spreadsheet in Excel simply by rotating your phone lengthwise. Here’s an example of our sales spreadsheet as seen in landscape mode, with columns C through F now visible on the screen.
Get Microsoft Office Help From Cortana
If you need help figuring out how to do something specific in Microsoft Office on your Galaxy smartphone, Microsoft’s Cortana voice assistant can guide you directly to the setting you need. If you don’t have Cortana already installed on your phone, just download the app from the Google Play store.
As seen in the screenshot below, you can find Cortana’s lightbulb icon on the main menu where you access most features in Microsoft Word, Microsoft Excel and Microsoft PowerPoint.
To use Cortana, tap on the lightbulb icon and then hit Tap to Talk in the window that appears below.
As you speak, Cortana will display the words you’re saying. In the example here, Cortana is being asked to locate the command for creating a footnote in Microsoft Word.
When you’re done asking Cortana for help finding a command in a Microsoft Office app, hit Tap to Pause. From there, you can tap on the option that best matches what you’re looking for and get the information you seek.
Get More Done With Microsoft Office on Your Galaxy Smartphone
When you’re racing from one appointment to the next, time is of the essence. You need to be able to work quickly without hunting for the feature you need. The new Office Mobile suite on your Samsung Galaxy smartphone puts that power at your fingertips, giving you the full range of Word, PowerPoint and Excel capabilities you enjoy on your PC. This way, you can get the most out of your phone and experience peak productivity wherever the day takes you. With the Galaxy S20 or Note10 and Microsoft Office, there’s no limit to what you can accomplish.
Explore how mobile workspace solutions can improve your productivity and collaboration. Learn how to go mobile-only with DeX in this free white paper. And don’t forget to review our Word and PowerPoint tips too!