Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 01:29 PM
mr.woofies
 
Posts: n/a
Default Conditional Hide function for Excel

In a selected worksheet, if cells in a selected row/column are empty the
program will automatically hide those column/rows that are not filled in,
allowing spreadsheets that have been made with expected growth in mind to be
more easily worked without having to unhide and hide every time you make an
entry. Under this type of format, if you are in the cell that is for example
above an autohide area, and you hit enter or down the cell that you will go
to will be the one hidden rather than the next unhidden cell as with the
typical hide command. Prefferably, you could also separate these two buttons
- example, using enter to go to the next hidden cell and the down button to
go to the next unhidden cell. I am an engineer and I do a lot of large
multilinked spreadsheet work that is designed with future growth in mind and
this type of command would realy save me a lot of time.

  #2   Report Post  
Old October 28th 04, 03:04 PM
Paul Corrado
 
Posts: n/a
Default

Look at Data/Filter/Autofilter (Just select range of data in the one column
of data you wish to use, plus the cell above the data)

I believe you can select <Blank and <Non-Blank as options.

This may be what you are looking for


"mr.woofies" wrote in message
...
In a selected worksheet, if cells in a selected row/column are empty the
program will automatically hide those column/rows that are not filled in,
allowing spreadsheets that have been made with expected growth in mind to

be
more easily worked without having to unhide and hide every time you make

an
entry. Under this type of format, if you are in the cell that is for

example
above an autohide area, and you hit enter or down the cell that you will

go
to will be the one hidden rather than the next unhidden cell as with the
typical hide command. Prefferably, you could also separate these two

buttons
- example, using enter to go to the next hidden cell and the down button

to
go to the next unhidden cell. I am an engineer and I do a lot of large
multilinked spreadsheet work that is designed with future growth in mind

and
this type of command would realy save me a lot of time.





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
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? Likepike Excel Discussion (Misc queries) 2 December 21st 04 04:02 PM
Function in XL or in VBA for XL that pulls numeric digits from a t Nate Oliver Excel Discussion (Misc queries) 0 December 14th 04 04:57 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 12:39 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017