The only way I know how to print the actual tabs is to do a screen capture
with <Alt> + Print Screen and pasting the image into Word . Of course this
only captures the visible rows on-screen at the time of capture.
Hi Richard,
Are you really asking the question you want to ask, because if
you have a lot of sheet tabs you would not see many of them anyway.
If you want to show the sheetname for the current sheet when
printed that is easily accomplished in the heading or footer on the
printed page.
under custom headers/footers
&[Path]&[File] inserts the path and file name
or in Excel 2002 and up &Z will do both
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
