Homepage

Heartbeat of Taiwan

Cloud: Dropbox | OneDrive |

My Web: Picturetrail | Download youtube |
Social Network: Facebook | Flickr |
Email: Gmail | Yahoo | Outlook |
Search: Google | Bing | Youtube |我愛學電腦 |
Translator: Google translate | Bing |
Health: 自療老年癡呆 |
Computer:

Excel

Office

Paste Picture Link | Use " FX" to set Today / Month / Year in Excel | To create a drop-down list in Excel |  Special Type in Excel | Print Title in Excel | Duplicate in Excel | Spin Button in Excel | Validation in Excel | Filter in Excel | Pivot Table in Excel | Two lines in One-Word | Chart in Excel | WordArt | Lock-Protect Sheet | Three tips for spotting malware | 2 Worksheet Arrange in Excel | Sort-Excel | Transpose in Excel |  Data - Consolidate (合併計算) | Microsoft Save as PDF | Excel (If & $) |  Restore 'Open With' Command |

Repair Chorme | Set Office Password | Add Tab - Developer | Table - HTML code | Form (Data List) in Excel | Watermark in Word | How to remove Auto Hyperlinks on Office | Landscape/Margins/Columns | Word Mail Merge |

How to fix: User Profile Service failed the logon..../

Calendar: 最新版的萬年曆｜
TV show: 人生劇展 | Love TV Show |
Movie: 日劇|
今晚煮什麼: Vegetarian recipes | 素素看 | 素食家常菜 | 現代心素派 |
轉基因食品: 孟山都的基因改造世界 |
Your Retirement Benefit: How It Is Figured | Retirement Estimator | Social Security |
Friend's Web: Kathy | Classwu | Shirley | Irene| Lee | Meiyu | Sarah | Anita | Dennor | Wendy |
Photoshop: Jade | Sky | Color |

Paste Picture Link

Sheet 1: Highlight / Copy / 

Sheet 2: Paste Picture Link

Today / Month / Year in WORD & EXCEL

Today / Month / Year :

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


2) Excel : Use  " FX" to set Today / Month / Year 

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

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

Special Type in Excel

1, Starting from 0 : use ' type.

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

after unchecked "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

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 /                      

Form (Data List) in Excel

Quick Access Toolbar / More Commands / Commands Not in 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

Chart in Excel

Chart

1. New sheet /Insert / column /

Select data

WordArt in Excel

Lock-Protect Sheet

1. Select Cells/ Right Click/ Format Cells

2. Review / Protect Sheet

2 Worksheet Arrange in Excel

Transpose in Excel

Data - Consolidate (合併計算)

1.

2.*

3.Data - Consolidate

4.Data - Consolidate with link

Salary & Expenses

Compu21 Contacts