LinkBack URL
About LinkBacksDavid,
I understand your response completely, and the split function does work as
well as creating a copy of one half of the document and pasting it onto
another sheet, then veiwing the two sheets at the same time, but ultimately
what would be the most efficient is to have another scroll bar right down the
middle to be able to operate each half independently. A good example of what
I'm tring to accomplish is in the discussion group we are using to
communicate. One side contains the questions and number of posts and the
other side has the reply(s); each with its independent scroll bar. Can this
be accomplished in Excel?
Thanks - Joe
"David McRitchie" wrote:
> Hi Joe,
> Think I answered your question, but my web page does not have pictures
> on it. The part about one side not going down as far as the other side does
> not fit in with a double split, but the part about avoiding scrolling to the top
> and back is what SPLIT is about. Choosing the point to split at is what you
> have to select and you can move the split by dragging the black bar between
> the scrollers or drag it out of the scrolling areas to remove it.
>
> Here is an example with pictures though it does not show the
> scrollers. http://www.dailydoseofexcel.com/arch...r-row-headers/
>
> I don't even know what the rating question looks like, and really don't want to
> know, nor have anything to do with any web based interface to newsgroups.
> Some of the other web interfaces actually destroy use of newsgroups, and
> web searching, mainly those that have "forum" in their names.
>
> The rating is probably an attempt to find out if the question was answered or
> not, which would show up in Microsoft Communities. It would never be seen
> by those who post directly to the newsgroups with a newsreader. So if something
> is not obviously answered (like this question) we would not know unless you post
> an actual response. . .
>
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "joedl_001@hotmail.com" <joedl001hotmailcom@discussions.microsoft.com> wrote in message
> news:50C3760D-B492-436A-8E82-39D89B56CECD@microsoft.com...
> > Hi David,
> > I'm working on an Excel sheet that is broken down to two parts. On one side
> > of the sheet has info and values and the other side has relative info. The
> > side with the relative info goes down much farther than the side with the
> > values. So when I get ready to enter values on the other side I have to
> > scroll back up to the top. I'd like to insert a verticle scroll bar for the
> > "values" half of the sheet to keep it aligned with the "relative info" side.
> >
> > P.S. I'm being asked to rate your response - from where am I supossed to
> > provide rate info.
> > "David McRitchie" wrote:
> >
> > > Hi Joe,
> > > Specifically in Excel you have on the window menu of Excel
> > > Freeze and Split they are pretty much the same and are mutually exclusive.
> > > Split will get you a (one) split horizontal and/or vertical and the areas are separately
> > > scrollable. http://www.mvps.org/dmcritchie/excel/freeze.htm
> > >
> > > To split both ways Select cell F15 then window, split -- to undo window, remove split
> > > To split just on rows select cell A15 then window, split -- to undo window, remove split
> > > to split just on columns seelct cell F1 then window, spli -- to undo window, remove splitt
> > >
> > > ---
> > > HTH,
> > > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > >
> > > "joedl_001@hotmail.com" <joedl_001@hotmail.com@discussions.microsoft.com> wrote in message
> > > news:A34EF322-CA77-4A92-85CE-FED81D2C1148@microsoft.com...
> > > >
> > >
> > >
> > >
>
>
>
Register To Reply
Bookmarks