memorizing print styles & ranges

Posted by Aaron Cohen on April 30, 2001 3:10 PM

In my Lotus spreadsheets I have a time saving function under Preview & Page Setup (File menu), whereby I can create and save numerous different reports as different styles. Each named style memorizes the specific range to print in addition to all the other settings. By clicking on the named style I get a ready to print report. How can I accomplish this function in Excel?

Posted by Mark on April 30, 2001 3:12 PM

---
In Excel, you can create "custom views" and then print them (big advantage is continuous page numbers) in "report manager."

Hope that helps.
mb

Posted by Aaron Cohen on April 30, 2001 4:00 PM

Thanks - can I create custom views with different "set print areas"?

Posted by Mark on April 30, 2001 4:14 PM

Sure - it's a setting of custom views, along with hidden rows, columns, and filters. In my experience, filters work, but outlines don't. Good luck.
mb