Disappearing tabs

[Roger PB]

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

 

[Max]

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

 

[Nick Hodge]

Roger

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[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

 

[Dave Peterson]

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]

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]

Feature.

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