Software

Ask something
Discussion Locked

Keyboard Shortcuts

0 helpful
7 replies

by keepbelieving

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Greetings,
To anyone's knowledge, is there a keyboard shortcut that will allow you to print multiple worksheets while in a workbook? This is for MS Excel 97.

7 replies

by r. a. caluste

1) record a macro
2) do stuff that you normally do to print multiple worksheets
3) assign a keyboard shortcut to macro

by an_it_guy

1. Get into your Excel,
2. CTRL+SHIFT+(PG-UP or PG-DOWN) -> selects multiple sheets,
3. CTRL+P -> Initiates print command
4. hit ENTER

You get the prints of all worksheets you have chosen.

Cheers.

This discussion is closed to new replies.