Google Spreadsheets (Sheets) Tips – Paul Chavez

Google is an easy, efficient way to store, organize, and analyze your data. Sheets is a tool that can be used very effectively when used properly. These tools will help you navigate your way through Sheets and will help you save time.

Inserting a Comment

There are three main ways to insert a comment into Google Spreadsheet.

1.  Select the cells that you wish to leave a comment on. Click on the “Insert” tab in the upper left corner. Once the drop down menu opens on the “Insert” tab, select the option labeled “Comment.” Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.   insert-tab-1

2.  Select the cells that you wish to leave a comment on. Right click inside the cells selected and click “Insert Comment.” Proceed to insert your comment and click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.Screenshot 2016-10-06 at 10.26.36 AM.png

3.Select the cells that you wish to leave a comment on. On your keyboard press Ctrl + Alt + M to insert a comment. Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.

 

Using Borders

borders

To insert a border on your spreadsheet, select the cells, click on the “Borders” symbol, and select the border you want to use. You can also change the color of the border and the border style once you click the “Borders” symbol. 

borders-tab

Changing Formats of Numbers

Changing formats gives you different ways to present data.

formatting

Select the “Format” tab on the access bar, click “Number”, and select the option you want from the list. If the format you want is not present, click the “More Formats” option to choose more options or create your own format.

 

Copying Box into Multiple Rows/Columns

 

This a pretty easy tool to use. Place your cursor in the bottom right corner of the box you wish to copy, the cursor should become a small symbol resembling an addition sign. Left click and hold, then drag your cursor into the rows/columns you wish to copy it into.

Freezing

If you are having trouble keeping your data organized, then freezing might be for you. Freezing rows or columns is an effective way to use headers on your sheets. The freeze bars are located on the perimeter of the cell to the left of the “A” tab and above the “1” tab.

untitled-drawing-9

Formula Continuation Tip

If you have a minimum of 2 cells with a formula you would like to continue, you can easily continue that formula without having to keep typing it out. Select the cells with the formula you want to continue the formula from. Then, click and hold on the bottom right corner of the highlighted cells and drag to the cells you wish to continue with the formula.

 

More Information

If you would like to learn more about Google Sheets, go to Cole Davis’ Blog. He has created another blog about sheets, Google Sheets: Basic Functions. If you have any questions over this content or Sheets, you can contact me via email at:  pchavez@apps.ashgrove.k12.mo.us 



Bio

Paul Chavez – Student

Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.

20160908_100249

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s