Paste Picture Link in Excel

Paste Picture Link

Sheet1: Highlight / Copy / 

Sheet2: Paste Picture Link

Today / Month / Year in Word & Excel:

Today / Month / Year in Excel:

1,

=TODAY() 

2,

=MONTH(TODAY()) 

3,

=YEAR(TODAY())


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

Repair Chrome

1, Settings / History / Clear browsing data / 

2, Settings / History / Extensions

3, Settings / Show advanced settings / Reset browser settings

4, Reinstall Chrome

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 Text in Excel

1, Starting from 0 : use ' type.

2, Office Button, 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

Form (Data List) in Excel

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

Validation in Excel

> > Data (2013) : Data Validation