Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Page Breaks
Hiding page breaks in excel 2007 is now a painful multi-step process that
requires you to select the office button, hit "excel options," select the "advanced" tab, and scroll down and search for the check box to deselect. CAN MICROSOFT CREATE SOMETHING SIMPLER? There is an empty space in the "Show/Hide" box under the VIEW tab. I think someone forgot to put the page breaks toggle box here... ---------------- 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...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Page Breaks
I bet you didn't realise how efficient Microsoft can be !!!!!
Having read your post they have attached the following to your computer today! To view, press Office button, select Excel Options, click on Customize, select from - Choose command from:, scroll down (nearly half way) select Insert or Remove Page Break, click Add , then OK. What do you know, an icon that you can click on has appeared on the Quick Access Toolbar. Isn't Microsoft wonderful? Hope this helps "Joe" wrote: Hiding page breaks in excel 2007 is now a painful multi-step process that requires you to select the office button, hit "excel options," select the "advanced" tab, and scroll down and search for the check box to deselect. CAN MICROSOFT CREATE SOMETHING SIMPLER? There is an empty space in the "Show/Hide" box under the VIEW tab. I think someone forgot to put the page breaks toggle box here... ---------------- 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...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Page Breaks
Thanks Ron but i've seen that command on the customize list and it's not what
i'm looking for. I'm not trying to "remove" or "add" a page break. I'm simply trying to hide/unhide from view when working in a spreadsheet. The process of hiding/unhiding the page breaks is tedious and should have it's own check box on the view pane. Let me know if there is another solution but I think Microsoft fumbled the ball on this one... "Ron@Buy" wrote: I bet you didn't realise how efficient Microsoft can be !!!!! Having read your post they have attached the following to your computer today! To view, press Office button, select Excel Options, click on Customize, select from - Choose command from:, scroll down (nearly half way) select Insert or Remove Page Break, click Add , then OK. What do you know, an icon that you can click on has appeared on the Quick Access Toolbar. Isn't Microsoft wonderful? Hope this helps "Joe" wrote: Hiding page breaks in excel 2007 is now a painful multi-step process that requires you to select the office button, hit "excel options," select the "advanced" tab, and scroll down and search for the check box to deselect. CAN MICROSOFT CREATE SOMETHING SIMPLER? There is an empty space in the "Show/Hide" box under the VIEW tab. I think someone forgot to put the page breaks toggle box here... ---------------- 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...et.f unctions |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Page Breaks
Joe
OK, understand where your coming from. I guess then that one option is to create your own VBA macros with two buttons ActiveSheet.DisplayPageBreaks = True to turn on page break and ActiveSheet.DisplayPageBreaks = False to turn off. Probably the best solution available for XL2007 at the moment! "Joe" wrote: Thanks Ron but i've seen that command on the customize list and it's not what i'm looking for. I'm not trying to "remove" or "add" a page break. I'm simply trying to hide/unhide from view when working in a spreadsheet. The process of hiding/unhiding the page breaks is tedious and should have it's own check box on the view pane. Let me know if there is another solution but I think Microsoft fumbled the ball on this one... "Ron@Buy" wrote: I bet you didn't realise how efficient Microsoft can be !!!!! Having read your post they have attached the following to your computer today! To view, press Office button, select Excel Options, click on Customize, select from - Choose command from:, scroll down (nearly half way) select Insert or Remove Page Break, click Add , then OK. What do you know, an icon that you can click on has appeared on the Quick Access Toolbar. Isn't Microsoft wonderful? Hope this helps "Joe" wrote: Hiding page breaks in excel 2007 is now a painful multi-step process that requires you to select the office button, hit "excel options," select the "advanced" tab, and scroll down and search for the check box to deselect. CAN MICROSOFT CREATE SOMETHING SIMPLER? There is an empty space in the "Show/Hide" box under the VIEW tab. I think someone forgot to put the page breaks toggle box here... ---------------- 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...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
Different Page Numbers In Worksheet w/Page Breaks | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
Hiding page breaks | Excel Discussion (Misc queries) |