You can now right-click on items in Google Drive to display a context-sensitive menu.
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.)
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.
Choose Options > Save as my default styles to use the current stylesheet on every new document.
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.
To quickly view keyboard shortcuts in Google Docs, press CTRL + / (forward slash).
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:
{MERGEFIELD Zip_Code}
{MERGEFIELD \# "00000" Zip_Code}
Format explanation: I picked five zeroes for the zip code format because a zero in a number format forces Excel to put a number in that position, even if the number is blank or zero. (The default number format uses # signs, which to Excel means, “Don’t put a number in this position if the number is blank or zero.”)
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.
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.
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 than selecting the cell, changing the value, selecting the next cell, etc. If you are watching the sheet, the values simply appear.
There are times when you are processing a list when you might want to look at the values in the same row, but a couple of columns over. You can accomplish this best with the .Offset clause. You might see the .Offset clause when you record a macro using relative references:
ActiveCell.Offset(1, 0).Range("A1").Select
This is both confusing and overkill. Translated into English, it takes the current cell (ActiveCell) and selects the row that is one row down from the current row and in the same column. The “Range(“A1″)” clause is not necessary. So if you want to stay in the current cell and read a value two columns to the right, you could use syntax like the following:
strMyValue = ActiveCell.Offset(0,2).Value
If you are in cell D254, the code above will reference the cell F254 and read its value into the variable strMyValue. This is far more efficient than selecting the cell two columns to the right, processing your data, then remembering to select two columns to the left and continue.
If you want to offset to a column to the left of you or a row above you, use a negative number. If you are in cell G254, the code ActiveCell.Offset(-3,-2).Select will select E251 (3 rows up and 2 columns left).
You can loop through a list much more efficiently with Offset. It is easier to program and way faster to execute.
While ActiveCell.Value <> ""
strFirstName = ActiveCell.Value
strLastName = ActiveCell.Offset(0,1).Value
dblSalary = ActiveCell.Offset(0,2).Value
ActiveCell.Offset(0,2).Value = dblSalary * 1.05 'give a 5% raise
MsgBox(strFirstName & " " & strLastName & ": Your new salary is " & dblSalary)
ActiveCell.Offset(1,0).Select
Wend
You would probably want to format the salary for currency, but this is the general idea.
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:
Some users have reported an error message when attempting to set up the DDE connection. The cause for the error can be a variety of reasons (such as a filtered spreadsheet or a conflict with a printer driver). If you cannot establish the DDE connection, there is an alternative method to force the leading zeroes in a zip code to appear in a mail merge. Check out this post:
Leading Zeroes Missing from Zip Codes in a Mail Merge: Another Option