Handouts & Presentations

www.tammyworcester.com

Enter these formulas on a new sheet in cell A1:

ArrayFormula
Creates an exact replica of the data from sheet 1

1. 1.Create a new sheet.
   

2. 2.Enter the following formula:
   =Arrayformula(Sheet1!A:E)
   
   Note: Adjust A:E to the desired range of columns.
   

Transpose Formula

Changes data from rows to columns

1. 1.Create a new sheet.
   

2. 2.Enter the following formula:
   =Transpose(Sheet1!A:E)
   
   Note: Adjust A:E to the desired range of columns.
   

Printing All Records (One per page)

1. 1.Follow the directions above to transpose the data.
   

2. 2.Change the column widths to 725.
   

3. 3.Choose the print options shown in the screen shot below.
   
   Note - The number 725 may need to be adjusted for different printers.
   

Finding/Printing Individual Records

1. 1.Coming soon!