Paste Picture Link

Sheet1: Highlight / Copy / 

Sheet2: Paste Picture Link

Today / Month / Year

Today / Month / Year :

1,

=TODAY() 
2,
=MONTH(TODAY()) 
3,
=YEAR(TODAY())

Word: Insert / Date & Time / Check "Update automatically"

To create a drop-down list in Excel

1. Start Excel and open a new, blank worksheet.
2. In cell A1, type "Select", and then select cell B1.
3. On the Data menu, click Validation, and then click the Settings tab.
4. From the Allow list, click List.
5. In the Source box, type the following values: Male,Female,

To create a drop-down list from values on the same worksheet

1. Type some menu starting at cell E4.
2. Select the cell that contains the list you created earlier (cell B1, unless you chose otherwise), and then, on the Data menu, click Validation.
3. Replace the list that you typed manually with the following value: =E4:E8 (Word,Excel,PowerPoint,Photoshop,Quickbook).
4. Click OK, and then select a value from the list.

Special Type in Excel

1, Starting from 0 : use ' type.

2, Excel Options / Formulas / Uncheck “Numbers formatted as text …”

   More Format Numbers / Custom / "7187621900"@ or (718) ###-####

Print Title in Excel

Page Layout / Print Titles / Sheet / Rows to repeat at top / Highlight Title /print Preview / Next Page

Duplicate in Excel

Original File

1, Home / Conditional Formatting / Highlight Cells Rules / Duplicate values / OK

2, Highlight Cells / Data / Remove Duplicates / OK

Spin Button in Excel

1,Add Tab - Developer:Office Button / Excel Options / Popular / Show Developer tab in the Ribbon

2,Developer / Insert / Spin button / Draw / Right Click / Format Control / 

Developer / Insert / Spin button / Draw / Right Click / Format Control / 

Set Office Password

Set Office Password:

Office Button / Save as / Tools / General options

Form (Data List) in Excel

Quick Access Toolbar / More Commands / Commands Not in the Ribbon /Form / Add / OK

1, Highlight Menu / Form

Validation in Excel

1, Date（2013） : Data / Data Validation

2,Whole number: Item# And Inventory

Filter in Excel

1. Highlight / Data / Filter
   
   
   
2. Symbol / Select "INTC"
   
   
3. Highlight / Type / Ctrl + Enter
   
   
4. Symbol / Select All
   
   

VipotTable

Chart in Excel

Chart

1, New Sheet / Insert / Column /

 

 
 

 

 

 

 

 

WordArt in Excel

Lock - Protect Sheet

1, Select Cells / Right Click / Format Cells

2, Review / Protect Sheet

2 Worksheet Arrange in Excel

Sort - Excel

Transpose in Excel

Data→Consolidate（合并计算）

2,Data→Consolidate

2013 Salary December