Posts Tagged ‘Google’

Edit Form Responses In Google Forms

Google Forms Tips - Edit Responses

Do you need to have someone edit form responses AFTER they’ve already submitted them? What if they closed the form and need to edit later? If this is something you’re dealing with, then this article is where you need to be! Edit Form Responses After They’ve Been Submitted I recently had a student ask me…

Read More

Quickly Move Cell Ranges in Google Sheets

Google Sheets Tips - Move Cell Ranges Header

There’s no need for using copy/paste when moving your data in Google Sheets. You can simply select a range of cells and drag them to a new location, retaining all formatting. Moving Cell Ranges This example shows some data that isn’t in the best order. It would probably be better to have the “First” name column…

Read More

Transpose Data In Google Sheets

Google Sheets Tips - Transpose Header

Sometimes we end up with data in a column then later realize that it needs to be in a row, or vice versa. This is called transposing. Fortunately, Google Sheets makes it very easy to quickly transpose your data. How to Transpose Data This example shows weekdays listed down one column, and names of people…

Read More

Gmail Out-of-Office Auto Reply

Google Gmail Tips - Header - Auto Reply for Out of Office

When you’re on vacation, out of the office for any reason where you won’t be answering emails, it’s always a good idea to set up an auto reply so that people know you’re gone and when to expect you back. This way you (hopefully) won’t be bombarded by emails that you will have to sift…

Read More

Remove Duplicate Items In Google Sheets

Google Sheets Tips - Header - Remove Duplicates with UNIQUE

Have you ever had a list where you needed to remove duplicates to only see one occurrence of each item? This article will show to remove duplicate items using the UNIQUE function. Remove Duplicate Items With UNIQUE This example displays a list of items with some of them being duplicate entries. Using the UNIQUE function will…

Read More

Enable the Gmail Preview Pane

Google Gmail Tips - Header - Enable Preview Pane

I find that it’s really nice to see what’s in a message without opening it separately. Fortunately, Gmail has a built-in way to do this. It’s the Gmail Preview Pane, and all you need to do is turn it on. How to Enable the Gmail Preview Pane In Gmail, start by clicking on the “Settings”…

Read More

Gmail Messages In Floating Windows

Google Gmail Tips - Header - Open Messages In Floating Window

Would you like to compose your gmail messages in a floating window instead of having it stuck down in the corner? This article will show you how you can open and compose Gmail messages In floating windows. Compose Gmail Messages In Floating Windows I’ve never been a fan of having my new messages down in…

Read More

Formatting Sentences With Functions In Google Sheets

Google Sheets Tips - Header - Format Proper Sentences

The PROPER function works great for names since it capitalizes the first letter of every word, but it doesn’t work for formatting sentences. What if you only want to capitalize the first letter of sentences? Formatting sentences can be done with a combination of functions. This article will show you how. Making It Happen Formatting…

Read More