Thread: Hiding rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Hiding rows

For the summary rows to be on top try the below

Uncheck 'Summary rows below detail' from menu DataGroup and OutlineSettings

If this post helps click Yes
---------------
Jacob Skaria


"cheggers" wrote:

I have a list of assets in rows A1 to A200. Underneath each asset heading I
want to add a sub-asset which I can hide from view when required. I have
tried using "Groups" but this gives me a + sign in the row underneath the
main asset description. Is there any way that the + sign can be next to the
main heading?

If you have a better idea of how to do this please let me know also.

Thanks.