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"

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 /

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. 
   

Pivot Table

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