How to Print labels on each page of a spreadsheet in Excel
In this Excel magic trick video the tutor shows how to print labels on each page of a large spreadsheet in Microsoft Excel. He shows how to download the sample work book so that you can try the tutorial hands-on. He shows a spread sheet which he intends to print and wants the label of columns to be printed in the top and left of a page. For that he shows the page setup preview where you can check the print preview of the pages about to be printed. He shows that the columns appear on only the first page and do not appear on subsequent pages. Now he shows how to do a small trick to get those labels on all the other pages. This video shows how to print labels on each and every page of a large spreadsheet printout.