Shortcut Commands 101

CTRL combination shortcut keys---Shortcut Command

CTRL+SHFT+( Unhides any hidden rows within the selection. + –
CTRL+SHFT+) Unhides any hidden columns within the selection. + –
CTRL+SHFT+& Applies the outline border to the selected cells. + –
CTRL+SHFT_ Removes the outline border from the selected cells. + –
CTRL SHFT ~ Applies the General number format in Microsoft Excel. + –
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). + –
CTRL+SHFT+% Applies the Percentage format with no decimal places. + –
CTRL+SHFT+^ Applies the Exponential number format with two decimal places. + –
CTRL+SHFT+# Applies the Date format with the day, month, and year. + –

Microsoft Excel 2007
CTRL+SHFT+( Unhides any hidden rows within the selection. + –
CTRL+SHFT+) Unhides any hidden columns within the selection. + –
CTRL+SHFT+& Applies the outline border to the selected cells. + –
CTRL+SHFT_ Removes the outline border from the selected cells. + –
CTRL SHFT ~ Applies the General number format in Microsoft Excel. + –
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). + –
CTRL+SHFT+% Applies the Percentage format with no decimal places. + –
CTRL+SHFT+^ Applies the Exponential number format with two decimal places. + –
CTRL+SHFT+# Applies the Date format with the day, month, and year. + –

CONCATENATE

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Remarks

You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).

Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
2
3
4
A
Data
brook trout
species
32
Formula Description
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")
Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)