Highlighting Cells

mccarthym
NewLounger
Posts: 2
Joined: 30 Sep 2010, 19:57

Highlighting Cells

Post by mccarthym »

How do I highlight a selection in a worksheet when doing a pivot table without having to scroll entirely down the page?

mccarthym
NewLounger
Posts: 2
Joined: 30 Sep 2010, 19:57

Re: Highlighting Cells

Post by mccarthym »

Found the answer: Highlight the top row of the items you want to highlight; Control, Shift and down arrow.

User avatar
StuartR
Administrator
Posts: 12615
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Highlighting Cells

Post by StuartR »

Thanks for posting the solution.

When you say "highlight", do you mean "select"?
StuartR