Monday, January 25, 2016

Google Sheets - Fill Down

Here's another great time saver for users of Google Sheets:

“Fill down” refers to copying the pattern in the spreadsheet down a particular range in a column. For example if I type the number 1 in a cell and the number 2 in the cell below it and then highlight the two cells to signal the pattern, I can “fill down” to continue the pattern.
  1. Open a spreadsheet.
  1. Start adding a pattern of numbers or dates to a column or row.
  1. Highlight the cells. A small blue box appears in the lower-right corner.
  1. Click the blue box and drag it to select more cells where you want your data or text to repeat.
If a pattern is recognized in the data or text of the selected cells, auto fill adds in the remaining items to complete the pattern. If auto fill doesn't recognize a pattern, it will just repeat the content that was highlighted.
Here's a short video tutorial to help you get started with this feature:

Monday, January 18, 2016

Google Fonts

Tired of using the default Google font? (Arial) Want to get a little more creative with your Google Docs, Sheets and Slides?

Let's kick it up a notch with Google fonts!

Adding fonts to your font list*
In supported languages, you can add new fonts to your font list if they don't appear in the list already.
  1. Click the current font to open the font list.
  2. At the bottom of the list, click Add fonts.
  3. Browse or search for new fonts.
  4. Click a font to add it to your "My fonts" list.
  5. To sort your fonts, or change how they will appear in your list, use the "Sort" and "Show" drop-down menus.
  6. When finished, click OK.
When you return to your document, your new fonts will be highlighted in your font list.

Set a default font for your documents*
To set a preferred font for all your new documents or presentations:
  1. Open a file and begin typing.
  2. Highlight the text and, from the toolbar, select the font you want to add as the default.
  3. Click the Format menu.
  4. Hover over "Paragraph styles," and then "Normal Text," and select Update 'Normal text' to match.
  5. With the text still highlighted, click the Format menu again, hover over "Paragraph styles," and then "Options," and select Save as my default styles.
Once the default font has been set, all new documents or presentations that you create will use this font until you change the default option again.
Note: At the moment, this feature isn't available for spreadsheets.

*Step by step directions from Google Docs Editor Help Forum

Monday, January 11, 2016

Organizing Google Drive

Was one of your New Year's resolutions to be more organized in 2016? Why not start with your digital files? Here are some handy tips on organizing Google Drive.

Monday, January 4, 2016

Convert Rows into Columns in Google Sheets

Excel has a useful transpose feature when copying and pasting. Here’s a tip to do the same in a Google spreadsheet.
How to convert rows into columns in Google Sheets.
I am using data from a form. This formula will work with any spreadsheet data.
When you collect data into a Google spreadsheet from a form, it will look something like this:
If you have a large amount of questions (and especially if some of them are essay questions), it requires a lot of side-to-side scrolling to view the data.

By using the “Transpose” formula, you can easily convert rows into columns and make the data look like this:

Transpose FormulaChanges data from rows to columns
  1. Create a new sheet.
  2. Enter the following formula in cell A1 of Sheet2:
    =Transpose('Form Responses 1'!A:G)
  3. Note: Adjust A:G to the desired range of columns. If you don’t want the timestamp to show, enter B:G. If your first sheet has a different name - replace 'Form Responses 1'with that name i.e. Sheet1.
  4. Press the enter key and the data will fill the sheet.