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: 13
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: 8,377
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 online now Completely expand collapsed sections? Windows 10 Completely expand collapsed sections? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,300
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
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: 13
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 12:45 AM.


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