Recording a Macro to Print the Worksheet in Portrait Orientation Using the Fit to Option If necessary, click the Developer tab on the Ribbon Click the Record Macro button on the Ribbon to display the Record Macro dialog box When the Record Macro dialog box appears, type PrintPortrait in the Macro name text box Type r in the Shortcut key text box to set the shortcut key for the macro to CTRL+R Make sure the 'Store macro in' box displays This Workbook and then type Macro prints worksheet in portrait orientation on one page in the Description text box Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition16
{}