LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
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 07:19 AM.

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

About Us

"It's about Microsoft Excel"