A simple program for creating tables for android. Video: Get started with Excel for Android tablets. Collaboration function

Spreadsheet processor for working with spreadsheets in your phone.

Is it convenient for you to use the calculator built into your mobile phone? In principle, completely, while it concerns all sorts of small calculations.

But it often happens that you need more than just a calculator when you need to link calculations to a specific database, for example. For this purpose, there are programs on the computer that are called spreadsheets. But few people know that similar programs are implemented in JAVA, which allows you to have a powerful enough spreadsheet processor at hand in your mobile phone!

Today I will tell you about a very good spreadsheet editor for a mobile phone - Sheet... With its help you can create price lists with auto-calculation formulas for several categories or, for example, dynamic product databases.

Sheet Feature List

• creation and editing of spreadsheets (proprietary format);
• saving tables inside the program without creating an external file;
• hand-made creation of calculation formulas;
• highlighting cells in color;
• manual resizing of cells;
• functions of copying and pasting cell data;
• controls the alignment of text in cells.

Everything is fine, but there is one thing, but a big one, BUT - Sheet does not know how to work with tables created in other programs, since it stores all the data inside itself, without creating an external file :(. Therefore, you will have to pay time for the convenience of using a ready-made table, spent on its creation.

So, let's install the program on our phone. For this, as we know, there are several ways: installation via the Internet and from a local computer (read more).

Sheet interface

Have you installed it? Let's run the program and try to work with it.

After launch, a ready-made spreadsheet with empty cells will open in front of us.

Below the table you will see two buttons "Menu" and "Cancel" (their location depends on the phone model, for example on Samsung J210, on which the testing took place, the "Menu" was on the left, and on the right was the "Cancel" button). Navigation through the cells is carried out using the joystick. A central click of the joystick on a cell brings up a window for information about its contents.

Working with the program

Now that we have figured out the navigation through the main window of the program, let's try to create a small plate. As you probably already guessed, we should start by pressing the "Menu" button.

Here we see five sections of the main menu. The first is responsible for editing data in a specific cell, the second is for the size, color and other external attributes of the cell itself, the third allows you to automatically recalculate all formulas on the sheet, the fourth calls the menu for saving and opening files, created tables, and the fifth opens help on program.

In order to enter data into our first cell, select it and select the item "Cell Data" from the menu.

In the new menu, you will see a few more items. The first one allows you to edit the contents of the cell, the second one - to clear all the contents, the third one - to copy, and the fourth one, respectively, to paste data. The last point brings us back to our main sheet of the table. We select the first item "Edit Cell":

In the window that opens, enter the desired value (you can also enter text, see below) and select "Ok" in the menu to save it.

In the same way, we enter a certain value in the next cell (A2), for example, the number 6. And now, let's say we need to calculate the sum of our two numbers entered earlier. To do this, create a formula. Formulas in Sheet are created by pressing the "*" key on the phone keyboard.

Since we entered the data in cells A1 and A2, it would be logical to set a formula for cell A3. Select it and press "*". In the window that opens, write the formula for adding the above two cells:

Now the main thing is that you enter the names of the cells in the English layout, otherwise you will get an error. If everything is done correctly, our table will look like this:

Now, no matter how you change the values ​​in cells A1 and A2, their sum will always be displayed in the third cell!

However, it is possible to calculate this way with a calculator. Let's complicate our table by giving names for all cells, as in a standard database. Let the first row be responsible for the number of pencils in stock, the second for pens, and the third for "Total" :).

And everything would be fine, but some inscriptions do not fit into a standard cell. So you need to change their size! To do this, in the main menu, select the second item - "Cell Format":

A new menu with four items will open. The first is the size of the cell, the second is its color, the third is the alignment of data within the cell, and the last is the output to the sheet with the table. We need the first item.

As soon as you activate it, you will be sent to the main screen, while the right and bottom bounding lines of the cell will become dashed, and you can move them using the navigation keys of the phone:

For the convenience of keeping track of the necessary information, I also advise you to alternate the colors of the rows of cells (for example, odd - black, even - white (I do not recommend using gray)).

The time has come to save our labors. To do this, select the fourth item in the main menu of the program - "File":

Here again is a small menu in five sections. To save the table, select the third one - "Save":

In the window that opens, enter the name under which we want to save the table and click "Ok".

Now, if you want to open the created table in the future, you just need to go to the "File" menu and select the "Open" item. In the list that opens, find your table by name and run it:

conclusions

Sheet has another not very pleasant feature - misunderstanding of the Cyrillic alphabet: (Therefore, you will have to enter text data in English or transliteration (as in our example). In all other respects, this is a very good program that will give you the opportunity to work with spreadsheets, without resorting to buying expensive smartphones that have a similar function!

P.S. It is allowed to freely copy and cite this article, provided that an open active link to the source is indicated and the authorship of Ruslan Tertyshny is preserved.

P.P.S. If you want to install this program on your phone, but you cannot transfer the downloaded files from your computer, you can use the following direct link. To download, enter the link address into your phone browser:

The Excel app for Android tablets is very similar to the classic Excel program you are familiar with. However, if you are accustomed to using a mouse and keyboard, you may find it helpful to familiarize yourself with some of the differences. This video provides tips to help you get started quickly.

Highlights of this video

Video transcript

[Introductory music]

Learn how to quickly get started with Excel on your Android tablet.

First, let's learn how to enter text. First, I touch the cell, then the formula bar, and start typing. When I finish typing, I click on the green checkmark.

But it can be done faster. I just double-tap the cell, enter text and click on the checkmark,

and if you need to enter text in a group of cells, you can simply press Enter to move down one line.

When I'm done typing, I press the Back button to hide the keyboard.

This button looks like this on my tablet, but it might look different on your device.

Another tip for typing. Let's say we need to correct a typo.

I double-tap the cell, tap and hold the slider, drag it to the desired location, and then fix the error.

Now I will introduce some formulas. I want to sum the values ​​in this column ... Excel offers a range of cells to sum up and it suits me, so I just touch the checkmark.

However, suppose I need to put the result of the addition to the right of the table. Excel again offers a range of cells to total, but it is not suitable in this case.

So I just drag the handles to set the range I want.

Now let's see how the formatting is configured. The formatting options that are used most often are located on this tab, and one of the most useful is the cell format.

Now we will set the format in rubles by selecting the item Monetary.

If we need something different, we can touch this arrow and open additional options.

You can continue exploring on your own by simply navigating from tab to tab and exploring the various options. For more information on Office for Android tablets, see the website at aka.ms/OfficeAndroidTabletVideos.

Google Sheets (Google tables) Is a proprietary application for Android from the search giant that will create comfortable work with tables. The program includes tools for organizing the created and edited documents. The main advantage of Google Sheets is that it has support for XLS format created in Microsoft Excel.

Application for full-fledged work with spreadsheets on Android devices. Using this application, you can create new tables and edit existing ones for free and without restrictions, you can format cells, view graphs, use the search function, insert formulas, and save tables in Microsoft Excel format. You don't need an internet connection to use Google Sheets. All changes made are saved automatically, so you can be sure that no important document will be lost. If you have an Internet connection, you can open access to viewing and editing tables to other users. This way you can work together on one project.

Advantage of Google Sheets on Android:

• create tables, edit;
• work even without the Internet;
• you can open access to tables and work at the same time with colleagues;
• sorting and entering data, formatting cells, inserting formulas, viewing graphs;
• replace and search function;
• all changes are saved automatically, so you don't have to worry about the work done.

Work without restrictions with data sets and do not worry about the work done, since the program saves all changes in automatic mode.

Download Google Sheets for Android without registration and SMS by the direct link below.

Google Sheets- installing this program on a gadget will allow you to work with tables where and when it is convenient. With Google Sheets, it is easy and convenient to edit and view accounting documents. Simple tools, familiar work and nice design.

The program will be a very useful addition to the arsenal of Android users who often use data in the form of tables in their work, as well as with Google Sheets you can keep a family budget. Google Sheets are designed specifically for users of electronic devices and makes it possible to work with tabular data arrays.

Despite its portability, the program is capable of serving, filling, editing and storing voluminous tabular documents. The application has a more convenient and intuitive interface, high speed and stability. You can also work with files that were created in Microsoft Excel.

Create new documents, edit existing ones, open access to them to your colleagues. Having opened access, you can work with the whole team, and everyone will save the changes made by his colleague. With the help of tables, for example, you can keep track of the family budget, make shopping lists and write down the price.

Features of Google Sheets for Android:

• adding new table files;
• editing tables;
• saving, editing, viewing Microsoft Excel files;
• you can work without an internet connection;
• insert formulas, format cells, use the replace and search function, sort the data;
• all changes are saved automatically.

Download without registration Google Sheets for Android, without SMS, for free from our website below.

In this constructor it is convenient to generate the simplest HTML comparison tables for websites. You can customize the number of columns and rows, choose a color scheme for the table, enter headers and fill cells with text or suggested icons. When you're done customizing, all you have to do is copy the HTML and CSS tables and paste them into your site.

• Platforms: web.
• Price: free or from $ 3 per month.

Like the previous one, this service is designed to create tables for sites. It is just as simple and convenient. But Compare Ninja offers more design options and can convert tables created in HTML format.

However, the service is subject to restrictions. You can create more than three tables and use more than 10 rows and 5 columns in each of them only after a paid subscription.

To add a ready-made table to the site, you need to copy and paste the HTML-code of the table generated by the service and the design script.

• Platforms: web.
• Price: is free.

Canva Charts saves charts as static images or. The editor has dozens of beautifully designed templates with icons and backgrounds. You can select any of them, fill it with the necessary data and edit the design using various tools. But you cannot control the number of cells. Therefore, you cannot create a table if none of the available templates are suitable for it.

• Platforms: Windows, macOS, Linux.
• Price: from $ 179.

Edraw Max is a professional program for creating various tables, graphs and other diagrams. With its help, you can generate comparison tables of any complexity and save them in a variety of formats: PDF, PPTX, HTML, PNG, JPG and more.

Edraw Max's interface resembles Microsoft's office applications. To proceed to create a table, click New → Charts and Graphs → Comparison Chart and select the appropriate template. Then you can customize its design and content to suit your needs.

The feature of the program is tools for dynamic data visualization. For example, if you change the numerical data in the template, then the graph added to it will be rebuilt for them.

You can download a trial version of Edraw Max to test the program's functions for 30 days.

• Platforms: web, Windows.
• Price: $ 10 / month (web) or $ 297 (Windows).

Another advanced designer of comparison tables and various schemes of any complexity. The results of work can be saved in formats such as SVG, PNG, VSD, or immediately exported as images to Microsoft office programs.

The service contains many fully customizable templates. You can change the structure of tables, enter text data, edit the visual design, and add various shapes and other objects.

The online version of SmartDraw is available after a paid subscription. If you don't want to pay by month, you can purchase the desktop version for a one-time payment.