Monday, September 26, 2016

Quick Tip for Excel and Google Sheets - Week 3

Excel and Google SheetsQuickly change the width of columns  


Use one of the following options:

  • To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want.


  • To change the width of multiple columns, select the columns that you want to change, and then drag a boundary to the right of a selected column heading.




  • To change the width of columns to fit the contents, select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.


Hold shift key to select multiple columns:



  • To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.



Monday, September 19, 2016

Quick Tip for Excel and Google Sheets - Week 2

Select Everything in Excel and Google Sheets!


What can you do with the entire sheet selected?


  • Copy the contents and paste them to a different worksheet, either in the same workbook or a different one.
  • Apply formatting changes to the entire worksheet.
  • Set the column width (or row height) for the entire worksheet by clicking and dragging the divider line between two columns (or rows).

There are two ways to select your entire worksheet 

Just as in Word, you can use the keyboard shortcut Ctrl+A 

Or, you can click the square in the top left corner of the worksheet (just to the left of the letter A)

Excel:



Google Sheets:





Monday, September 12, 2016

Quick Tip for Excel and Google Sheets - Week 1

Today we are starting a series of quick tips for Microsoft Excel and Google Sheets. All of these tips will work in both products.

Week 1
Start a New Line of Text in a Cell

It seems easy enough, doesn't it? You want to display two lines of text in one cell. It just isn't as easy as it sounds. 
When you are working in a cell and you press enter, the cursor will be moved to the next cell in the column. 

You can try to use the wrap text feature. It's amazing! You now have 2 lines of text! 

However, this is not a good solution because if you resized the column, your text will display incorrectly.  


The right way to enter two lines of text in a cell:

  • Enter your first line of text in the cell
  • Press ALT + Enter
  • Enter your second line of text

That's it! You now have two lines of text in one cell! You can repeat this process to add more lines to the cell.

I hope you find this tip useful!
Next week - Inserting the Current Date in a Cell

Monday, September 5, 2016

DocHub

We've talked about converting a PDF to a google doc before (see the post from December 2015), but that doesn't solve the problem of filling out PDF forms. Today we will look at an app that addresses that issue, DocHub.



Let's get started!


  • Open a PDF file in Google Drive
  • Click on the Open with menu at the top of the window, and choose DocHub



  • DocHub will request permissions for Google Drive, click accept


  • The PDF will now open in DocHub
  • Click the text tool 
                           
  • Click on a field to insert text, add text.
  • Continue clicking and adding text


  • Once you have completed the form, you will have a variety of options for saving or sending
  • If you choose to save your document, it will save in DocHub
  • To access your saved documents in DocHub, go to www.dochub.com and sign in with your District 50 Google account.


  • When you log in, you will see your activity feed with your saved documents listed. From here, you can edit,send or download your documents right from the DocHub interface.

There are a number of other features in DocHub, including highlighting, drawing, stamps, inserting multiple types of editable fields and more. I hope you find DocHub as useful as I do!