Limiting and controlling the amount of Rows displayed

Czeszyn · #1 10-07-2015, 11:11 AM

I created my pivottable but some time there are too many rows displayed at one. Is there away to have it only display say 5, and a scrollbar would then allow to scroll down the rest?

gebobs · #2 10-13-2015, 11:37 AM

You can filter. That's the only way to limit the data displayed for any particular pivot so far as i know.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limiting the number of views of a PPT	inventorpilotgeorge	PowerPoint	3	02-17-2013 04:46 AM
Controlling StyleRef display in header	Cheryl K	Word	0	02-07-2013 10:59 AM
Controlling Label Maker with PowerPoint	hudsontucker13	PowerPoint	4	12-11-2012 10:46 PM
Limiting a macro to a selection	Ulodesk	Word VBA	4	06-19-2012 06:09 AM
Limiting the times that it runs	hchbiker	PowerPoint	0	02-09-2011 08:36 AM