Row headings on BOTH sides of spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to display row headings on the left side of a spreadsheet

Is there a way to display row headings also on the right side

Thank you for your assistance!
 
No.

You could, of course, enter a series of numbers in your rightmost
column and shade the cells to match the left row heading.

Or, as a real kluge, you could use Window/New Window to create a
second window, aligning it with the first and use event macros to
keep the rows synchronized (post back, or look in the archives:

http://google.com/advanced_group_search?q=group:*excel*

). Hiding the vertical scroll bar (Tools/Options) creates a better
visual effect.
 
If you have excel 2002 onwards you can change that under
tools>options>international and select
view current sheet right to left
 
Is your print one page wide?

If yes, then maybe a helper column that just points back at the first column:

=if(a1="","",a1)
(dragged down)

If you have multiple pages wide, I think you could hide some of the columns and
show the far right helper column, too.
 
Thank you for all of your suggestions. I have a follow-up question

I'm afraid that I failed to specify that I wanted to be able to print a spreadsheet with row headings on both sides. However, as suggested, if I make the cells in Column A equal to the row number, then I can use the following formula: =if (a1="","",a1) (and so forth...

In that case, is there an easy formula for Column A? I was just thinking that if I enter Column A in manually, and later insert, delete, or move rows around, I will have to change all those cells.

Thanks!
 
If it's just row numbers, you could use

=row()

in both columns.

But you may like this, too:

File|page setup|Sheet Tab
check Row and column headings.

You'll get the left hand side and the columns, too.
 
Back
Top