What is this feature?

[Diane K]

I'm playing with the Office 2007 and I can't figure out what a particular
Excel feature is for. It's on the Page Layout tab, under the Arrange menu
and it's called Selection Pane. It brings up a Selection and Visibility
pane, but I don't know what it's used for. Anyone know?

TIA,
Dino

 

[David F Cox]

"Before you print a Microsoft Office Excel worksheet that contains large
amounts of data or charts, you can quickly fine-tune it in the new Page
Layout view to achieve professional-looking results. In this view, you can
change the layout and format of data the way that you can in Normal view.
But you can also use the rulers to measure the width and height of the data,
change the page orientation, add or change page headers and footers, set
margins for printing, and hide or display row and column headers.

Note Page Layout view is useful to get your data ready for printing. Page
breaks are more easily adjusted in Page Break Preview view. For an exact
preview of how the data will be printed, you can preview the worksheet pages
in Print Preview view. For more information, see the topics Add, delete, or
move page breaks and Preview worksheet pages before printing."

Now ask me what "Help" does :->

 

[Diane K]

Thanks David, but I know what Page Layout does...it's the Selection Pane
option on the right side of the Page Layout tab. There's nothing in the help
about it.

Dino

 

[David F Cox]

oops, sorry - I should read the question properly.

Hovering over it it says to use this to select objects and change their
order and visibility.