General discussion

Locked

Keyboard Shortcuts

By keepbelieving ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Keyboard Shortcuts

by DKlippert In reply to Keyboard Shortcuts

Hold down the Ctrl key and click on the sheet tabs you would like to print.

Collapse -

Keyboard Shortcuts

by keepbelieving In reply to Keyboard Shortcuts

This helped...Thanks

Collapse -

Keyboard Shortcuts

by R. A. Caluste In reply to Keyboard Shortcuts

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

Collapse -

Keyboard Shortcuts

by keepbelieving In reply to Keyboard Shortcuts

I'm not very good at remembering macros. Thanks anyway

Collapse -

Keyboard Shortcuts

by an_it_guy In reply to Keyboard Shortcuts

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.

Collapse -

Keyboard Shortcuts

by keepbelieving In reply to Keyboard Shortcuts

Thank you very much.

Collapse -

Keyboard Shortcuts

by keepbelieving In reply to Keyboard Shortcuts

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums