Homepage

1. Email: Gmail | Hotmail |Yahoo |
2. Cloud: Dropbox | 
3. Photoshop: Flower | 
4. Office Word : Landscape / margin / Columns  
5. Office Word : Save AS PDF |
6. Search: Google | YouTube |
7. Web: picturetrail | Download YouTube |
8. Music: Merry Christmas ||| 
9. Magic: Criss Angel BeliEve
10. Travel: 紐約最棒屋頂餐廳 | Amazing Hotels |
11. Computer :
    
    

    Excel

    1 Office

    Paste Picture Link in Excel   TODAY / MONTH/ YEAR Word & Excel  To create the Drop-down list in Excel  Special Text in Excel  Number 0 from starting in Excel  Print Titles in Excel  Duplicate in Excel  Spin butter in Excel   Set Office Password |  Form (Data List) in Excel  Validation in Excel  Filter in Excel  WaterMark   Chart II  Chart in Excel    Lock - protection  Word Art in Excel  Lock2 How to Remove Auto Hyperlinks of Office Excel (IF)

    Repair Chorme  Table - Html code  Learn English ESL Games  Gerunds and Infinitives Data Consolidate  Pivot Table  Two lines in One - Word  Word Mail Merge Excel 2anita Transpose in Excel  Add Tab - Developer |

1. 
   
2. Friend's Web: Anita | Shirley | Dennor | Hsing | Classwu | Wendy | Lee | Sarah |
1. My Video:  |

   |

Paste Picture Link in Excel

Sheet 1 : Highlight / Copy /  ( from Clipboard group )

Sheet 2 : Paste Picture Link ( from Clipboard group / paste / as picture / paste picture link

** any correction s/b on sheet 1, and automically change on sheet 2 **

TODAY, MONTH, YEAR IN WORD & EXCEL

Today / Month / Year

Today / Month / Year :

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

222222222222222


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

Repair Chorme

2222222222222

To create Drop-down List in Excel

22222222222222222 ( if space not find : to HTML TYPE 22222 on the end of <>

Special Text in Excel

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

Number 0 from starting in Excel

1. Starting from 0 :  Use ' Type number

2. Office Butter : Excel Option / Formulas / Uncheck " Numbers formatted as text...."

Print Title in Excel

1. Page Layout / Print Titles / Sheet / Rows to repeat at top / Highlight Title / Print Review / Next Page

 

Duplicate in Excel

Original File  




1. Home / Conditional Formatting / Highlight Cells Rules / Duplicate values / OK ( ** not highlight Title **)

2. Highlight Cells / Data / Remove Duplicate / OK  (**** not highlight Title ****)

Spin Butter in Excel

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

Add Tab - Developer

Set up Developer 
 Office Button / Excel Options / Popular / Show Developer Tab in the Ribbon 

TableHtml

<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
- insert information
- click new

Validation in Excel

Data / Data Validation
1. Date (2013) :

2. Current Cost:

3. Inventory:

Filter in Excel

1. Highlight/Data/Filter
   
2. Symbol/(clear) select all/INTC
   
3. Highlight/Type/Ctrl+Enter
   
4. Symbol/Select All

1. 
   

WaterMark

Pivot Table

Two lines in one - Word

Two Lines in One - Word

Chart II

Chart in Excel

Chart

1, New Sheet / Insert / Column /