add a check box on Excel tabs
Instead of using the control key and clicking the mouse on each tab to print
multiple tabs, I would like to see a print checkbox on each tab. I would also like to see the tab automatically printed in the heading for each sheet. Say we had sheets with tab labels of Northeast, Southeast, Midwest, Southwest, and Northwest. I envision checking the boxes only for the regions to print, with the printouts showing the labels from each one of the tabs. This would also document for other users, which sheets are currently setup for printing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
add a check box on Excel tabs
You can put the tab name in the header.
-- Regards; Rob ------------------------------------------------------------------------ "seb" wrote in message ... Instead of using the control key and clicking the mouse on each tab to print multiple tabs, I would like to see a print checkbox on each tab. I would also like to see the tab automatically printed in the heading for each sheet. Say we had sheets with tab labels of Northeast, Southeast, Midwest, Southwest, and Northwest. I envision checking the boxes only for the regions to print, with the printouts showing the labels from each one of the tabs. This would also document for other users, which sheets are currently setup for printing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
add a check box on Excel tabs
"RWN" wrote: You can put the tab name in the header. -- Regards; Rob ------------------------------------------------------------------------ "seb" wrote in message ... Instead of using the control key and clicking the mouse on each tab to print multiple tabs, I would like to see a print checkbox on each tab. I would also like to see the tab automatically printed in the heading for each sheet. Say we had sheets with tab labels of Northeast, Southeast, Midwest, Southwest, and Northwest. I envision checking the boxes only for the regions to print, with the printouts showing the labels from each one of the tabs. This would also document for other users, which sheets are currently setup for printing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup Hi Rob, Thanks, but I do realize the option is available in the page setup under the "header/footer" tab and is available for either headings or footings. My reason for the check box is to give another reader the ability to easily see which tabs are included for printing. Quite honestly, it is not very noticeable when multiple tabs are selected in group mode, which can have some "side effects" on your spreadsheet. If multiple tabs are selected, just about any modification you make on one sheet will impact the other selected sheets. For example, if sheet one and sheet three, are selected in group mode, deleting rows 7 thru 12 on sheet one, will delete rows 7 thru 12 on sheet three, but not sheet two. Our organization, has several novice Excel users occasionally making this sort of error. Their response is almost always, I didn't notice multiple tabs were highlighted (not to mention the word "group" in the blue bar. My suggestion, is really just a convenience enhancement that would accomplish two objectives. One, it would document for another reader, which tabs are selected for printing. Secondly, it would provide a convenient method to document which sheets have printed, by automatically printing the tab label. |
All times are GMT +1. The time now is 08:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com