Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2006

Tip: Looking for answers? Try searching our database.

Freezing Workbook across worksheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dax Arroway - 30 Oct 2006 22:13 GMT
I have a workbook with multiple sheets.  It's a database with each row as a
record.  Each sheet starts with a Name and ID Number feild which are the same
throughout all the sheets.  When on sheet one, if I scroll to record 150 to
reveiw data on that sheet, the other sheets don't move along with it.  So if
I wanted to look for the data of record 150 on any other sheets, I have to
scroll to them as well.  

Is there any way to freeze or lock or virtually connect these sheets
together so that, for instance, when I scroll down to a line on one sheet,
I'll be placed at that same place on all the other sheets as well?  What
would even be better, is if I highlighted a row on one sheet, if all the
other sheets could get that same line highlighted also.  I'm not sure if
that's possible but if anyone has any ideas, please pass them along.  

I appreciate any guidance you can give me and thanks in advance.  
-Dax
twickers - 31 Oct 2006 12:01 GMT
Dax Arroway Wrote:
> I have a workbook with multiple sheets.  It's a database with each row
> as a
[quoted text clipped - 21 lines]
> I appreciate any guidance you can give me and thanks in advance.  
> -Dax
hello dax.
a-one further point make sure are in the sheet you wish to initially
work on before acting
as follows
b-in excel select all tabs by
holding down shift move cursor to last tab and press return
c-any action thereafter you do /take on one sheet will reproduce on
all
that includes row /col selection / colour background on any sheet
will select same on    others.

Signature

twickers

Dax Arroway - 31 Oct 2006 22:46 GMT
Cool.  That helps select certain records accross all the sheets but this
still does not get them all the scroll together.  Any ideas about that one?

> Dax Arroway Wrote:
> > I have a workbook with multiple sheets.  It's a database with each row
[quoted text clipped - 32 lines]
> that includes row /col selection / colour background on any sheet
> will select same on    others.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.