If you are looking for a spreadsheet editing application, why don’t you try using the Google Sheets application? Google Sheets is a program owned by Google in the Google Drive service. This service also includes Google Docs and Google Slides, a word edittor and a presentation program respectively. Sheets on Android has functions like on web application but you will have some troubles when using it. In this article, we will guide you in details how to use Google Sheets on Android smoothly. Especially, we will focus on working with columns in Sheets, a tool with lots of functions you may have missed. Now, let’s learn some tips with columns in Google Sheets on Android. You will find something interesting.
About Google Sheets on Android
Google Sheets is similar to the Excel software of Microsoft but it can be used online on a computer’s web browser or other devices such as a tablet, a smartphone or macbook,…
Although Google Sheets is an online software, it has functions that other softwares do not have. Google Sheets is a free spreadsheet tool from Google but it still has the same formulas and utilities as Excel has, it is even more convenient. Basically, Google Sheets is similar to Excel but what does it have?
You can also use it anywhere and anytime. You will no longer have problems forgetting documents at home or losing data. Google Sheets also support users when they are not online. Google Sheets is also used in many types of devices, including iOS and Android operating systems. Because Google Sheets is not much different from Excel, if you know how to use Excel, you can absolutely use it easily.
After the above mentioned things, we appreciate Google Sheets as a great tool. Regardless of whether you are new to Excel or know how to use Excel well, you should not skip a useful tool like this. Up to now, Google Sheets is available as a web application, a mobile app for Android, iOS, Windows and as a computer software on Google’s Chrome OS.
Some tips with columns in Google Sheets on Android
How to rename columns in Google Sheets
Step 1: Open your spreadsheet.
Step 2: Tap and hold the row number 1 next to the first row on the top of the spreadsheet. This will highlight the entire row with blue lines.
Step 3: Tap again anywhere in the first row. A pop-up menu will appear.
Step 4: Tap the three dots on the menu.
Step 5: Select Freeze, this will pin the first row of the spreadsheet. This row will not disappear when you scroll down, then you can use it to name your columns.
Step 6: If you want to rename a column, tap the top cell of the column and rename it on the fx line.
Step 7: Tap the blue checkmark when you finish.
Note: To name columns in Google Sheets, you just need to do the same steps as renaming.
How to sum a column in Google Sheets
Step 1: Open the data you want to sum.
Step 2: Choose the cell you want to display the sum.
Step 3: From fx line, enter “=SUM”, a pop-up menu will appear.
Step 4: Choose SUM from the pop-up menu.
Step 5: Tap ( ) in the fx line, now you can choose data to Sum.
Step 6: Choose the data you want and tap the blue checkmark to sum it.
How to hide columns in Google Sheets
Step 1: Open the file you want to edit.
Step 2: Hold the character at the top of the column you want to hide until a pop-up menu appears.
Step 3: Tap the three vertical dots on the pop-up menu.
Step 4: Scroll down and tap HIDE COLUMN.
So, in this article, we mentioned some tips you should pay attention to when using columns in Google Sheets on Android. If you think these tips are useful, please share it with your friends. Do not forget to comment below if you have any questions. Try Google Sheets for free today and take advantage of it.