Display row numbers on both sides of worksheet

  Forum Editor 14:57 01 Mar 2019

Can it be done in Excel - does anyone know how to do it?

  qwbos 16:34 01 Mar 2019

A simple workaround would be to mirror the row numbers in a column on the right hand side of the worksheet and freeze the column.

  Fruit Bat /\0/\ 17:27 01 Mar 2019


Tools menu - Options - General tab - Settings, click to clear the R1C1 reference style check box (upper-left corner), and click OK.

  wee eddie 21:02 01 Mar 2019

Freeze Panes!

  lotvic 00:16 02 Mar 2019

Fruit Bat /\0/\, R1C1 reference style only changes the columns from a b c to 1 2 3 (R1 means the Rows are numbered 1 2 3 and C1 means the Columns are also numbered 1 2 3) instead of the usual reference style of A1

Example:cell E4 would become referenced as R4C5

As far as I know, there is not a way to Display row numbers on both sides of worksheet. Only work-around is to manually dedicate a Column and insert your own numbering.

  lotvic 01:40 02 Mar 2019

A work-around that utilises View Side by Side and Synchronous scrolling. I have Excel 2007

  1. Click on New Window
  2. View Side by Side
  3. Synchronous Scrolling
  4. Drag the 2nd window to a narrow width and position it over to the far right
  5. Drag 1st window to fill rest of display space
  6. Evenly line both up to show cell row number same at top left of each window

What is Markdown?

Markdown lets you add more formatting to your post. Simply type in your post and it will display as written.

If you wish to add bold or italic characters, add a hyperlink to another website, a heading or a horizontal line, simply use the relevent icons above the text input field.

A preview of your post will appear in the grey box below. If you make a change and you're not happy, simply press the back arrow icon to undo.

Post a Reply


Elsewhere on IDG sites

Samsung Galaxy Note 10 Now On Sale: Price, Specification & Features

Best free Photoshop brushes 2019

Apple TV streaming service: what, where, when and how much

Les meilleurs écouteurs et casques audio Lightning (2019)