ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Collapsed category title question (https://www.excelbanter.com/setting-up-configuration-excel/232663-collapsed-category-title-question.html)

Art

Collapsed category title question
 
Hello:

I have a list of items in Column A. It has for example in A1 in BOLD a
title, and beneath it a list of items, then in A10 another title in BOLD, and
beneath it more items and so on. I then grouped each category in group so
when everything is collapsed I only see the BOLD categories, and I can select
which items to expand. However, when I print or rather copy the list and past
in a new sheet the list I want only the items that are expanded should be
copied, and not the BOLD categories. How can I make that the titles should
not be printed or copied?

Thanks

Art


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com