Dont want to scroll anymore

caroline.vanbommel

New Member
Joined
Aug 21, 2006
Messages
27
My problem is that scrolling is tiresom
I have in this sheet 46 products and each product has 24 rows that belong to it.
Is there a way to put in levels to a sheet. Eg 1st level you just see product name and then when you expand you see the rows benieth it.
Just like when you get a file from SAP that you have the levels in it.
THNX for the help
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

neilp

Well-known Member
Joined
Jul 5, 2004
Messages
511
Hi Caroline

Have you looked at Data---Group and outline. I think it might do what you are looking for

n
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,871
Office Version
  1. 365
Platform
  1. Windows
caroline.vanbommel

I am not sure of your exact requirements but another option may be to select your data area and apply the AutoFilter (Data|Filter|AutoFilter).
Then you can use the AutoFilter drop-down in the Product column to display just the product of interest.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top