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

Filter in Excel

Highlight / Data / Filter

Symbol / INTC

Highlight / Type / Ctrl+Enter

Symbol / Select All

Watermark

PivoTable

Two Lines in One

Chart in Excel

Chart

1, New Sheet / Insert / Column /

 

 
 

 

WordArt

Lock - Protect Sheet

1. Select Cells / Right Click / Format Cells

2. Review / Protect Sheet 

2 Worksheets Arrange in Excel

Sort-Excl

Transpose in Excel

Word Mail Merge

Word Mail Merge

一、     Excel：Company information

二、     Word：

1.       Open Word 2007→office Button→New→輸入“Notice”→“Letter notifying customer of past due bill”→Download。

2.       填寫自己的信息。

3.       Mailings→Select Recipients→Use Existing List→Open製作好的“Company information”

4.       Highlight [Recipient Name]→Insert Merge Field→選擇Name→Preview Results。

5.       Highlight [Title]→Rules→If…Then…Else→

1)      Field name = Gender; Equal to M; Insert this text = Mr. ; Otherwise insert this text = Ms.

6.       Highlight [Company Name]→Insert Merge Field→Company。

7.       Highlight [Street Address]→Insert Merge Field→Street Address。

8.       Highlight [City, ST ZIP Code]→Insert Merge Field→City Zip Code。

9.       下面一行→Insert Merge Field→Tel.

10.  Highlight [Recipient Name]→Insert Merge Field→選擇Name。

11.  Finish & Merge→Edit individual Documents→All→OK

Landscape, Margins, Columns