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 /

 

 
 

 

 

 

 

 

Chart in Excel

Lock - Protect Sheet

Lock - Protect Sheet

1, Select Cells / Right Click / Format Cells

2, Review / Protect Sheet

Word Art in Excel

Word Art in Excel

Lock2

Lock - Protect Sheet

1. Select Cells / Right Click / Format Cells

2. Review/Protect Sheet

Transpose in Excel

Data Consolidate

Amazing Hotels

http://myscienceacademy.org/2014/02/11/21-amazing-hotels-you-need-to-visit-before-you-die/

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

Excel 2anita

Landscape/margin/Columns