admin | Notes from the Help Desk

Mouse and Keyboard Changes in Google Drive

Posted on April 16, 2015 by adminApril 16, 2015

Right-Clicking in Google Drive You can now right-click on items in Google Drive to display a context-sensitive menu. Using the SHIFT and CTRL Keys in Google Drive You can now use the SHIFT key to select a group of items. (Click the first item in a list, hold down the SHIFT key, and then select the last item in the list.) You can use the CTRL key to select individual items. (Select the first item, hold down the CTRL key, and then select additional items while holding down CTRL.) … Continue reading →

Set Default Text and Stylesheet in Google Docs

Posted on April 16, 2015 by adminApril 16, 2015

To set default text: Select the text you want to make the default for all documents. Click the Styles drop-down menu, and then select Normal text > Update ‘Normal text’ to match. This sets the current text style as normal. To set the default stylesheet: Choose Options > Save as my default styles to use the current stylesheet on every new document. … Continue reading →

Quickly “Star” an Item in Google Docs

Posted on April 16, 2015 by adminApril 16, 2015

To quickly “star” (or “unstar”) an item in Google Docs, press the “s” key on the keyboard. To view all starred items (favorites), click Starred in the left column of the Google Drive main screen.

Quickly View Keyboard Shortcuts in Google Docs

Posted on April 16, 2015 by adminApril 16, 2015

To quickly view keyboard shortcuts in Google Docs, press CTRL + / (forward slash).

Leading Zeroes Missing from Zip Codes in a Mail Merge: Another Option

Posted on February 5, 2015 by adminFebruary 5, 2015

The best solution to this problem is to change an option in Word that sets up a DDE connection with Excel, and displays the zip code the way it is formatted in Excel, with all leading zeroes. (See Mail Merge Problem: Leading Zeroes Missing from Zip Codes for instructions.) However, for a variety of reasons (such as a filtered spreadsheet or a conflict with a printer driver), this doesn’t always work. Another option is to edit the field codes in Word to make sure all the leading zeroes appear. Here’s how: In the Word document, click into the field with … Continue reading →

Capitalize a Word – Keyboard Shortcut

Posted on July 10, 2014 by adminJuly 10, 2014

To quickly capitalize a word in any version of Microsoft Word, press SHIFT + F3 (top row of keyboard). Repeatedly tap the F3 key while holding down the SHIFT key to cycle through case options for the selected text — Sentence case, UPPERCASE, lowercase. Alternatively, the change the case of selected text: Click the Change Case button on the Home tab of the ribbon. … Continue reading →

Alignment Guides in PowerPoint 2013

Posted on July 10, 2014 by adminJuly 10, 2014

The new Smart Alignment Guides in PowerPoint 2013 make it easy to align objects with precision. Simply click to drag an image or text near another image or text. Red dotted lines appear automatically showing when your objects are aligned correctly. Use the Equidistant Guide to evenly space out several images or text. This guide will appear when you have more than two objects that need to be spaced evenly apart, as in the example below. The red arrows that appear between the objects show that the distance between them is exactly the same. … Continue reading →

Video

What’s New in Word 2013?

Using Range.Offset in Excel VBA

Posted on July 2, 2014 by adminJuly 2, 2014

To select a cell in Excel, you have two basic methods: RANGE and CELLS: Range (“A1”).Select Range(“RangeName”).Select Cells(3, 4).Select ‘Selects Row 3, Column 4, i.e. cell D3 Range works well for hard-coded cells. Cells works best with calculated cells, especially when you couple it with a loop: For i = 1 to 10 Cells(i, 1).value = i ‘ fill A1 through A10 with the value of i Next i Note that your focus does not change. Whatever cell you were in when you entered the loop is where you are when you leave the loop. This is way faster … Continue reading →

Mail Merge Problem: Leading Zeroes Missing from Zip Codes

Posted on July 1, 2014 by adminFebruary 5, 2015

When you use and Excel spreadsheet as a data file in a Word mail merge, formatting zip codes can sometimes make you want to tear all the hair out of your head. This is a particularly annoying problem because most users assume they are solving the problem by correctly formatting zip codes in Excel. However, correctly formatted zip codes in Excel sometimes still arrive in Word without their leading zeroes. Here is one way to fix the problem permanently: Start Word, and then open a new blank document. Go to Word Options In Word 2007, click the Office Button, and … Continue reading →