Layout Parts and other Issues - Part II

21/11/2016
MS
Q. How to set Different First Page (like the same setting in MSWord in the Layout Tab in the Page Setup Dialogue Box), so that the fancy letterhead print ONLY on the first page and doesn't print on subsequent pages of the same Layout?
A.  Place the fancy letterhead parts in the Body Part, as opposed to placing it in the Header / Footer Part(s).

Excel

27/09/2016
MS
Q. How do I delete all Rows that have no Data in the second Column?
A. See the following Excel Teaching Resources:
www.excel-aid.com

http://excel.bigresource.com/Find-last-cell-in-column-and-increment-g91L43ts.html#2hlvjdLB

http://social.msdn.microsoft.com/Search/en-us?query=insert+a+checkbox+in+excel

http://spreadsheets.about.com/od/excel2010functions/ss/2011-01-30-excel-2010-concatenate-text-strings.htm

http://www.auditexcel.co.za/online-training-courses

http://www.excelforum.com

http://www.excelforum.com/excel-programming-vba-macros/669610-find-last-cell-in-column-and-increment.html

http://www.excelfox.com/forum/forum.php

http://www.excel-it.com

http://www.google.co.uk/search?sugexp=chrome,mod=13&sourceid=chrome&ie=UTF-8&q=%22find+and+replace%22+%22tab+spacing%22+-text+-import+-spelling+-labels+-sheet#hl=en&safe=active&as_qdr=all&q=%22find+and+replace%22+%22tab+spacing%22+-text+-import+-spelling+-excel+-labels+-sheet+-queries&oq=%22find+and+replace%22+%22tab+spacing%22+-text+-import+-spelling+-excel+-labels+-sheet+-queries&aq=f&aqi=&aql=&gs_l=serp.3...29358.30435.0.31114.2.2.0.0.0.0.170.261.1j1.2.0...0.0.Vl8nqOsnqd0&bav=on.2,or.r_gc.r_pw.r_cp.,cf.osb&fp=6f9478a7e93b12c7&biw=1024&bih=612

http://www.instructables.com/id/Breaking-apart-text-using-Excel

http://www.techrepublic.com/blog/microsoft-office/quickly-fill-blank-cells-in-excel

http://www.vertex42.com/ExcelLinks