Posts

Google Sheets - Freezing Rows or Columns

Image
I'm working with several people whom are dealing with very large spreadsheets right now.  Unfortunately it took me too long to realize that they were unaware of this very useful Sheets feature - the ability to freeze some of the rows and columns so they could always view (in their case) the student names in the first column, and the data fields in the first row.

Here is a spreadsheet with some sample data.  I want to always see the top row (Row 1) and the first column (Column A) -

Go to the View menu, mouse over the first option of Freeze, and you get a pop-up that shows your choices for freezing rows and columns -
The options 1 row/column and 2 rows/columns are available as they are the most common needs.  But occasionally you need more than that, so there is the customizable option of Up to the current row/column - this is based on the cell you current have active (selected) on the spreadsheet.

Once you select what you want to freeze, a think gray border line appears where you…

Google Sheets - Notifications

Image
Have you ever wondered how you can get notifications when changes are made by others to a Google Spreadsheet?  It's very easy to setup.

If you go to the Tools Menu, select Notification rules... -

You have 2 options to select from in the pop-up window.  The first is if you want all changes made to the spreadsheet or just when a form is submitted (this second option can also be set up in the form, if one is connected to the spreadsheet).  The second is if you want a daily notification or an email each time a changes occurs.  Once setting these, click Save -

After you have set the notifications, you will receive an email that looks like this -

If the email is not in your inbox, check your Spam/Junk as it is coming from Good Docs, not the person that made the changes.  Also, you will not receive notifications for the changes you make yourself.

Google Forms - Copy Summary Graph/Diagram to Use Elsewhere

Image
If you are looking at the summary view of the results for some Form data you have collected, you can  copy a chart or diagram that you want to use elsewhere very easily and quickly.

Simply hover over the chart or diagram, and a copy icon will appear in the upper right corner of it.  Click on that -

You will get a message that it has been copied to to the clipboard in the lower left corner - 
You can then paste it into the location you want to use it.  Here's an example in a G Doc - 
I also pasted it into: Slides, an email, a Sites webpage, in my Blogger.  A nice feature addition that saves time from taking screenshots!

Google Drive - Transferring Ownership of Documents

Image
Today I asked about transferring ownership of documents in G Drive.  There are five ways I know of to change ownership of files. It occurred to me I should share here in case others are asked (or wonder) about this also!
I've outlined them below, because some will depend on G Suite administrators being involved, and some depend on the number of files to be moved.
Here the ways: Copying the file - done by you (or currently user) by going to the File menu on a file you have edit rights to, and creating a copy (what you are currently doing)  This by far the most tedious if it involves more than a couple files.  It actually makes multiple copies of the file, each with its own ownership.  The best use of this method is for when a document is wanted by another person, but the creator also still needs the file.Switching ownership - thecurrent ownerof the file goes into the share settings and changes the access right of another editor to owner (seeGoogle Help Discussion here).  Again this…

Google Calendar - New Calendar General Settings

Image
Just as the calendar settings are similar but reorganized, the general Calendar settings are also a bit rearranged.  Also, it isn't intuitive how to go create an additional calendar.  Here are the general settings in the updated Calendar.

The gear will still get you to your Calendar settings.  (You can also get to it when you are looking at a individual calendar's settings.) -


When accessing settings, you have 3 options that appear above your calendars:

General: general settings for your G Calendar accountAdd calendar: location to go to create an additional delegate calendarImport & export: place to go for importing a calendar or exporting one of your Google Calendars

If you click on General, you have this sub-menu show up in the left-hand navigation pane.  These section titles let you move quickly to the area of the settings you want to get to -

In the main content area (where the calendar is viewable), you have corresponding sections.  Each of these include the following…