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: