Buzz
Download Excel on iOS and Android
To use Excel on your phone, the first thing you need to do is download the app to your beloved device.
Unlocking Excel Mastery on Your Smartphone
Creating Templates with Ease
To craft a template, access Excel on your phone, then choose the working template that suits you, and you're done.
Editing Cells Like a Pro in Excel
For cell editing on Excel mobile, simply select the desired cell > Enter the data you want > Confirm with the green checkmark to finish.
Utilizing Self-Totalling Formulas
To leverage Excel's automatic sum formula on your mobile device, follow these steps:Step 1: Select the cells you want to calculate, then tap on the AutoSum option.
Step 2: Choose the function you desire (for example, Average as shown).
Step 3: The result will be displayed as shown below.
Merging cells in Excel
To merge cells in Excel on your mobile, simply select the desired cells and press Align & Center – that's it.
Discovering Excel's Search and Replace Magic
To find and replace, follow these steps:Step 1: Click on the Find option on the interface.
Step 2: Click on the sawtooth icon.
Step 3: Proceed to the Find and Replace or Find and Replace All option.
Step 4: Enter the Find and Replace content in the respective fields, then click > Replace to finish.
Saving Files in Excel
Once you've completed your tasks in Excel on your mobile, you can save your work using the following steps:Step 1: Tap on the three-dot icon as shown in the image.
Step 2: Proceed to select the Save option.
Step 3: Name your working file, then choose the saving location.
Step 4: Press Save to complete the process.
Share your Excel brilliance effortlessly with a copy! 🚀
To pass on your masterpiece, follow these simple steps:Step 1: Click on the Share option, just like magic.
Step 2: Keep the momentum going and click on Send a Copy.
Step 3: Choose the destination for your copy (AirDrop, Mail, Zalo…), and voila!
Embedding images in Excel made breezy! 📸
To embed an image in Excel on your mobile device, follow these steps: Tap on the icon, then switch to Insert > Image. Afterward, select the image you want to insert, and you're done.Zooming In and Out
To zoom in and out on Excel on your phone, go to the View tab (as shown in the image), then choose the Zoom In or Zoom Out mode you desire.
Additionally, you can quickly perform this action by using two fingers to swipe on the screen in the direction of expanding or reducing, and you're all set.
Creating ChartsTo create charts on Excel for mobile, navigate to the View tab (as depicted in the image), then select the Create Chart option, and you're good to go.
To create a chart in Excel on your phone, you can follow these steps:Step 1: Tap on the icon as shown and switch to the Insert > Chart mode.
Step 2: Select the type of chart you want to insert, and you're done.
How to rename a worksheet
To rename a worksheet, follow these steps:Step 1: Click on the icon as shown to switch to Worksheet mode.
Step 2: Click on the desired sheet, then enter the new name and press Done to complete.
How to View and Use Functions in Excel
To view and use Excel functions on your phone, follow these steps:Click on the icon as shown and switch to Formula mode. Then choose the function you want to use, and you're done.
How to Hide/Show Rows or Columns in Excel
To hide a row or column, select the row or column you want, then choose the Hide command (as shown). If you want to show it again, just repeat the same steps and press Unhide.
Changing/ Applying Number Formats
Step 1: To modify/ apply number formats, select the cell containing numerical data. Then, switch to the Home > tab, scroll down and choose Number Format.
Step 2: Next, select the format type you desire, and you're done.
How to add comments in Excel
To add comments in Excel on your mobile device, switch to Insert mode, then scroll down to choose Comment and input the content you want.
Summary of using Excel on mobile devices
Here is a handy tip for using Excel on your phone, as introduced by Mytour. This trick will come in handy when you need it.- Explore more: Android tricks, iOS tricks
