Disappearing tabs
 

If I slide the dividing bar to the left, so as to keep column A always on
screen, I find this causes the tabs identifying the different worksheets to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of the
dividing bar?

Roger PB

Believe you're using Window Split on col A

Perhaps try instead Window Freeze Panes with B2 selected?
This'll freeze col A and the top row, but w/o affecting the sheet tabs
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always on
screen, I find this causes the tabs identifying the different worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of the
dividing bar?

Roger PB

Roger

It sounds like you are using a new window to keep the columnA visible. You
can do this by freezing the panes (WindowFreeze panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always on
screen, I find this causes the tabs identifying the different worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of the
dividing bar?

Roger PB

Thanks for the answers. Solved a long-standing niggle.

But here is a follow-up:

Along the top row of any Excel spreadsheet I find A, B, C, etc.
And running vertically down are 1,2,3.

So, logically, the ROWS are 1,2,3 (If I click on 2, it highlights a row, not
a column!)
and the COLUMNS are ABC

The fourth cell to the right in the first row should logically be row 1,
column 4, or 1D.
But the identifying box at the top left of the screen shows it as D1.

So it appears that Excel identifies cells first by column, then by row.

However, various manuals identify "D1" as
"where row D intersects with column 1",
and I have always understood that the identifier shows first the row, then
the column.
Can someone explain this seeming inconsistency?

Is there an option or macro to change the axes?

Roger PB

"Nick Hodge" schrieb im
Newsbeitrag ...
Roger

It sounds like you are using a new window to keep the columnA visible.
You can do this by freezing the panes (WindowFreeze panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always on
screen, I find this causes the tabs identifying the different worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of the
dividing bar?

Roger PB

If this was printed in a manual:
"where row D intersects with column 1",
it was a typo.

Rows are numbered 1:65536.
Columns are labeled A:IV

Be aware that you can number the columns, too.

Tools|Options|General Tab|Check R1C1 reference style.
Then the columns will be numbered 1:256.

And a cell (D1 in "normal" view) will show as
R1C4
(row 1, column 4)



Roger PB wrote:

Thanks for the answers. Solved a long-standing niggle.

But here is a follow-up:

Along the top row of any Excel spreadsheet I find A, B, C, etc.
And running vertically down are 1,2,3.

So, logically, the ROWS are 1,2,3 (If I click on 2, it highlights a row, not
a column!)
and the COLUMNS are ABC

The fourth cell to the right in the first row should logically be row 1,
column 4, or 1D.
But the identifying box at the top left of the screen shows it as D1.

So it appears that Excel identifies cells first by column, then by row.

However, various manuals identify "D1" as
"where row D intersects with column 1",
and I have always understood that the identifier shows first the row, then
the column.
Can someone explain this seeming inconsistency?

Is there an option or macro to change the axes?

Roger PB

"Nick Hodge" schrieb im
Newsbeitrag ...
Roger

It sounds like you are using a new window to keep the columnA visible.
You can do this by freezing the panes (WindowFreeze panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always on
screen, I find this causes the tabs identifying the different worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of the
dividing bar?

Roger PB





--

Dave Peterson

If this was printed in a manual:
"where row D intersects with column 1",
it was a typo.

It was in a best-selling QUE manual for an older version of Excel.!

Thanks for confirming that normal view displays the column first, then the
row.
Whereas the R1C1 view displays the row first, then the column.

A bug, or a feature?

Roger PB

"Dave Peterson" schrieb im Newsbeitrag
...
If this was printed in a manual:
"where row D intersects with column 1",
it was a typo.

Rows are numbered 1:65536.
Columns are labeled A:IV

Be aware that you can number the columns, too.

Tools|Options|General Tab|Check R1C1 reference style.
Then the columns will be numbered 1:256.

And a cell (D1 in "normal" view) will show as
R1C4
(row 1, column 4)



Roger PB wrote:

Thanks for the answers. Solved a long-standing niggle.

But here is a follow-up:

Along the top row of any Excel spreadsheet I find A, B, C, etc.
And running vertically down are 1,2,3.

So, logically, the ROWS are 1,2,3 (If I click on 2, it highlights a row,
not
a column!)
and the COLUMNS are ABC

The fourth cell to the right in the first row should logically be row 1,
column 4, or 1D.
But the identifying box at the top left of the screen shows it as D1.

So it appears that Excel identifies cells first by column, then by row.

However, various manuals identify "D1" as
"where row D intersects with column 1",
and I have always understood that the identifier shows first the row,
then
the column.
Can someone explain this seeming inconsistency?

Is there an option or macro to change the axes?

Roger PB

"Nick Hodge" schrieb im
Newsbeitrag ...
Roger

It sounds like you are using a new window to keep the columnA visible.
You can do this by freezing the panes (WindowFreeze panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always
on
screen, I find this causes the tabs identifying the different
worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of
the
dividing bar?

Roger PB





--

Dave Peterson

Feature.



Roger PB wrote:

If this was printed in a manual:
"where row D intersects with column 1",
it was a typo.

It was in a best-selling QUE manual for an older version of Excel.!

Thanks for confirming that normal view displays the column first, then the
row.
Whereas the R1C1 view displays the row first, then the column.

A bug, or a feature?

Roger PB

"Dave Peterson" schrieb im Newsbeitrag
...
If this was printed in a manual:
"where row D intersects with column 1",
it was a typo.

Rows are numbered 1:65536.
Columns are labeled A:IV

Be aware that you can number the columns, too.

Tools|Options|General Tab|Check R1C1 reference style.
Then the columns will be numbered 1:256.

And a cell (D1 in "normal" view) will show as
R1C4
(row 1, column 4)



Roger PB wrote:

Thanks for the answers. Solved a long-standing niggle.

But here is a follow-up:

Along the top row of any Excel spreadsheet I find A, B, C, etc.
And running vertically down are 1,2,3.

So, logically, the ROWS are 1,2,3 (If I click on 2, it highlights a row,
not
a column!)
and the COLUMNS are ABC

The fourth cell to the right in the first row should logically be row 1,
column 4, or 1D.
But the identifying box at the top left of the screen shows it as D1.

So it appears that Excel identifies cells first by column, then by row.

However, various manuals identify "D1" as
"where row D intersects with column 1",
and I have always understood that the identifier shows first the row,
then
the column.
Can someone explain this seeming inconsistency?

Is there an option or macro to change the axes?

Roger PB

"Nick Hodge" schrieb im
Newsbeitrag ...
Roger

It sounds like you are using a new window to keep the columnA visible.
You can do this by freezing the panes (WindowFreeze panes)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Roger PB" wrote in message
...
If I slide the dividing bar to the left, so as to keep column A always
on
screen, I find this causes the tabs identifying the different
worksheets
to
disappear, and they can only be found be moving the bar back or right
clicking the arrow heads at the bottom left of the screen.

Is there some way to keep the tabs visible, but on the right side of
the
dividing bar?

Roger PB





--

Dave Peterson

--

Dave Peterson