Google Table. How to create a survey in google form

Answers on questions

Do you have so many data that your eyes scatter from many rows and speakers with data? You are drowning in the sea numbers and can not understand what is happening? Suppose you work in a company engaged in the sale of chocolate in several regions and working with a lot of buyers.

Your boss set you a task - you need based on sales data to determine the best buyer, the most popular product and the most profitable sales region.

Do not hurry to panic and remember how to properly use such traditional functions as the result, they also have similar to them. Relax, take a deep breath. This task is very simply solved using Google's summary tables. The summary table will help submit your data in a convenient and presentable form.

The main convenience of consolidated tables is that the fields in them can be interactively moved, and the data can be filtered in them, group, sort, calculate the results and mean values. You can change the lines and columns in some places, change the levels of view detail. This allows not only to change the appearance of the table, but also take a look at your data under a completely different angle.

It is also important that at the same time your source data does not change - that you would not do with your consolidated table. You simply choose this method of their display, which will allow you to see new patterns and connections. Your data in the consolidated table will be divided into groups, and a huge amount of information will be presented in understandable and accessible to the analysis.

Quick Start Guide on Summary Tables in Google Tables.

That's how, for example, the data about your sales stored in Google Table looks.

Let us open the table in which our source sales data contain. It is important that the data you will use were located on columns. Each column is a specific data set. And each column must have a header. In addition, there should not be combined cells in your source data.

Highlight all your data that you will use to create a pivot table.

In our example, you can simply highlight columns A: G.

Then select Data in the menu -\u003e Summary Table. A new sheet opens on which we will create and edit a summary Google table. You need to configure the content and appearance of your table.

Go to the new sheet created with a consolidated table. While there is no data on it, but the "Report Editor" menu appears on the right. Using this menu, you can add fields to the "strings", "columns", "values" and "filter".

Now simply click on the "Add Field" and select the data you need for rows and columns of a consolidated table, as well as for its values.

For example, we calculate the sale of various types of chocolate in different cities.

In the "Values" field, you can configure the type of calculated results. This may be a total amount, minimum or maximum amount, average cost, number of values \u200b\u200band other options. We use for example a total amount.

The pivot table allows you to show and more complex data groupings. To do this, add several fields to the "Rows" or "columns" field. Here, for example, how to calculate sales and by cities, and by regions at the same time.

Important note: Unlike Excel, the summary tables in Google are updated automatically. But we advise regularly check whether the summary table refers to the entire range of source data.

How to create a summary Google table from several data ranges.

It often happens that the data required for analysis is in different tables. A summary table can be built only by one data range. Data directly from several tables when building a consolidated table cannot be used. What is the way out?

In order to use several sheets in one pivot table, you first need to combine into one common table.

For such a combination of sheets there are various solutions. But, given the simplicity and accessibility, we would like to offer you to use the next addition to Google tables that will help you.

So, our consolidated table is ready.

Use a consolidated table for data analysis.

As you can see, even at the simplest level, the consolidated table already allows you to answer enough important questions.

However, let us return to questions that interest your boss: "Who is my best buyer?"

By acting the old and proven method, change the rows and columns of our table and get the desired result. Do not forget to sort the buyers using the "amount" field.

Similarly, give answers to other interesting questions. For example, what product is best for sale?

Where are my goods best selling?

Where what product is better for sale?

So, for 5 minutes you received the answers to the questions you are interested in the questions. Your boss is pleased!

Please note that the total sales volume of the same in all of our consolidated tables. This is because each of them simply represents the same data in different ways.

How to create a chart in a summary Google Table.

Our data becomes even more visual when using graphs and charts. Add a chart to a pivot table can be in two ways.

Set the cursor to any cell of your pivot table to show that this data you want to use. In the main menu, click Insert -\u003e Diagram. Next, you can choose the type of diagram and change its design. Then click Paste, and the diagram will be placed on the sheet where the consolidated table is located.

That's what you can get by default from the data of our last table, where we analyzed what product where it is better for sale.

There is a second way to create a diagram.

Google tables have an additional service that has not previously been in any of the work programs with the tables. In the lower right corner there is a "data analysis" button. By clicking on it, you can get different tips and suggestions for improving the presentation of your data, analyzing them, including the creation of charts.

Click the icon in the lower right corner, and you can not only select the most appropriate diagram from several proposed, but also change the design of your pylon table.

Returning to the questions that we have previously asked, we receive a chart that shows not only the volume of purchases by each of the buyers, but also gives an idea what kind of chocolate prefers the buyer.

Please note that the system analyzes your data and even notes the individual patterns that you yourself may not pay attention to.

Now it remains only to edit our diagram, give it the most visual and read view, arrange the signatures of the axes and data. How to do - we will talk about it in a separate material a little later.

How to publish a summary Google table or chart on the Internet.

You can publish your chart on the Internet. To do this, in the main menu, click File -\u003e Publish on the Internet. Then select those objects you want to publish. In our case, we can publish either the entire file or a separate sheet, or only a diagram. If we choose the list of our Google Tables file, we can submit it either as a web page or as a static document in PDF format. If we want to publish only a diagram, then the option is also two. Either this will be an interactive diagram that will change with the change in the source data, or you can simply be limited to a picture showing a picture of the chart at a certain point in time.

Naturally, any version of the publication provides for only the viewing mode, nor about how to work on the diagram or making changes to your colleagues does not matter. To do this, use sharing to the file that we told in detail.

With the help of the same menu, you can cancel the publication.

I hope this small overview of the possibilities of Google's summary tables will inspire you to use them with your own. Believe me, you will immediately understand how it is easy and convenient. Consolidated tables will help you save strength and time. It will be important for you that the report created today can be easily updated and used in the future with new data.

Hello, dear blog readers Website. Many of you are confronted with the need to create any document, draw a table and something else in the same way. What do you use for this?

Oh, of course, there are popular programs that are available on almost every computer, such as, for example, Word, Exel, PowerPoint, open office and many others, including online version (cloud) some editors.

Yes, they are undoubtedly good, but not when over this project, a table, an online presentation is still worth getting drunk to bring to mind, and you work on a project not only you, and your colleagues who cannot be all You have time under the side. Here for this your indispensable assistant and can become free and multifunction program from Google. Let's get acquainted.

What is Google Doks?

Many of you, and I am used to work with various documents in such office programs, such as Word, Exel, or PowerPoint, which first need to install to your computer.

All this is just wonderful if the file is intended only for you. And if you are limited, for example, in time? If you need this is the most text file or a presentation to someone urgently show, and so that this someone makes the necessary edits without delay? That's it for this and necessary free Online Google Docs Servicewhose capabilities we will try to consider in this article.

You probably have already guessed that the developer of this miracle is no one as Google himself. Google Dox does not require installation on a computerIn addition, Google documents or tables are automatically saved on a special server and you can view them from any computer (you just need to know the password to enter and have access to the Internet, but about it just below).

What else can online service google documents? But what:

Several people can work with Google documentswhich was opened to access. They can make any edits, leave comments, communicate with real-time chat.
Supports a large number of popular formats (for example, DOCX, PDF, ODT, RTF, TXT, HTML).
History is preserved Everyone ever introduced edits in Google Doks (suddenly you will need to return a few steps backwards, to an earlier version that has not yet been exposed to).
maybe creating and editing Google Documents on iPhone, iPad and Android
If necessary, work is possible and offline (without the Internet).
There is the ability to select access rights for each user or for individual groups. That is, someone can allow text editing or table, and someone can only give the opportunity to view and leave some comments to them.

Google Documents - Creating and Editing

In order to create a text file, an online table or a presentation, you do not need to install any software, everything is created directly in the browser used (learn about, popular, well-known, new), as well as with one file several people can work at once (everything changes will be saved automatically).

For a start, go to the page create google document And click on the icon with three drops in the upper right corner:

We offer a list with what we want to create: document, table, presentation, form and further on the list:

This looks like a window in the Firefox browser. In the Chrome browser tabs with the choice of creation are right on the main page:

In the window that opens, we can view the already existing documents from us (if such have place):

Creating a presentation online from Google

Here you can create various presentations, work on them, edit themAnd all this simultaneously with your colleagues, being from each other at a respectful distance. And most importantly, that all this can be done absolutely free!

Click on the big blue button "Open Google Presentations":

After that, as in the previous cases, we click on a large red button with a plus located in the lower right corner.

Choose the topic of online presentation In Google and the size of the slide (widescreen or standard), click on OK:

We give our online presentation in Google name and with the help of a plus choose layout Our future slide:

Also choose the font liked us, its size, color, can also be aligned with italic, make a bold or emphasize (see screen above).

Then we enter the title and subtitleBy putting the mouse cursor in the appropriate fields. If desired, grasping the mouse for the dedicated squares, we can increase / reduce our text, as well as turn it right or left:

Program features for online presentations in the Google Docs service

What opportunities is hiding from us a free Google program? Let's see:

there is a rollback a few steps back (or forward), as well as print
copy formatting
cleaning the canvas in size
mupa is responsible for changing the scale
enter text or insert image
insert the shape, a wide arrow, tuning, formula (there is a good selection of listed characters)
paste line, arrow, corner and curved connectors, curve, broken line and doodle
insert a comment
configure methods input
on the Advanced tab, you can change the mockup background, the whole layout, change the topic of your presentation, add Animation Transition Between Slides (Insert the darkening, add a coup, gallery, etc.)

The "File" tab in Google Dox allows you to create anything (online document, table, presentation, form, drawing, can offer to choose something from the existing rich Galleries templates from Google). Here you can rename your creation, create a copy of it, move to another folder, delete, import slides. Well, and, of course, view the history of all changes made, choose the language, download, publish onlinesend co-authors and attach to a message in email.

The Insert Tab includes the following options:

By selecting the appropriate command in the presentation program, you can insert any text to the selected slide, add an image, video, link (), line, shape, table. You can also put the numbering on the Google Docs slides and add comments. Well adding a new slide in an online presentation of Google Doxand their imports are present.

On the Slide tab, all work with slides is carried out. This is the addition of a new slide, and duplication, and deletion. Here you can change the background, layout and change the topic, insert transitions between slides and change the entire template.

Choosing, for example, text or image on a slide, it can move from the back plan to the front (and vice versa), turn, group and ungrade. All of this you will find on the "Arrange" tab.

Creating a form google doks

We have previously considered in detail about how to add this most Internet survey to your site and how to view the results of the survey and make any changes (edit), so I will explain short.

To conduct any online pollsand then get a table with the results of these most polls, and completely is free, go to the tab creating a form google dock :

After that, click on the big blue button "Create Forms":

The following window opens creating a new form google:

Here you can add a survey:

Select the topic:

Set some settings:

Get and view individual answers:

We enter a question without a header (if you put the mouse cursor to this field, then there is an image inserting the image - take a picture, insert a URL, drag the mouse from the computer), and the type of question (text, list, scale, grid, date, time):

On the right there are several other buttons, with which you can add a survey, name, description, image, video and section:

How to publish Google Documents, Tables, Presentations and Pictures

If you look in the settings, you will notice a very important detail: the publication is possible not only of the entire document, but also separately with its part. For example, you can publish only individual sheets. As for the online presentation, there is an opportunity to select the slide change speed. And relative to the picture - you can choose the size of the image published on the Internet.

After you click on "publish," you will have a link that you want to insert into the code of your site, blog, online store.

There is another very interesting thing that concerns the publication of the Google Table - changing the visibility of some of its elements:

Amendments to the already published document

By entering any changes (editing) to the source document or online table in Google Docs, you can be sure that these the most entered changes will also be displayed in the published copy. But this can be avoided if you do not need it.

To do this, you select from the menu "File" - "Publish on the Internet" from the menu, then click on "Published Materials and Settings" and remove the checkbox in the Automatically publish after amending field:

Cancellation of the publication of Google Docta on the Internet

Open the file whose publication you want to cancel. Then go to the "File" menu and choose the "Publish on the Internet" item there. Come in again in "Published Materials and Settings" and choose the "Cancel Publication" item.

How to set up rights to google documents

Without configuring rights, other users will not be able to make any changes to the document you have published. For example, in the google documents, the toolbar will be unavailable, in the tables also (all sorts of charts, the formatting of the cells and their meanings can be seen, but cannot be changed). As for the online presentation, users will be able to see either a version for viewing, or see it in full screen mode. So to avoid all this, we can for some of our project colleagues configure the rights to publish a file.

We open the document you need and in the upper right corner we find the "Access Settings" button:

After that, in the window that opens, we find the "Extended" item and activate the item "Prohibit editors to add users and change access settings", click on "Save". Now users will be able to publish a file, as well as engage in editing it.

On this, I think, you can complete our acquaintance with this free and promising program from Google. Good luck in mastering!

Good luck to you! To ambiguous meetings on the blog pages Website

Services

If you have an account in "Google", then most likely, you have repeatedly met the branded "disk" and the "Documents" service. Thanks to these applications, the user can store files in the cloud and create them online without installing any additional programs.

To sort out how to create "Google. Table ", you need to register an account in the service and start working with it.

Documents

The main advantage of Google Documents service is free use. It was developed by Google and initially consisted of two independent services - Writely and Google Spreadsheets. Later, the functionality began to expand, converting an application into an analogue of a popular package from Microsoft. Since 2012, the version for mobile devices has appeared.

As mentioned earlier, to create a table in the "Google", additionally download anything to the PC. At your disposal should be a web browser and the Internet. This is due to the fact that the software web is oriented.

All created files are saved in the cloud, in a specially designated place on the company's server. They can be converted to files, transforming into the desired format.

Benefits

Before you figure it out, how to create "Google. Tables ", you need to understand why many users are preferred now. First, the application does not require additional installations and downloads, it is absolutely free, and everything you need to make the user is to go to your Google account and start work.

Secondly, since the work is carried out via the Internet, it is possible to configure access to other users to the document. This helps several people to make their edits to the project. Often, several users can work immediately with a presentation, making changes and consult in the course of work.

Thirdly, the created files are always on the server, which means access to them is open from any PC. So, being at home or at work, you can easily get the desired document from the cloud and continue to work with it.

Beginning of work

How to create "Google. Table "? The instruction says: first create a Google account. You will have the opportunity to use all the company services: view "Maps", use "YouTube" to fully, upload games for a smartphone with Google Market, make a selection of news, work with mail, calendar, etc.

Among all this there are "Documents". Go there and consider the capabilities that this service provides. The user must first be "logged" in the "disk" so that all files created by them are in one place.

The user is given a choice: work with "Google. Tables "," documents "or" presentations ". Click on the desired service and go to a new window. To create a new file, it will be enough to click on the "plus" in the red circle in the lower right corner.

A familiar field appears, which no different from the Microsoft Excel file. There are almost all the same tools, and if you worked earlier with tables in the program from Microsoft, then it will not arise difficulties. The only one, the online service has several limited functionality. But the set of options will be quite ordinary users who do not use complex algorithms.

Editing

"Google Doks. Tables "provide the user a lot of opportunities. The main thing is editing rows, columns, cells. For example, we need to add a string. Select it by clicking the right mouse button and click on the "Insert string" option. If you need to add several lines at once, then several items are also needed.

You can change or move column or string. To do this, do the same thing as before, only from the dropped menu choose "Change Size". A window will open in which it is enough to choose the values \u200b\u200bfor the parameters.

To secure the string in "Google. Tables ", you need to select it and go to the toolbar. In the "View" tab, the "Fasten" option will be. Now the desired line will always be in a prominent place, and you will not lose it throughout the data array. To respond, you need to do the same, only instead of "consolidate" click on "not fix it ...".

It is not necessary to do anything supernatural to move. Select a string or column for transportation. Click to the "Edit" point and move the item to the desired location. To transport cells, choose them enough and just drag.

Formulas

Advanced users know that for quick and easy use there are formulas in "Google. Table. " They do not differ from those that provide Microsoft and a number of similar editors of spreadsheets for their users. The list consists of a huge number of commands that can be entered. It's not necessary to know the usual user. Most need for miscalculations and mathematical operations.

All formulas are divided into several groups. There are mathematical functions to which the usual operations with numbers include search, which helps to move on the table. There are functions for working with arrays, symbols, logic, etc.

Access

As mentioned earlier, the main advantage of online service from Google is its availability. You can create a file that after to show colleagues, the movement of them just a link, or work together over one project.

To do this, it is enough to understand how to create "Google. Table "with shared access. It turns out that there is nothing difficult. After you have created a document, in the upper right corner, click on the blue "Access Settings" button. A new window will open. Here you can enter the names or email addresses of your colleagues who want to access, or choose from above the "Enable access link" function.

If you have chosen the last option, you can configure and powers for people who will come to look at your table. You can enable colleagues just to view data, leave comments to or participate in editing. After you copy the link and transmit to other people.

findings

Work with "Google. Tables "Very simple. Online service gives many opportunities for those who appreciate time and workload. Documents, tables and presentations are common applications that are often needed by students, freelancers, office workers. You do not need to download additional programs, download PC memory.

You easily work with tables, and after you can download the file in the ".xlsx" spreadsheet format, and besides this, in ODS, PDF, HTML, CSV and TSV formats. Or save the electronic version of the document and have access to it from any computer on which there is a browser and the Internet.

Hello everyone, this is the very first article of this blog and in it I will cover the main points of use of Google tables. From it you will find out - how to create a new google table, how to edit it, save, add new users, copy, delete from Google disk and other information.

For your convenience, I will place quick links to sections, click on them, you will quickly go to the question for you:

Creating Google Account

So, in order to start using Google with tables, we need to have an account in Google services. If you have an account on Google, then you do not need this section. And if not yet started for some reason, then you need to go to the page Google and in the upper right corner click on the button To come in:

The entry page of Google Account opens, however, we need not to log in, but register.
To do this, press the input to the link below. Create an account:

Later, I will write a separate post, where we consider the possibilities of Google Account. Let's try to figure out the hidden facilities of Google services that can be controlled from your account.

Google Table Login

So we got to an important point, now we will understand how to enter the Google table.

After we have already brought the account with you in Google, we can open tables in several ways:

The first and easiest way is to go through this link Google Spreadsheet
The second way is intuitive - just thug: "Google Tables"

Now you can proceed to work in Google tables.

How to create a google table

So, we opened the startup page of Google Tables. Let's now make a new table.

In order to create a new table, it is necessary on the main page to click on the floating red button with the sign (plus) to the right at the bottom:

How to give Google Table

To do this, we just need to put the cursor in a special field at the top on the left in the table, where the default is written New Table And enter your name:

After clicking on ENTER or simply putting the cursor anywhere in the table your name will be saved. Now a line with the name of our table will appear on the Google table start page. And every time you come to this page you will see all your saved tables:

Very convenient, isn't it?

How to add additional pages and hide them in Google Table

Now let's create additional pages in our table and then let's try to hide them.

Let's go back to our table and at the bottom of the monitor screen will find a button with a + symbol (plus):

By clicking on it we will add a new page. As a result, we will see two tabs with the names of the sheet1 and the sheet2. Not very sounds, in my opinion, a little later we will call them a clear name.

But before this, let's hide pages from extra eyes. To do this, click right-click on the tab or triangle on the tab and select the item in the pop-up context menu Hide sheetAs a result, we get this picture:

Hurray, leaf is hidden! But how to restore it now?
Very simple - you need to go into the control panel and go through the path in the menu - View -\u003e Hidden Sheets -\u003e Your Hidden Sheet:

The sheet will return to its former place.

How to give name pages in google table and paint them in color

Let's give the names to our pages. You can do this at least two ways:

Click right-click on the tab and select the Select Context menu Rename…
Climb the left button on the icon in the form of a triangle on the tab and also select the command in the context menu Rename…

After entering the name, as well as after the name of the entire table, you can click ENTER On the keyboard or simply put the cursor in some cell and the name will be saved.

Once, you may have so many pages in one table that they all will not be placed in one screen and in order to quickly move through the pages, you can click on the button resembling the menu symbol on mobile devices, it is located next to the page of adding pages. By clicking on it there will be a list of all available pages in this table. The active table will be marked with a check mark, you can only select the desired and click on it in the menu.

In addition to renaming pages, they can be painted in the color you need.
Suppose the timeline of Dedlinov can be painted in red and we are always among many pages instantly find such an important page!

To do this, do similar activities as when renaming, only selecting in the context menu Rename, and Change color:

And choose the desired color. Semit Custom colorWe will be prompted to enter a custom color number.

How to edit google tables

So they got to the point when it was time to edit the table, add data to it: text, numbers, formulas, functions, etc.

In essence, the Google table is an Excel analogue, but there is, of course, the differences between them. About the differences between Google Tables and Excel Talk to another article. In the meantime, let's start editing the Google Table.

Working with data in Google Table - Adding, Copying and Removal

In this chapter, we will learn to work with Google tables and data in them, namely add, copy, delete data, insert comments and notes, manage them.

Add data to Google Tables

Of course, I will not open Binin Newton if I say that adding text, numbers and formulas in Google table as easy as in Excel. But just in case I remind you.

In order to add any data to the table, you must open it, insert the cursor to the desired cell and start typing text or number. In addition, you can enter data and in the formula string, which is located there where and the line of formulas in Excel.

The numbers as in Excele after entering are aligned on the right side, and the text on the left side of the cell. But alignment can be changed using the alignment tool.
To do this, select the cell or range of the cells in which you want to change the alignment and click on the toolbar on this icon:

In the dropping menu, select the value as you want to align your data - on the left, in the center or right.

How to Copy Data in Google Table

How to copy and insert data inside Google tables are known to everyone, I think: select the desired range of cells, press the keyboard shortcut Ctrl + C. , put the cursor in the desired cell and click Ctrl + V. - This is the easiest and fastest way, it works in all office products, not only in Google.

In the same way, data from Excel in Google Tables are copied and inserted, but there is a significant nuance:
Formulas are not transferred from Excel to Google tables, but only the result of their work. Therefore, so that all the data worked as in Excele, you must and open the file in Google tables. How to do it I wrote a little lower.

Delete data in Google Tables

Everything is as easy as in Excel: select the cell or range, click on the keyboard Delete. . If you have some kind of cells formatted, for example, the color, then the delete press will not be enough.

To remove the formatting of the cell or the range in Google tables, you must select the desired range of cells and select: Select: Format -\u003e Clear Formatting or push the keyboard key Ctrl + \\ On your keyboard.

Comments and Notes in Google Tables: Adding and Removal

In Google tables, in contrast to Excel, you can add to cells and notes and comments.
Only notes can be used in Excele. Let's see how to add one and more and try to figure out what the difference comments from the note.

How to add a note in google tables

To add a note, you need to highlight the cell to which we want to add a note, and make one of the manipulations to choose from:

Insert Note
Select on the menu panel item Insert -\u003e Note
Press the keyboard key SHIFT + F2.

How to add a comment on Google Tables

It is also necessary to highlight the cell and carry out one of the manipulations below to choose from:

Click right-click on the cell, select in the context menu that appears Insert a comment
Select on the menu panel item Insert -\u003e Comment
Press the keyboard key Ctrl + Alt + M

In both cases, after adding a note or comment, a small triangle icon will appear in the upper right corner of the cell, which will give you to know that there is something there.

In addition, on the Page tab, if there is a comment, a hint appears in the form of a number, meaning the number of cells on the page in which there are comments. And when you hover on this cluster, all existing comments will be "highlighted" so here:

So what is the difference between comment and notes in Google tables?

That's where all the charm of working with online tables is revealed. In addition to the above-described features of comments on the tabs of the pages, on the comment you can get a hyperlink, which can be given to colleagues:

And those in turn can give an answer to your comment by clicking on your link.

In addition, notifications of new answers will be received by the participants of such a "conversation". Of course, this is necessary for the participants to be logged in Google accounts and have access to this table.

In my opinion, that such features are one of the most important reasons why it is worth using online table service and first of all Google Tables.

Removing notes and comments in Google Tables

Everything is simple, if we are talking about a note, we allocate a cell where there is a note, the right click of the mouse call the context menu and select the item Delete Notes.

Delete a comment is also not difficult, it is necessary to hover the mouse over the cell with a comment, the entire correspondence with colleagues will pop up and you need to click on the button The question is resolved:

After that, the entire comment chain will be safely removed from the cell. But at the same time, the correspondence will be saved just in case. You can find it on the right at the top of the screen next to the button Access settings:

Pressing the button Comments You can see the entire history of correspondence and even continue the conversation or return the comment on the previous place if there is a need.
And there you can customize alerts:

A completely stunning tool for collective work in Google tables.

Data Protection in Google Tables

Often there is a need to protect data in tables, you can protect the entire table, page in your workbook and separately taken range of cells.

What is it done for? It happens that by chance one of the employees will edit the data on some sheet or range, it can happen at all by chance and the one who did it will not even know about it. Move later in the history of changes the option is so-so, honestly. For this, it is possible to protect data in Google tables. Let's see how it can be done on the examples.

Protecting the entire book in Google Table

In order to protect the entire workbook from editing, you must click on the right at the top of the screen on the button. Access settings And then specify people (account in Gmail) and access level - editing, commenting or reading:

In this case, we are interested in reading - this means that people gained access to your table can only view it.

Google Protection Table

Suppose you want to protect not the entire table, but only one of the pages, in this case, you need to make a couple of simple steps.

Select the list you want to protect, click on the triangle on the tab and select the item in the pop-up context menu Protect sheet ...:.

The Sidbar will open to the right screen:

Here and we will set up protection.

Field Enter description It is not obligatory, this is for your convenience that you understand what data you protect, so to speak a kind of label for you.

Now we are invited to choose which is a sheet to protect, we have already selected a sheet2, because it was on the tab it we clicked when they chose item Protect sheet.

Below we are invited to celebrate the cells that you want to leave not protected (very convenient). If we activate this checkbox, then we will be prompted to select the range of cells, the default cell is specified or the selected range in our table. To select a different range, you must click on the icon in the form of a small table and highlight the desired range on the working page:

Or specify manually the desired range to the left of the icon with the table.

Press OK..

Click on the button below Set permissions And proceed to the most important thing - the protection of our sheet.

A modal window will appear with the access settings for the resolved range:

If you choose the first Radio Button, then access will receive anyone who has access to the entire table as a whole, but they will see a warning that they are trying to edit the protected range and they will need to confirm each time their actions. And you will receive notifications about new actions in the protected range.

If you select a second option, we will be asked to add editors. The default in the drop-down list is worth Specify ... And below the field for entering an email of the future editor. In addition to specify option, there are other options:

Only you
Import list of editors ...

In order to remove protection, you need to right in the sidbar click on the desired range:

All settings will open again, click on the basket icon:

Protection of a specific range of cells in Google Table

The range protection is practically no different from the protection of the sheet, the difference is only in the first actions.

You need to highlight the range that we want to protect, right-click Click and in the pop-up context menu select Protect band:

And repeat the actions described in the previous subsection.

Once you need to cancel the range of range, but you completely forgotten where this range is completely.

In this case, go to the next way in the menu - Data -\u003e Protected Sheets and Ranges ... And the right will open Saydbar with all the protected ranges available on this page:

You will only only choose the desired and click on the icon. Basket.

Cancel action in Google Tables

Canceling actions in Google tables works as well as in any Office application, the difference is only in the design of the interface. In Google tables it looks like this:

Or cancel the action can be classically using the keyboard: Ctrl + Z.

How to save google table

Save data to date in Google tables are not necessary. The service automatically saves the data after any of your action. But if we talk about saving the entire table on your Google disk, then this is another matter.

To save your Google table to some kind of folder on your Google disk, you must click on the top above the control panel icon as a folder:

A small window will open, where you will be prompted to select a disk and folder to move this table. In addition, you can create a new folder directly from here. Let's try:

Click the Move the object:

Click on the arrow to the right of my disc:

Click the icon of the new folder (if you need to create a new one):

We enter the name of the new folder and click on the blue tick:

Here is the whole procedure for saving the Google table in the desired one or a new folder on our Google disk.

How to change the scale of the page in Google Tables

The scale has been shifted relatively recently in Google tables and this can be done as follows:

We go through the menu: View -\u003e Scale.

In addition, you can select a full screen table display mode. To do this, select the menu item on the control panel View -\u003e Full Screen. After this action, the tool control panel will be completed. Simply put the top menu panel will disappear.

In order for the viewing mode to return to the previous form, it is enough just to click on the keyboard ESC .

How to import an Excel file in google tables and edit it

Very often there is a need to transfer all the data from Excel to Google Tables. There are different reasons for each other, but they are all about one main reason - online tables allow us to carry out a collective work in real time, with the possibility of adding, alerts on the mail about various actions in tables and many other reasons.

You can, of course, simply copy the table using simple actions. Ctrl + C. and Ctrl + V. But as I already wrote above, this method is not very good - if your table contains important formulas, they simply are not copied to the online table on Google.

Therefore, let's look at the version of Excel's imports of the table in your account on Google tables.

The paths for importing XLSX files in Google Tables are two - fast, simple and more long, consider both:

That's all! The Excel file was imported into your Google tables, and now you can now find on the main page of the Google tables and on your disk. It can be moved to other folders on Google disk and download again to the computer. And how to do it, I will tell below.

Google exports

Of course, Google could not help but envisage the possibility of unloading Google tables to your computer. And you can easily do in different formats!

To upload your Google table to a computer, click on the Control Panel Sequence of the menu items - File -\u003e download as And select the format you need:

As you can see, the formats that Google offers must satisfy almost any user requirements with any goals.

View changes in Google tables

Google tables have a change history view feature, in case someone from the team or hesitated, you can view the changes and restore the desired version.
Let's deal with how to do it.

To view your history of changes a lot of actions do not need to do, it is enough to make a few clicks in the control panel, namely, here's the way - File -\u003e View Change Story or push the keyboard key Ctrl + Alt + SHIFT + H :

Now let's see what the history viewing interface looks like and understand how to restore the version you need.

After we entered the history of Google Tables, we will see this page:

Left at the top We will see that the control panel curled and instead of it History of change With the arrow, by clicking on which we will return back to our current table.

Sidebar opened on the right with the management of the story itself. The first item will be active, he suggests that this is our current version of the table. Below are the steps of history in the reverse order, but this is not the most detailed story.

At the very bottom you can see the button In detailsIf you press it, a list will open with a more detailed history.

Besides the button, see Chekbox Show changes - From the very name it is clear what role he performs.

Click on the points of history We will see the changes that our table has undergone, we will see the link Restore this version:

Very important moment! If you have several pages in the table, then be attentive "walking" on history, one of these "points" of history may unexpectedly switch to another page (tab) in your table, which can confuse.

In order to see the story of the pages of interest to you, just go to her, if suddenly you did not need it.

How to change the language in Google tables into Russian

There is something that registered, and the Google interface is not Russian, but English, for example. If you encounter such a problem, then this chapter is for you!

This problem is solved quite simple, I specifically translated the language of my interface in Google tables into English to show you how to make it Russian.

Close this page, we return to the previous one with our table and simply update it by pressing F5 on the keyboard.

Ready! Enjoy the Google Tables in Russian.

How to open sharing Table Google

In part, we already considered the above how to give collective access to our Google tables. Let's now understand once and forever in all the intricacies of access to Google Table.

After creating and editing a table, we may need to provide access to colleagues, partners or customers. Consider two options - fast simple and advanced.

Simple and fast option:
Click on the right at the top of the screen button Access settingsA modal window will open in which we will be prompted to enter a name or email of the people we want to open access. A little relevant field for entering this data there is a drop-down list with access levels:

In it, the default is access to editing by clicking on the pencil icon, you can select the access level.
Editing is the highest access level.
The second option to access Google tables is more advanced.
Click at the bottom of the modal window to text Extended:

You can directly change the owner of the table (if people have already added):

You can also invite new users by pointing their email.
And at the end two checkboxes:
- Disable editors to add users and change access settings;
- Prohibit commentators and readers download, print and copy files. If you have specified before that, the table is available on the link, you will not be able to change the level of access to extended settings, and if you indicated that only by invitation, then you can change the access level by clicking on the link Change.

How to send Google table by mail as a file

Another very convenient feature that is only in online tables such as Google is sending a document by mail file. The file can be only two types: PDF and XLSX.

Let's send our table to your colleagues or customers.

In order to send our table as a file, you must select the following items on the control panel. File -\u003e Attach the email to the message. Mail:

A modal window with send settings will open:

Attach - Here you choose PDF or XLSX format
Kom. - Indicate the email of the recipient
Topic - The name of our table is automatically substituted.
Message - You can add a message, for example, with explanations that this table contains.
Chekbox send me a copy - Everything is clear here.
Zhmem. send.

There is one small minus in this feature - letters are sent only to Google accounts with Gmail by mail, I have no way to send Yandex to me.

How to delete google table

Well, we got almost to the end of the article, now we will learn to delete our Google table.

Over time, you will have a fair number of tables and some will be no longer relevant and if they are not needed at all, then why do they take a precious place for Google Disk? In addition, the space is not rubber and has quite concrete boundaries - 5GB in a free account.

You can delete Google table at least two ways: We delete being right in the table and remove the google tables from the main page.

Consider both options:

In the sliding menu Delete.

Note. Only the owner can delete the table, along with it you will lose access to the file and collaborators of the table.

By the way, there is such a button and co-authors are not the owners of the table, and it can even press it, but the table will not be removed, it will only for a while (until the next visit to the main page google tables) will disappear, then it will be displayed again. At such a case, Google provided the opportunity to filter files.
You can filter files on the principle of your own - strangers - everything is in a row.

To filter the tables to go to the main page of the Google tables, find the above drop-down list with the mark Owner:

Default will stand AnyoneClick this button and select filtering conditions.

In my opinion, this is not very convenient that I can't delete the tables from my list, but only filter them.

How to restore google table

Surely, many had such a situation ever accidentally deleted the file, or deleted the table, thinking that she would no longer be useful, but then it turned out that she was needed again for one reason or another. And how to restore the Google file of the table or another document you do not know.

In this chapter, we will restore together, it would seem that the lost Google files of the table.

First of all, go to the Google Disc page:

In the left menu find the basket icon and click on it:

A page with remote files will open, where we need to right-click on the file you are interested in and select Reestablish:

So the article approached the end, I hope it was helpful. If I missed something, then write my questions and wishes in the comments, I will definitely add an article.

A number of users who work closely with Excel tables may need to create an excel table on a computer on which Microsoft Office is not installed (and therefore Microsoft Excel). Problem? Not at all! In the creation of the specified table you will be helped by popular network services, allowing you to easily create an Excel table online. In this material, I will tell you how to run Excel online, what services will help us, and how to work with them.

The network has several popular network services that allow not only to open an Excel file online, but also create a new exile table, edit it, and then save to your PC. Usually they have a fairly similar to MS Excel functionality, and work with them will not create any problems for users who have already had a previously dealing with the MS Excel stationary editor.

To register on such platforms, you can use the user account login and password on social networks (for example, on Facebook), or pass the standard registration procedure via email.

Use the Exceel functionality

I like working with documents, tables and create presentations online, without installing a plurality of programs on a computer, so I created a selection of the best services - and.

Let us turn to the list of services that allow you to create Excel's tables online online. Some of them are quite actively working with cloud services, therefore can copy the user-created tables there, and from there the user can download the table created by them to the computer.

Office.Live - program to create and edit tables

This service from Microsoft makes it possible to access MS Office features online, and completely free. In particular, you can use the MS Excel network editor functionality that allows you to create, edit and save tables online in popular formats of this editor (, XML and others).

To work with the editor, go to the specified resource https://office.live.com/start/excel.aspx.
Select "Sign in with Microsoft account."
And create an account (or use your account credentials in Skype).
Next, you will open the basic template screen to create an Excel table. Click on the "New Book", and you will go into the creation mode and edit your table.
To save the result, click on the File tab - "Save As" - "download a copy".

Google Tables - allows you to add graphs and charts to Excel

Google Docs is a network online service from Google with rich opportunities, including allowing you to work with Excel, view the appropriate file formats (XLS, XLSX, ODS, CSV), create graphics and charts, and so on. To work with this service, you must have an account in Google, if you do not have it, then I suggest you to create it.

To take advantage of Google Docs features, go to this resource https://docs.google.com/spreadsheets/u ///, and enter your account data in Google.
To create a new document, click on the "Blank" (rectangle with a green plus card), and you will go to the Excel table creation mode.
The interface of the English-language service, but for users who had previously deal with Excel, work with Google Docs will not deliver special problems.
To save the table you created the table, click on "File" - "download as" and select a convenient file saving format (for example, XLSX).

Zoho Sheet - program to create spreadsheets

Service with the support of the Russian language, which has all the necessary functionality to create Excel tables. The service is able to almost everything that his competitors - works with most excel formats, supports the collaborative editing of the document by several users, allows you to build graphs and charts and so on.

https://www.zoho.com/docs/sheet.html.
Click on the "Create SpreadSheet" button (you may need your account in Google), and you will go to the table creation mode.
You can save the result by clicking on "File" - "Export as", and selecting a file convenient for you (usually "MS Excel Book").

EtherCalc - opens the files.xlsx, .xlsm i.xls

Among the advantages of this service, I would notice the ability to work with Excel tables without any registration, support for parallel editing of one table by several users, convenient functionality, as well as many other advantages to work with Excel online tables in Russian.

To work with this service, go to it https://ethercalc.org/.
Click on the "CREATE SPREADSHEET" button (Create a spreadsheet).
You will go to edit mode, and you can create a table you need.
To save the final document, click on the image with a disk on the left, select Saving Format, and download the table to your PC.

Work window of the service "EtherCalc"

Yandex.Disk - Simple work with Excel online

Domestic company Yandex pleased the user with the opportunity to create and edit an Excel online document using a special service to Yandex.Disk. In its functionality, this service is a copy of Office Online (the first of the network services described by me), at the same time, according to user reviews, there are sometimes problems in the work of large formulas from Yandex, bugs occur, the service does not work well with Excel files created in MS Excel until 2007.

To work with this service, go to it https://disk.yandex.ua/client/DISK (you may need to register for Yandex).
Click on the "Create" button - "Table".
You will go to the mode of creating and editing the table.

Conclusion

To work with Excel online it is worth useing online services listed by me above. All of them are free, support (for a low exception) The Russian-speaking interface, according to its functionality, is almost not inferior to the stationary version of MS Excel. If the reader was urgently created to create an exesel table, and the computer with the MS Office installed at hand was not at hand, then it is worth using the functionality of the network tools described above, which allows you to effectively solve this, and similar to it, tasks.

In contact with