Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-26-2015, 05:22 AM
Debaser's Avatar
Debaser Debaser is offline Want to show/hide mutiple grouped coloumns in Excel sheet with a button Windows 7 64bit Want to show/hide mutiple grouped coloumns in Excel sheet with a button Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

I'm not clear on what you mean about the colours but you can use CustomViews to achieve your primary goal. Simply hide one set of columns, then select View - CustomViews - Add... and save that view. Then show all columns and hide the other set and add another view. You may now switch between the two views as you would like.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Hide/Un-hide a worksheet based on cell on another sheet. easton11 Excel Programming 1 06-02-2015 12:07 PM
Want to show/hide mutiple grouped coloumns in Excel sheet with a button Assign macro but hide the button/field trlear Word VBA 5 02-23-2012 04:35 PM
Want to show/hide mutiple grouped coloumns in Excel sheet with a button VBA to show/hide tables ccordner Word VBA 2 07-04-2011 03:00 AM
VBA to show/hide tables ccordner Outlook 0 07-01-2011 05:10 AM
Want to show/hide mutiple grouped coloumns in Excel sheet with a button Button in hidden section won't hide Joe Patrick Word 6 06-07-2011 09:31 AM

Other Forums: Access Forums

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


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