Tips for Using Google Sheets on Android and iOS

We have already shown you how you can convert PDF tables to Google Sheets, and now we can talk about what happens when you have a spreadsheet ready for further editing. On mobile phones the Google Sheets interface is different than on the web, which is why some things are done differently. The following tips for using Google Sheets on mobile phones are valid both for Android and iOS systems.

1.  Freeze rows

To freeze a row or column, first select it. Tap anywhere on the selected section and new options will appear.

more options in google sheets

Tap on them and choose Freeze.

freeze column or a row

Sometimes the Freeze option is immediately visible and sometimes you need to continue tapping.

2. Resize rows and columns

To resize a row or column, select it and tap on the upper part near the column letter or number. Then drag the row or column to increase or decrease it. While dragging one line, it will turn into a double line.

increase column row size

On smaller screens this might not be easy to do, but you just have to tap very precisely on a particular spot.

3. Insert function

To insert a function, simply tap on the cell and then on the field below. Enter the equal sign followed by a function name, and enter all the necessary arguments.

entering formula in google sheets

Sometimes the autocorrect might interfere with entering functions, so be prepared for that.

4. Change cell format

This one might seem tricky. If your cell is formatted as a number but you want it to be formatted as text or date, here is what you can do. Tap on the A letter in the upper menu and choose Cell.

format cells google sheets

In the field Number format choose the appropriate number.

number format

On the other side in the Text tab you can change the cell’s look, font, size, color and more.

5. Save as Excel

If you want to save the spreadsheet in Excel format, which you may want to send by email to someone, simply tap the More settings.

settings google sheets more options

Choose Share & Export and then Save as Excel.

share and export google sheets file

save google sheets as excel

6. Use Autofill

The Autofill function is an extreme time saver. It exists in mobile version as well. To use it, simply enter a couple of the first elements in a sequence (for example: 1, 2, 3 in a row or column), select a portion of the row or column that needs to be filled till the end as started, tap on the selection and choose Autofill when it appears.

autofil data in google sheets

The selection will be filled with appropriate elements that logically follow what you entered (for example: 4, 5, 6…).

What to Do When a CSV File Can’t Fit into Excel?

Microsoft Excel has a limit on the number of rows it supports.  The limit is 1,048,576 rows or 16,384 columns. If you are trying to open a csv file that contains an exceeding number of rows or columns in Excel, the software will send a notification that the file is not loaded completely. Understandingly, that is not what we need; we need to open the whole file.

What to do in such cases?

file not loaded completely

The solution for the file in csv format is to split it into multiple parts. Simply download the Free Huge CSV Splitter software which is compatible with all platforms.

The tool is pretty simple to use. Open it and enter a desired line count in your CSV file. You can enter up to 1 000 000 lines. Choose the desired file and click OK.

csv file

The splitting will take only a couple of minutes, after which you can open all parts without a problem.

How to Reduce the Size of Your Images in JPG or PNG Format?

Working with large images is not always convenient. They can make presentations too large, documents bulky and webpages sometims need a lot of time to load because of oversized photos. And resizing images is not always a solution, because in many cases you’ll need the images in those precise dimensions. One possible solution for documents and presentations with large images is to convert them to PDF format. That way the whole document is more optimized, but that’s not what will work for you every time, because sometimes you need images separate from the document, not within.

Here is a website that can reduce the size of any image in jpg or png format without sacrificing quality. The image will look the same, have the same dimensions but its size will be condensed.

reduced png jpg images

Some of the images will be over 80% smaller.

The website name is, but don’t let the name confuse you. It also works with jpg documents.

Upload your images and the optimization will start immidiately. You can upload up to 20 images in one go. After the optimization is complete, download them to your computer and you are ready to reuse them. We’ve tested this tool a couple of time and we are amazed with the results.

How to Protect Only Specific Cells in Excel?

When you need to send someone a spreadsheet and want to make sure that no changes to any formulas are made, you can resort to locking a sheet or workbook.
It is also possible to lock specific cells. That way you can protect your document from changes in certain places, while other cells can easily be edited. Here is how you can do it:

The first step is to select all cells in the spreadsheet.

select all cells in excel

Right-click on them, then choose Format Cells – Protections and tick the Locked button.

format cells in excel


Now all of the cells are unprotected.

The second step is to enter data in all the cells you want protected, and select them. The Go To functionality can prove useful for that.

After selection, repeat the step above: Format Cells – Protections, then tick the Locked button.

lock cell excel

The last step requires you to go to Review – Changes – Protect Sheet.

protect sheet in excel

Enter the desired password. Make sure not to forget it.

And that would be all. This way you can make sure that crucial data stays unchanged.

Best MOOCs for Learning Microsoft Excel

Everybody who has worked with Microsoft Excel knows that it is a complex piece of software that takes years to master. Many professionals are still not confident in their knowledge of Microsoft Excel.

If you are a beginner in learning Excel and want to advance beyond basic operations, the best solution is to attend a course. There are plenty of those on Youtube, but if you’re aready prepared to devote time to acquiring a new skill, it would be wise to go with something that will get you a certificate. To help you look for an appropriate course, we have created a list of the best free MOOCs for learning Excel, all in one place.

Microsoft Excel

1) EX101x Data Analysis: Take it to the MAX

This course is offered by the edX platform. If you’ve missed the current session, you can wait for another one, or check their archive for an older course that you can take at your pace, but without acquiring a certificate. EX101x is really beyond excellent. After the first week, it immediately takes you to an advanced level, and you can be sure that you will learn lots of practical things. Aside from the practical, the course also offers fun, because the lectures are very interesting and entertaining. We definitely recommend it.

2) Excel for Data Analysis and Visualization

Another Excel course by the edX platform, offered in partnership with Microsoft. It shouldn’t be missed, because it offers a lot of practical excercises, and lecturers cover some unique aspects of this amazing software.

3) Introduction to Excel VBA Programming 

If you are interested in learning Excel programming, you should start here. The basic foundations of Excel programming are explained clearly. In addition, it is self-paced, which makes it perfect for busy people.

4) Udemy free courses

There are plenty of free courses on Udemy for novices and advanced users. However, bear in mind that not all of them are of great quality. Make sure to check references and comments by other users before you start.

5) Mastering Data Analysis in Excel

Coursera has recently introduced new Data Analysis Specializations, some of which include courses dedicated to Excel. Mastering Data Analysis in Excel offered by Duke University certainly looks promising.