Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2022, 03:58 PM
NitroPress NitroPress is offline Completely expand collapsed sections? Windows 10 Completely expand collapsed sections? Office 2016
Novice
Completely expand collapsed sections?
 
Join Date: Nov 2019
Posts: 22
NitroPress is on a distinguished road
Default Completely expand collapsed sections?

Is there a command (VBA preferred) to completely expand all sections in a document? I've found all kinds of writeups that tell how to do it one heading at a time, but is there a way to hit one (macro) key and have all collapsed headings expanded — say, for final printout, without tediously searching for all collapsed sections?




Thx!
Reply With Quote
  #2  
Old 12-01-2022, 04:45 PM
Charles Kenyon Charles Kenyon is offline Completely expand collapsed sections? Windows 11 Completely expand collapsed sections? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You can set the option to expand all headings upon opening. Close and reopen the document.

00 deleteme 1.png


[Note: Andrew has better solutions below.]



Last edited by Charles Kenyon; 12-02-2022 at 10:04 PM.
Reply With Quote
  #3  
Old 12-01-2022, 05:35 PM
Guessed's Avatar
Guessed Guessed is offline Completely expand collapsed sections? Windows 10 Completely expand collapsed sections? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you right click the document a context sensitive menu will appear with an Expand/Collapse dropdown which lets you select Expand All Headings.

You can also find the command 'Expand All Headings' to add to the Quick Access Toolbar.

If you wanted it as a VBA command it would be
Code:
ActiveWindow.View.ExpandAllHeadings
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 12-02-2022, 01:32 PM
NitroPress NitroPress is offline Completely expand collapsed sections? Windows 11 Completely expand collapsed sections? Office 2016
Novice
Completely expand collapsed sections?
 
Join Date: Nov 2019
Posts: 22
NitroPress is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
If you right click the document a context sensitive menu will appear with an Expand/Collapse dropdown which lets you select Expand All Headings.
Can't find such a menu item in Word 2016. That's where I started.


Quote:
You can also find the command 'Expand All Headings' to add to the Quick Access Toolbar.

If you wanted it as a VBA command it would be
Didn't think to look in All Commands; thanks for both points!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Collapsed Cells kchris Excel 3 10-14-2022 06:42 AM
Expand & Collapse - wont open doc as collapsed faodavid Word 2 06-05-2019 08:31 AM
Printing collapsed texts as is? New Daddy OneNote 0 08-01-2017 07:30 AM
Completely expand collapsed sections? Comments collapsed in document hander Word 2 10-09-2015 05:33 AM
Completely expand collapsed sections? Ribbon and all labels collapsed Hebephrene OneNote 1 08-27-2014 07:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft