A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

move to cells automatically by using tab button



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 11:36 PM posted to microsoft.public.excel.worksheet.functions
bradleyGSK
external usenet poster
 
Posts: 1
Default move to cells automatically by using tab button

good day
firstlt i ave a sheet with 12374 cells which i have condition formated to
change cell colour for value between a certain number.these cells are
scattered across the page .how can i jump to them automatically.for example
ii should press tab it must go to the next cell containing format and if i
press tab again it must go to next cell it registers that have a codion
format and so on.instead of me scrolling looking for cell colour changes
thanks for the help
  #2  
Old May 22nd, 2010, 11:53 PM posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
external usenet poster
 
Posts: 516
Default move to cells automatically by using tab button

One way is to name the cell range. Might be a large task given the 12k plus
cells.

Start with the second cell of the sequence and while holding down the Ctrl
key select each cell until you are back to the FIRST cell. Click in the
name box ad enter a suitable name, then Enter.

So now when you want to cruise through those cells, you click on the name
box arrow and select the named range and all those cells will be
highlighted. Now Tab away. If you know you have a long way to go to get to
a certain cell you can hold the TAB key down and you will zip pretty fast
through the cells.

It may be you will want to have several named ranges depending on certain
data or what ever.

HTH
Regards,
Howard

"bradleyGSK" wrote in message
...
good day
firstlt i ave a sheet with 12374 cells which i have condition formated to
change cell colour for value between a certain number.these cells are
scattered across the page .how can i jump to them automatically.for
example
ii should press tab it must go to the next cell containing format and if i
press tab again it must go to next cell it registers that have a codion
format and so on.instead of me scrolling looking for cell colour changes
thanks for the help



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.