Google sheets create a new cell style.

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

For your convenience, I will post in each article Quick links by clicking on sections, you will quickly go to the question you need:

Create a google account

So, in order to start using Google Sheets, we need to have an account in Google services. If you have a Google account, then you don’t need this section. And if you haven’t started it yet for some reason, then you need to go to the page Google and in the right top corner press the button To come in:

The Google account login page will open, but we don’t need to log in, but register.
To do this, click on the link at the bottom of the login form Create an account:

Later, I will write a separate post where we will look at the possibilities in more detail. google account. Let's try to understand the hidden powers of Google services that you can manage from your account.

Login to google sheets

Now we have reached an important point, now we will figure out how to enter Google tables.

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

1. The first and easiest way is to follow this link Google Spreadsheet
2. The second method is intuitive - just google: Google Sheets

Now you can start working in Google Sheets.

How to Create a Google Sheet

So, we have opened the Google Sheets start page. Let's now make a new table.

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

How to name a Google Sheet

To do this, we just need to put the cursor in a special field at the top left in the table, where by default it says New table and enter your name:

After pressing Enter or simply by placing the cursor anywhere in the table, your name will be saved. Now on home page google tables a line will appear with the name of our table. And every time you visit this page you will see all your saved tables:

Very convenient, isn't it?

How to Add Additional Pages and Hide Them in a Google Sheet

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

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

By clicking on it we will add new page. As a result, we will see two tabs named Sheet1 and Sheet2. It doesn’t sound very good, in my opinion, a little later we will call them by a clear name.

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

Hooray, the sheet is hidden! But how can I restore it now?
Very simple - you need to go to the control panel and follow the path to the menu - View -> hidden sheets-> your hidden sheet:

The sheet will return to its old place.

How to title and color pages in Google Sheets

Let's give our pages names. This can be done in at least two ways:

1. Right-click on the tab and select from the context menu Rename…
2. Left-click on the triangle icon on the tab and also select the command in the context menu Rename…

After entering the name, as well as after naming the entire table, you can click Enter on the keyboard or simply place the cursor in some cell and the name will be saved.

One day you may have so many pages in one table that all of them will not fit on one screen, and in order to quickly move through the pages, you can click on a button resembling a menu symbol on mobile devices, it is located next to the add pages button. By clicking on it, a list of all available pages in this table will pop up. active table will be checked, all you have to do is select the one you want and click on it in the menu.

In addition to renaming pages, they can be painted in the color we need.
Let’s say the deadline schedule can be colored red and we will always instantly find such an important page among the many pages!

To do this, you need to perform similar actions as when renaming, only select in the context menu not Rename, A Change color:

And choose the desired color. By selecting Custom color, we will be asked to enter a custom color number.

How to Edit Google Sheets

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

At its core, a Google spreadsheet is an analogue of Excel, but, of course, there are differences between them. We'll talk about the differences between Google Sheets and Excel in another article. For now, let's start editing the Google Sheet.

Working with data in a Google Sheet - adding, copying and deleting

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

Adding Data to Google Sheets

Of course, I won’t open Newton’s binomial if I say that adding text, numbers and formulas to a Google spreadsheet is as easy as adding it to Excel. But just in case, I’ll remind you.

In order to add any data to the table, you need to open it, insert the cursor into the desired cell and start entering text or a number. In addition, you can enter data in the formula bar, which is located in the same place as the formula bar in Excel.

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

In the drop-down menu, choose how you want to align your data - left, center, or right.

How to copy data into a Google Sheet

Everyone knows how to copy and paste data inside a Google spreadsheet, I think: select the desired range of cells, press keyboard shortcuts Ctrl+C, place the cursor in the desired cell and click Ctrl+V- this is the simplest and fast way, it works in all Office products, not only from Google.

In the same way, data is copied and pasted from Excel to Google spreadsheets, but there is a significant nuance:
Formulas are not transferred from Excel to Google Sheets, but only the result of their work. Therefore, in order for all the data to work as in Excel, it is necessary to open the file in Google Spreadsheets. I wrote how to do this below.

Deleting data in Google Sheets

Everything is as simple as in Excel: select a cell or range, press on the keyboard Delete. If your cells are formatted in some way, for example by color, then pressing Delete alone will not be enough.

To remove formatting from a cell or range in Google Sheets, you need to select the desired range of cells and select from the menu bar: Format -> Clear Formatting or press the keyboard shortcut Ctrl+\ on your keyboard.

Comments and Notes in Google Sheets: Adding and Deleting

In Google Sheets, unlike Excel, you can add notes and comments to cells.
In Excel you can only make notes. Let's see how to add one and the other and try to understand the difference between a comment and a note.

How to Add a Note in Google Sheets

To add a note, you need to select the cell to which you want to add a note and do one of the manipulations to choose from:

1. Insert Note
2. Select the item on the menu bar Insert -> Note
3. Press keyboard shortcut Shift + F2

How to Add a Comment in Google Sheets

You also need to select the cell and perform one of the manipulations below to choose from:

1. Right-click on the cell and select from the context menu that appears Insert comment
2. Select the item on the menu bar Insert -> Comment
3. Press keyboard shortcut 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 to let you know that there is something there.

In addition, on the page tab, if there is a comment, a hint will appear in the form of a number indicating the number of cells on the page that contain comments. And when you hover over this tooltip, all existing comments will be “highlighted” in this way:

So what is the difference between a comment and a note in Google Sheets?

This is where the beauty of working with online tables is revealed. In addition to the above-described function with comment highlights on page tabs, you can get a hyperlink to a comment, which you can then give to colleagues:

And they, in turn, can respond to your comment by following your link.

In addition, participants in such a “conversation” will receive notifications of new replies by email. Of course, this requires that participants be logged into Google accounts and have general access to this table.

In my opinion, such features are one of the main reasons, why you should use online spreadsheet services and, first of all, Google Spreadsheets.

Delete notes and comments in Google Sheets

Everything is simple here if we're talking about about a note, then select the cell where there is a note, right-click the mouse, call up the context menu and select the item Remove notes.

Deleting a comment is also not difficult, you need to hover your mouse over the cell with the comment, all your correspondence with colleagues will pop up and you need to click on the button Issue resolved:

After which the entire chain of comments will be safely deleted from the cell. But at the same time, the correspondence will be saved just in case. You can find it at the top right of the screen next to the button Access Settings:

At the click of a button Comments you can view the entire history of correspondence and even continue the conversation or return the comment to its original place, if necessary.
And there you can set up alerts:

An absolutely amazing tool for collaborating on Google Sheets.

Protecting Data in Google Sheets

There is often a need to protect data in tables; you can protect the entire table, a page in your workbook, or a specific range of cells.

Why is this being done? It happens that by chance one of the employees edits data on some sheet or range; this can happen completely by accident and the one who did it will not even know about it. Digging into the history of changes later is not an option, to be honest. This is why it is possible to protect data in Google Sheets. Let's see how this can be done with examples.

Protect an entire workbook in a Google Sheet

In order to protect all workbook, you need to click on the button at the top right of the screen Access Settings and then specify people (gmail account) and access level - Editing, Commenting or Reading:


IN in this case we are interested in Reading - this means that people who have access to your table will only be able to view it.

Protecting a Google Sheet Page

Let's say you want to protect not the entire table, but only one of the pages, in which case you need to take a couple of simple steps.

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

The following sidebar will open on the right side of the screen:

This is where we will configure the protection.

Field Enter a description is not mandatory, this is for your convenience, so that you understand what data you are protecting, so to speak, a kind of mark for you.

Now we are asked to select which sheet to protect, we have already selected Sheet2, because it was on its tab that we clicked when we selected the item Protect sheet.

Below we are asked to mark the cells that you want to leave unprotected (very convenient). If we activate this checkbox, we will be asked to select a range of cells; the default will be indicated active cell or a selected range in our table. To select another range, you need to click on the icon in the form of a small table and select the desired range on the working page:

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

Click Ok.

Click on the button below Set permissions and let's get down to the most important thing - protecting our sheet.

will appear modal window with settings for access to the allowed range:

If you select the first radio button, then anyone who has access to the entire table will have access, but they will see a warning that they are trying to edit a protected range and will have to confirm their actions each time. And you will receive notifications by email about new actions in the protected range.

If we choose the second option, we will be asked to add editors. By default, the drop-down list contains the value Specify… and below there is a field for entering the email of the future editor. In addition to the Specify option, there are other options:

• Only you
• Import list of editors...

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

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

Protecting a specific range of cells in a Google Sheet

Range protection is practically no different from sheet protection, the only difference is in the first steps.

You need to select the range that you want to protect, right-click and select from the pop-up context menu Protect range:

And repeat the steps described in the previous subsection.

One day you need to cancel range protection, but you completely forgot where that range is.

In this case, go to the following menu path - Data ->Protected sheets and ranges… and a sidebar will open on the right with all the protected ranges available on this page:

All you have to do is select the one you want and click on the icon Basket.

Undoing an Action in Google Sheets

Undoing actions in Google Sheets works the same as in any other Office application, the only difference is in the interface design. In Google Sheets it looks like this:

Or you can cancel the action in the classic way using the keyboard: Ctrl+Z

How to save a Google Sheet

There is no need to save data in Google Sheets today. The service automatically saves the data after any of your actions. But if we talk about saving the entire table on your Google Drive, then this is a different matter.

To save your Google spreadsheet to some folder on your Google drive, you need to click the folder icon at the top above the control panel:

A small window will open where you will be asked to select the Disk and folder to move this table. Alternatively, you can create a new folder directly from here. Let's try:

Click the Move object button:

Click on the arrow to the right of My Drive:

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

Enter the name of the new folder and click on the blue checkmark:

This is actually the entire procedure for saving a Google spreadsheet to the desired existing or new folder on our Google Drive.

How to change page zoom in Google Sheets

Changing the scale was added relatively recently to Google Sheets and you can do it as follows:


We go through the menu: View -> Scale.

In addition, you can select the table display mode to be full screen. To do this, select the menu item on the control panel View -> Full Screen . After this action, the tool control panel will collapse at the top. Simply put, it will disappear top panel menu.

In order to return the viewing mode to its previous form, simply press the key on the keyboard Esc .

How to Import an Excel File into Google Sheets and Edit It

Very often there is a need to transfer all data from Excel to Google spreadsheets. The reasons are different for everyone, but they all have approximately one main reason - online tables allow you to carry out teamwork in real time, with the ability to add email notifications about various actions in the tables and many other reasons.

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

Therefore, let's look at the import option Excel tables to your Google Sheets account.

Import paths xlsx files there are two tables in Google - quick, simple and longer, let's look at both:

That's all! Excel file has been imported into your Google Sheets and can now be found on the Google Sheets home page and in your drive. It can be moved to other folders on Google Drive and downloaded to your computer again. I’ll tell you how to do this below.

Export Google Sheets

Of course, Google could not help but provide the ability to download Google Sheets to your computer. And you can do it easily and in different formats!

To upload your Google Sheet to your computer, click on the control panel sequence of menu items - File -> Download as and select the format you need:

As you can see, the formats that Google offers should satisfy almost any user requirement for any purpose.

View change history in Google Sheets

Google Sheets has a function for viewing the history of changes, in case someone from the team or yourself messed up, you can view the changes and restore the desired version.
Let's figure out how to do this.

To view your history of changes you don’t need to perform many actions, just make a few clicks in the control panel, namely follow this path - File -> View change history or press the keyboard shortcut Ctrl + ALT + Shift + H :

Now let's see what the history viewing interface looks like and figure out how to restore the version we need.

After we made history Google changes tables, we will see this page:

At the top left we will see that the control panel has been collapsed and instead of it the inscription History of changes with an arrow, by clicking on which we will return back to our current table.

A sidebar opened on the right with controls for the story itself. The first item will be active, it says that this is our current version tables. Below are the actual steps of the story in reverse order, but this is not the most detailed story.

At the very bottom you can see the button In details, if you click on it, a list with a more detailed history will open.

In addition to the button, we see a checkbox Show changes- From the name itself it is clear what role it performs.

By clicking on history items, we will see the changes that our table has undergone, and there we will see a link Restore this version:

Very important point! If you have several pages in the table, then be careful when “walking” through the history, one of these “points” in the history may unexpectedly switch to another page (tab) in your table, which can be confusing.

In order to see the history of a page you are interested in, just go to it if suddenly a page you don’t need opens.

How to change the language in Google Sheets to Russian

It happens that you registered, but the Google Sheets interface is not Russian, but English, for example. If you are faced with such a problem, then this chapter is for you!

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

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

Ready! Enjoy Google interface tables in Russian.

How to share a Google Spreadsheet

We have already partially discussed above how to give collective access to our Google Sheets. Let's now understand once and for all all the intricacies of accessing Google Sheets.

After creating and editing a table, we may need to grant access to colleagues, partners or clients. Consider two options - quick simple and advanced.

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

   By default, it has access to editing, by clicking on the pencil icon, you can select the access level.
   Editing is the most high level access.
   

2. The second option for providing access to Google Sheets is more advanced.
   Click at the bottom of the modal window on the text Advanced:
   
   

   You can change the owner of the table right here (if there are already added people):
   
   

   You can also invite new users by indicating their emails.
   And at the end there are two checkboxes:

   • Prevent editors from adding users and changing access settings;
   • Prevent commenters and readers from downloading, printing and copying files. If you previously indicated that the table is available via a link, then you will not be able to change the access level in the advanced settings, and if you indicated that it is by invitation only, then you can change the access level by clicking on the link Change.

How to Email a Google Spreadsheet as a File

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

Let's send our table to our colleagues or clients.

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

A modal window with sending settings will open:

• Attach as– Here we select PDF or XLSX format
• To whom– indicate the recipient’s email
• Subject– the name of our table is automatically inserted
• Message– you can add a message, for example, explaining what this table contains.
• Checkbox send me a copy- everything is clear here.
• Click send.

There is one small minus in this function - such letters are sent only to Google accounts with gmail by mail, in any case, I couldn’t send it to Yandex.

How to delete a Google Sheet

Well, we got almost to the end of the article, now we will learn how to delete our google spreadsheet.

Over time, you will have a fair amount of tables and some will no longer be relevant, and if you don’t need them at all, then why take up precious space on Google Drive with them? In addition, the space is not rubber and has very specific boundaries - 5GB in a free account.

You can delete a google spreadsheet in at least two ways: delete it while being right in the table and delete it from the main page of Google Sheets.

Let's consider both options:

In the drop-down menu, click Delete.

Note. Only the owner can delete the table, and the co-authors of the table will also lose access to the file.

By the way, co-authors who do not own the table also have such a button, and you can even click it, but the table will not be deleted, it will only disappear for a while (until the next visit to the Google Sheets main page), then it will be displayed again. In this case, Google has provided the ability to filter files.
You can filter files according to the principle: Yours - Someone else's - All in a row.

To filter tables, go to the main page of Google Sheets, find the drop-down list at the top marked Owner:

The default will be Anyone, click on this button and select filtering conditions.

In my opinion, this is not very convenient, that I cannot remove tables that I do not need from my list, but only filter them.

How to recover Google Sheet

Surely many people had such a situation when they either accidentally deleted a file or deleted a table, thinking that it would no longer be useful, but then it turned out that you needed it again for one reason or another. But you don’t know how to recover a Google spreadsheet or other document file.

In this chapter, we will work together to recover seemingly lost Google Sheets files.

First of all, go to Google page Disk:

In the left menu, find the trash icon and click on it:

A page will open with deleted files, where we need to right-click on the file of interest and select Restore:

This article has come to an end, I hope it was useful. If I missed something, then write your questions and wishes in the comments, I will definitely supplement the article.

Most of us are used to working with data tables using Microsoft Excel. However, he had a very worthy competitor- Google spreadsheets, which are also developing and improving very quickly. Many people perceive Google Sheets as simply convenient tool viewing signs sent by e-mail. However, this is completely false. Let's compare Google Sheets with their main competitor.

Advantages.

• Google Sheets is free service. Work with it directly in the browser - no special software not required. Graphs, filters, and pivot tables will help you analyze data effectively.
• The information is stored in the cloud - if the computer breaks down, the information will remain intact. IN Excel information tied to one computer.
• Sharing files is very simple - you just need to send a link to the document.
• Google spreadsheet information is available to you not only from home or office, but also from anywhere where there is Internet access. And on mobile devices Yes, you can work with tables without Internet access.
• Great for teamwork - several people can work on one file at the same time. You decide who can edit tables and who can only view them or leave comments. Permissions can be configured for individual users and entire groups. Work simultaneously with your colleagues: all changes made will immediately appear in the table. You no longer have to email each other with corrected versions of your files.
• A very convenient history of changes - if you made a mistake and found it through long time, then you won’t need to press Ctrl-Z a thousand times, everything happens much simpler. You can look at the history of table changes from the moment of its creation and see there who made corrections to it and what exactly was changed. And if for some reason some of the data from the table has disappeared, then it can be easily restored from history.
• You can work with the table through the browser of a computer, tablet or phone, and what operating system you have does not matter. For mobile devices, you can use special mobile applications.
• If you know MS Excel well, then working with Google Sheets will not be difficult for you, since the functions used are very similar.

Flaws.

• Works a little slower, especially with a low Internet connection speed.
• The safety of documents depends on the safety of your Google account; if you lose your account, you may lose your documents.
• The number of functions is slightly less compared to traditional Excel, but for most users they are quite enough.

About functions and capabilities.

However, let's talk in more detail about the functions and capabilities - because for many of us this is the most important thing! There are currently 371 functions in Google Sheets! their complete list with descriptions. They are divided into 15 sections:

List of Google Sheets Features

In M.S. Excel functions 100 more. Now see how this apparent disadvantage turns into an advantage. If you couldn't find a function you are familiar with and need, this is not a reason to abandon Google Sheet. You can create for yourself the desired function using the script editor (we'll talk about it a little later).

how to open the script editor

The use of a programming language also provides enormous opportunities Google Apps Script (extended version Java Script to work with Google services). For each table you can write a separate script (script). These scripts can manipulate data in a table, join different tables, read files, and much, much more. These scripts are launched based on certain events that you can configure yourself (by time, when opening a table, when changing a cell) or simply by pressing a button. Google Apps Script can link Google Sheets with the following applications:

• Google Docs;
• Gmail;
• Google Translate;
• Google Forms;
• Google Sites;
• Google Calendar;
• Google Contacts;
• Google Groups;
• Google Maps.

If you are missing some features in Google Sheets, you can try to find something you need among the add-ons. The page with available addons opens from the menu Add-ons -> Install add-ons. I would recommend taking a closer look at the following add-ons:

• Power Tools;
• Remove duplicates;
• Advanced Find And Replace;
• Translate My Sheet;
• Styles;
• Merge Values.

Google Sheets has dozens of keyboard shortcuts for almost every action. Complete lists for PC, Mac, Chromebook and Android you can see. I think that taking this into account, the capabilities of this package will be quite sufficient for you.

If we couldn’t convince you, then write to us: What are you doing in Excel that you can’t do in Google Sheets?

Hello, friends! You are on the blog "" and in this article we will create Google documents and spreadsheets online. In the previous article, we looked at how to create Google Docs online.

Making a report in Google Docs online - a guide for beginners

In the previous article "" we examined in detail what the Google Docs online service is, why it is needed, and how to create documents in it. For those who have not read the previous article, let me remind you that the Google Docs online service is designed to online jobs with various documents to hundreds of people at the same time.

In mode online people can correct, comment and simply read your documents, you just need to give a link to this document. The Google Docs online service is used by both professionals and beginners. This tool indispensable when conducting training and preparing various reports. Let me remind you that 95-97% of beginners do not know how to work in online Google Docs.

To cover all the possibilities of the Google Docs online service, you need to create a large full-fledged video course that is available on the Internet. For beginners to work in this service it is enough to work online with Google documents and spreadsheets, which will allow you to run reports and work with documents of your colleagues. In the previous one, we discussed in detail how to access Google Docs and how to work with Google Docs in online mode e.

This article will discuss in detail the procedure for working with Google Spreadsheets online (Google Docs). So, to work online with Google Sheets, go to the “Google Drive” page. Next, press the "Create" button, a menu pops up, where we select the "Table" function and click on it (see the screenshot).

A table similar to Excel opens in a new window, with this office program I hope everyone is familiar.

Working in Excel is a separate topic and will not be discussed here. Let's consider only the creation of a simple table to further demonstrate the capabilities of the Google Docs online service and in particular the functions of the table.

To create a table, select its borders with the mouse (see screenshot),

select the “Borders” function and select, for example, “All borders”. The result is a table that can now be filled out (see screenshot).

As you can see, the control panel is visually clear. You can select any desired function, font, font size and color. You can use the View function to freeze rows and columns. With the "Insert" function, you can add rows below and above, as well as add columns to the right or left.

Using the “Horizontal Alignment” function (see screenshot 3, highlighted orange), you can position the entry in the center, left, right. Can be aligned vertically. If you don’t know Excel, then you need to practice a little and everything will be clear. By the way, here, as with a Google document online, you don’t need to save anything, just close the page and that’s it. To any more early version you can always come back.

Now you need to give the created table a name; to do this, in the upper left corner, click on the inscription “New table” (see screenshot 3). In the new window that opens, enter the name of the table in the field, for example, “Work statistics” and click “Ok”.

Now you can fill out the table. As an example, I will show you my completed table - statistics of my work on advertising platforms Rotaban, see the screenshot. If desired, the table can be configured to perform calculations.

Now that the table has been created, we need to configure document access. This is done in the same way as for setting up a Google document online (see). In the upper right corner, click the “Access Settings” button, select a mode, for example, “Everyone who has a link can edit” and click “Finish”. If something is not clear, look at the screenshots of the previous one. Now, after hovering your mouse over the “Access Settings” button, you can see what user accessibility mode you have set. We copy the Google Sheet link online and send it to users.

As you can see, there is nothing complicated, everything is very simple. We learned how to create Google documents and spreadsheets online in Google service Docs. You can watch the entire process of working with tables in Google docs in this video:

As documents become available, home page the online service will be filled with them, cluttering it. To organize Google online documents and it is better to place their tables in separate folders. To create a folder, click on the “Create” button and select the “Folder” function (see screenshot 1). Next, we put Google documents and online spreadsheets into folders by simple drag and drop.

And a few more words about the compatibility of the Google Docs online service with different browsers– it works great with Google Chrome, Firefox, Safari from version 4 and higher, Internet Explorer starting from version 8 and higher. Correct work with other browsers is not guaranteed by the developer.

IN online service Google Docs allows you to create not only Google documents and sheets online, but you can create presentations and work with images - png and jpeg extensions are supported. The service allows you to work with documents in PDF format. You can also install Google Drive on your computer and work offline, and when you need to go online. Can also be used various applications from the service, there are many of them.

In the first and second parts of this article, we looked at the process of how to create Google documents and spreadsheets online, and how to make these documents available to other users. Now newbies should not have any questions while preparing their reports during the training process. This tool is also convenient to work with Infobusiness partners. For example, if you are running a general project to make money via the Internet, you can easily edit general business documents using Google Docs. I will end on this wave, good luck to you!

Receive new blog articles directly to your email. Fill out the form, click the "Subscribe" button

In 2001, the book “Getting Things Done: The Art of Stress-Free Productivity” by David Allen appeared on store shelves. In it, a productivity and time management expert showed how important it is to have a proven system for personal, business and other tasks.

Allen introduced a system called which helped a large number people to put their affairs in order. You can use it as a kind of shell different services like Wunderlist, Todoist, Trello and Evernote, but they are often too complex or not functional enough. These services have a far from obvious, but worthy alternative- Google Sheets.

Advantages over other applications

1. Good visualization = better comprehension

Clutter, physical or digital, is a real problem with physiological consequences. One of the main ones is a decrease in efficiency. When you look at the list of projects that take up a lot of space due to text and all sorts of attachments, your brain starts to panic. This makes you less productive.

Google Sheets, in turn, is a collection of rows and columns. Even when you have 35 projects in front of you, they are all simple elements of a table: familiar, compact, and at the same time full of information.

2. Easy to enter and edit

A good productivity system is one that is easy to enter information into. Nothing should prevent you from adding projects and tasks, as well as changing them.

To add something to tables, just click on a cell and enter text. There are no checkboxes, options or buttons - you just enter whatever you need into text.

If necessary, you can add a column somewhere, merge cells, and so on - there are many options.

3. Flexibility

Any productivity system must be flexible enough. You should be comfortable sorting and filtering content based on changing priorities. Google Sheets allows you to create filters based on various criteria.

Some people who follow GTD and other systems use context in every task. Each one is labeled with something like “@phone” or “@computer” so you can only view things that can be done where you are and with the tools you have at hand.

Google Sheets makes it easy to save custom filters with multiple criteria. You are free to name these filters whatever you want, which greatly speeds up their search.

4. Simplicity and breadth of possibilities

One of the main advantages of tables is their simplicity. And because they are easy to use, they provide a lot of options. Data is easily organized and linked to other information.

You can create a cell with in plain text, or you can write a formula that combines several pieces of data into a function. You decide how your data should be linked.

5. Cross-platform

All of the above applies to any programs for creating tables: Microsoft Excel, LibreOffice, OpenOffice Calc, Apple Numbers and so on. In all - the same basic principles work of rows, columns and formulas. But Google Sheets runs entirely in the cloud, and is fast and reliable.

You are free to work with anyone operating system, from any device. All you need is an Internet connection and a browser installed.

Examples of using

Your GTD document can contain as many sheets as you like. Let's imagine that we have seven of them.

1. Projects. Allen defines a project as a task that has more than two phases and takes up to 12 months to complete. You can add anything to the list - the project could even be changing your car's oil.
2. Upcoming Cases. A list of things you can do right now. You can specify approximate dates and priority for completion.
3. Expectation. Things you expect other people to do. If desired, add related projects and notes about the last time you spoke with these people.
4. Agenda. Matters that need to be discussed at regular meetings. For example, if you have a weekly one-on-one conversation with a colleague, then enter here what you want to discuss with him. You can also add a column with related projects here.
5. Incubator. A list of things you want to do someday, but don't know when yet.
6. Weekly review. Checklist tasks you complete when you review the week. This could be checking existing projects and adding new ones, closing “tails” and so on.
7. Completed projects. Cut out your completed project and paste it onto this sheet, and mark when you've completed it. If you simply had to get rid of the project, then this also needs to be written down.

Projects

The number of columns in this sheet may vary, but there are two main ones on which the entire system rests: “Project ID” and “Upcoming Things”.

The project ID is its unique number. The purpose of identifiers extends beyond Google Sheets. All yours can rest on them organizational system. For example, if you store project-related files and notes in other services, you can use the same numbers in them too. This significantly speeds up the search for files and information and allows you not to keep many things in your head.

The Upcoming Things column tracks three aspects of each project:

• how many tasks have been added to the “Upcoming tasks” tab;
• How many items related to this project are in the Pending tab;
• How many items related to this project are in the Agenda tab.

Formula - simple function count, which checks these three tabs and gives information about how many actions are associated with this identifier project. This column allows you to quickly find projects with no tasks in progress. The sequence “0 | 0 | 0" indicates that you need to either add actions to the project or postpone it.

"Expectation" and "Agenda"

These sheets include the person's name, what you need from them, when you asked for it, and what project it relates to. If you meet with this person regularly, then he goes to the “Agenda”. If you only see him occasionally, then add him to “Waiting.”

Incubator

In an interview, Allen said that if a project hasn’t moved one iota in a week, he sends it to the “Incubator.” The idea is simple: if you don’t work on a project regularly, then remove it from the list that is always visible. Such a project creates clutter and, as a result, a psychological obstacle to accomplishing important things.

Every week, look into the “Incubator” and either change the status of the project to “active”, leave it alone, or delete it completely.

Weekly review

This tab helps you make sure your to-do lists help improve your personal and business life. Therefore, you need to constantly review these lists and keep them up to date.

A “weekly review” can consist of questions and ideas to reflect on. Essentially, this is a list of unique triggers that remind you of projects that need to be completed. It also helps you check if your tasks are still aligned with your goals.

Completed projects

If you need to remember the outcome of a particular project, this worksheet will help. And even if you know how the project ended - for example, you abandoned it - sometimes it is useful to find out when you made such a decision.

Useful Google Sheets Features

Notes

They can be used in several ways. One of them is to write down all possible upcoming tasks for a certain project. These can then be copied directly into the To Do list, adding your desired completion date.

Notes are also convenient to use for their intended purpose. Add notes to project status to track important stages and add useful information.

To add a note, right-click the cell and select Insert Note.

Greetings, dear readers and guests of my blog. Today I will continue to talk about services search engines and I’ll tell you how to simplify your life and learn to work with useful tools. Ready to learn some cool instructions? Then let's move on to reading!!!

Most people who use the Internet are not aware of such a great application as Google Dox, but in vain. After all, it is no worse than the popular ones office packages OpenOffice and Microsoft Office.

What is Google Docs and its purpose

The developer company cares about its users and constantly releases latest products. One of them is Google Docs with integrated word processor and programs for creating and editing spreadsheets And online presentations. The application is free and can be used both online and offline. Created documents can be instantly sent by email, and links to them can be provided for other users to view, edit, and comment on.

In cloud storage You can place countless objects. Google Drive provides 1 gigabyte of free storage for any files, which can later be increased up to 15 gigabytes. You can work with files both online and offline. The latter requires the Chrome browser, in which you need to enable offline mode for working with files. The application has many advantages, here are some of them:

• automatic saving ensures that your work is never wasted, even despite PC crashes and shutdowns. All changes can be viewed in history, which is very convenient and makes it possible to roll back to earlier versions;
• documents can be downloaded in all popular formats. For example, you can create text file in Word to own computer, save it to Google Drive, and edit or modify it elsewhere from another device;
• you can open access to anyone you want to make changes, view or comment.

Google Dox Sheets online: how to create and edit a document

In order to be able to work with objects offline, you will need to enable the offline mode feature. This will allow you to correct existing documents and create new ones. The next time you connect to the network, all data is synchronized. To enable the function, you need to open Google Drive and enter the settings by clicking on the gear in the top right. ( All images below are CLICKABLE )

On the screen that appears, check the “Offline access” box and agree to the requirement to install the “Google Documents Offline” extension.

Unfortunately, this opportunity not available in all browsers. Therefore, the best solution for working with the application is to use the Chrome browser, which allows you to use it fully, with all the available features.

To create and Google editing tables online way you need to go to the Disk of the same name. Then click on “Create” in the top left. Select “Google Sheets” from the pop-up menu.

After this, the next tab will open in Explorer. Let's start creating the document.

First let's rename it, since by default it is called "New Table". To do this, click on the name and enter your name. Next, click on the “Borders” button, and in the menu that opens, select what you need. For example, “All borders.” As a result, we have a completed table.

The screenshot shows that the control panel is quite simple and intuitive. It is possible to change fonts, fill, color, etc. For those who have worked in Excel, everything is elementary. After entering all the data, you need to determine who can access the file. To do this, click on the page of our document “Access Settings” and select the desired item.

After that, when you hover the mouse over this button, a pop-up message about the accessibility mode appears. Thus, you can see what value is set in these settings.

Now, in order for other users to view this file, it is enough to send them the appropriate link.

There is nothing complicated in drawing up documents in this service. When creating new files, the page Google Docs will become cluttered, so it is better to immediately sort all objects into folders. To do this, on Disk, click on the “Create” box, in the drop-down window select “ new folder". Give it a name and move your object into it with the mouse.

A little about Dox and browser compatibility. This application works perfectly in Chrome, Mozilla, Safari and Internet Explorer above version 8. Dox may not work correctly in other browsers. Presentation can also be made in it, as well as working with drawings PNG formats, JPEG, and also with PDF files.

How to make dropdown lists in a table

In the application, you can add text from a ready-made list. I'll show you how to create a Google Sheet with these functions. following example. In addition to the already compiled “Progress”, we will make a list of students on the second sheet.

On the first sheet, select a column for selecting surnames from the list. Right-click the mouse to open the menu, click on “Data check”, in the menu that appears, select the items “Rules”, “Value from range” one by one and click on the barred rectangle icon to select the data range. A list of surnames can be made on the first sheet.

Then we go to " Sheet2", select all the data and click OK.

Now you can easily enter the desired surnames from the drop-down list by clicking on the arrow at the bottom of the cell.

Similarly, you can create a list in the dialog box itself. To do this, you just need to select “Value from the list” and manually enter the last names separated by commas.

How to fix speakers

Column anchoring is very convenient function when creating a Google Docs spreadsheet in which a lot of information is entered. To do this, open the file we need.

It can be seen that some of the data will not be visible when scrolling. Here detailed instructions to pin a specific area:

• Select the desired columns with the mouse.

• At the top, select “View”, “Pin” and click on the required indicator. We select "1 line". To do this, by the way, it is not necessary to select a column. The screenshot shows that there are many options here. You can highlight the column you want and select Up to Current Column.

• That's it, the consolidation is done. Now the first columns will always remain in the top position when scrolling down.

To unfreeze, go back to the “View” menu and click on “Do not freeze rows” in the drop-down menu.

Create additional sheets and fields

It is very easy to add an additional sheet in this application. There are two ways:

• You need to click on the “+” icon in the lower left corner and a new sheet will appear.
• Click on the “Insert” tab at the top, select “New Sheet”.

To analyze data in pivot table You can add and remove various fields. To do this, create a document by clicking on the “Data” and “Pivot Table...” tab.

Left, in sheet3, there will be a menu where you can select the parameters of interest, based on which you can make a report on all the information provided.

What are Google Forms

They are needed to create online surveys. This is a highly requested feature that the developer has built into this app. They can solve many problems. For example:

• collect customer opinions about a new product;
• create a questionnaire for testing job applicants;
• embed feedback to the website;
• create a test in the text for a creative competition.

This is an indispensable thing for collecting information on the Internet. Using this application, you can create a survey that will collect data for free, without unnecessary intellectual effort. All you need is an Internet connection and a Google account.

The developer took care of additions that expand the capabilities of this processor; completely free at the same time. For example:

• After filling out the surveys, a message is sent to your email;
• you can insert formulas into the questionnaire;
• the number of respondents may be limited;
• at the end of the survey, a message is sent to Slack;
• All email addresses in surveys are confirmed.

Therefore, there is no need to look for an alternative if you did not find something in the forms - it may be in the add-ons.

How to create a registration form

Let's see how to make an online registration form using the following example:

• On Disk, select the “Create” button and then “ Google Forms».

• In the window that appears with a new document, we see the editor.

Enter the name and fill out the question line.

• In the “Answer option” item, click on “Text (line)”. We will make the question mandatory, which will not allow the respondent to submit data without filling out this field.

• Fill out the field for the second question and set the value to “Date”. Turn off the “Required Answer” button.

• Click on the “+” icon to add a new question. Fill in the field that opens. This time we select “One from the list”, enter the options – “Male” and “Female”. Click on the cross to delete the “Respondent’s Answer”.

• In the next question, select “Several from the list” and write down the options.

• In the fifth paragraph, add “Drop-down list” and fill in all the options.

• We formulate the next question as in the screenshot, selecting the “Scale” value.

• Add new item“Grid”, enter everything that is required as in the screenshot.

• To select a design, click on the palette icon and select the theme you like.

• To view, click on the image of the eye, and if you like everything, then click on the three dots in the right corner and configure access.

If desired, the file can be published in in social networks– Facebook, Twitter, etc., and also send by email. You can also get a code to embed into a blog or website.

On the “Responses” tab, you can view them in a table. And on the icon with vertical dots you can configure the mode for receiving them. The screenshot shows several options that you can choose from.

You can see the answers both in the form of a summary and an individual user.

You can edit the form at any time by clicking on the desired object with the mouse.

How to create a survey in Google Form

First, to create a survey, you will need to sign in to Drive. As usual, click on “Create”, “Google Forms”. The window with the questionnaire will open in a new tab. We enter the name and explanation for the people who will take the survey (this field is not required to be filled in).

Let's take an example of compiling a questionnaire for parents of schoolchildren. Let's fill out the first paragraph. By clicking the mouse, instead of “Question without title” we type the required text. Specify the question type as “One from the list” and add options. Move the slider to the “Required answer” option.

If you need to delete any values, then click on the cross next to the unnecessary option. Answers can be swapped by dragging the three-dot icon with the mouse. There is no need to save anything specially, autosave works.

To enter the next item, click on the “+” icon on the right side of the screen.

To change the text, you just need to click on the desired line. Answers can be shuffled by clicking on the three dots icon and selecting the appropriate item. This is very convenient, since many people often choose only the top answers, and shuffling gives a more objective assessment.

There are several types of questions in Google Forms. Here they are shown in the screenshot.

They were discussed in more detail above. They can be copied if they are repeated in one way or another.

In the settings above the text you can edit the values. When “Show survey progress” is turned on, the respondent can see how much of the questionnaire he has filled out and how much more he needs to complete. If “Only one answer per person” is set, then there can only be one respondent from one account.

In the confirmation text, you can enter wording that a person will read after filling out the questionnaire.

After finishing working with the form, the questionnaire can be published on a blog and social networks. You just need to click on the “Submit” box in the upper right corner. In the dialog box that opens, fill in necessary points and click OK.

You can not only provide links to forms, but also embed them into your own website. You can edit the questionnaire at any time by left-clicking on the value to be corrected. You can find the survey and answers to it in the form of a Google Docs table on your Drive. But before that you need to go to the “Answers” ​​menu and click on green icon above.

How to set permissions on Google Docs

As already mentioned, you can give other people access to Google objects to change them, view them and leave comments. To open rights to other people, you need to take the following steps:

• On Disk, select the desired object, right-click on it and select “Share...”.

• Select the required value or enter the user name and click OK.

To grant rights to other users to several documents at once, select the necessary objects and click “Open access to files.”

In the menu that appears, set the required values. Access to the folder is provided in the same way.

You can also open rights to people who have a Google account. To do this, on the Disk, select the desired object and click on the "Share" icon. In the menu that opens, enter the email address or Google group.

Having considered the functions of Docs, we can say that, despite some limitations, the application copes with its tasks and can be useful as a lightweight cloud editor. And its undoubted advantages are its simplicity and accessibility.

I hope the article was useful, and you will use it as a cheat sheet when working. In order not to forget the article and always return to it, I would advise you to add it to your bookmarks. I will be grateful for reposting the article. All the best and see you soon -))).

Sincerely, Galiulin Ruslan.