[Software] [Microsoft Office] Excel Tip


1. What new in Excel 2013

Template 2013

-> File -> News

Excel2013

2. How to remove Duplicate Key in Excel

-> Choose all data which you want to remove duplicates

-> Data -> Choose Remove Duplicate -> ok

excel2013_2

3. Repeat Specific rows or columns on every printed page

Page Layout -> Print Tittles -> Choose Tab Sheet -> Choose “Rows to repeat at top” / “Columns to repeat at left”

Print Repeat Title in Excel File 1

Print Repeat Title in Excel File 2

Have a nice day 🙂

View original post