Paste Picture Link

Sheet1: Highlight / Copy / 

Sheet2: Paste Picture Link

Repair Chorme

1, Settings / History / Clear browsing data / 

2, Settings / History / Extensions

3, Settings / Show advanced settings / Reset browser settings

4, Reinstall Chrome

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.

3D Picture

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 / 

Add Tab - Developer

Office Button / Excel Options / Popular / Show Developer tab in the Ribbon

Table Html

<div>
<table border="1" bordercolor="#288822" cellpadding="0" cellspacing="0" style="width: 100%;"><tbody>
<tr valign="top"><td><div>
11</div>
</td><td><div>
12</div>
</td></tr>
</tbody></table>
</div>

11

12

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