Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 22nd 08, 10:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 1
Default One-click hide or unhide rows & columns

Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory?

  #2   Report Post  
Old March 22nd 08, 10:38 PM posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default One-click hide or unhide rows & columns

"Togowa" wrote:
Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory?


Try Data Group and Outline

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Old March 22nd 08, 10:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default One-click hide or unhide rows & columns

Only if you had your data grouped under DataGroup and Outline.

Otherwise CTRL + 9 hides selected rows.

CTRL + SHIFT + ( unhides rows

CTRL + 0 and CTRL + SHIFT + ) for columns

A one click faeture would be a toggle macro assigned to a button.

Sub togglethings()
Selection.EntireRow.Hidden = Not Selection.EntireRow.Hidden
' Selection.EntireColumn.Hidden = Not Selection.EntireColumn.Hidden
End Sub


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 15:08:01 -0700, Togowa
wrote:

Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory?


  #4   Report Post  
Old August 11th 12, 06:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 1
Default One-click hide or unhide rows & columns

On Saturday, March 22, 2008 6:08:01 PM UTC-4, Togowa wrote:
Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory?


Group and Ungroup columns
1. Highlight Columns that are side by side.
2. In the Data tab, in the Outline group, click the group icon,


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide / Unhide columns and rows PaulM Excel Discussion (Misc queries) 8 September 6th 07 12:14 AM
Hide/Unhide columns using button on top over relevant columns [email protected] Excel Discussion (Misc queries) 1 March 7th 07 09:24 PM
Unhide rows when you click a cell lauren_roberts08 Excel Discussion (Misc queries) 1 June 13th 06 08:27 PM
How to hide and unhide Rows & Columns Aarif Excel Worksheet Functions 3 March 23rd 06 05:19 AM
How do I hide or unhide zero value columns/rows USING A MACRO? paul Excel Discussion (Misc queries) 1 January 23rd 06 03:06 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017