Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How to number lines (rows) on both sides of spreadsheet

On Apr 6, 12:44 pm, crb.e4xplor
wrote:
I WOULD LIKE TO HAVE THE LINE (ROW) NUMBERS THAT APEAR ON LEFT SIDE TO BE
MIRRORED ON THE RIGHT SIDE OF THE SPREASDSHEET AS WELL; IS THERE A WAY TO DO
THIS?


select a cell that is on the right side of your sheet.
type =
click the left (numbered) in the same row
hit enter

you can copy amd paset this cell down as low as you like
or you can use the box drag feature to quickly do the same

if you copy this lower than the last value on the left.. and the zeros
are a problem..?
you may want to use =IF(ISBLANK( left ),"",left) where left is the
left cell name (eg C9)
it makes those corresponding cells contain an empty string ""

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How to number lines (rows) on both sides of spreadsheet

perhaps you mean the numbers given by excel... within the program?
not generated by you in a column..?

then i do not know if this is possible

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reduce the number of lines in a spreadsheet? Philamon New Users to Excel 2 February 12th 06 09:29 PM
I want to split a cell diagnally and put a number on both sides. JPreeshl Excel Discussion (Misc queries) 1 February 11th 06 12:25 AM
What is the maximum number of rows in an Excel spreadsheet ? Larry Liu Excel Discussion (Misc queries) 5 September 20th 05 06:06 PM
cells() and counting number or rows on spreadsheet HeatherO Excel Worksheet Functions 7 March 2nd 05 10:36 AM
How do I limit number of rows and columns on a spreadsheet Valser New Users to Excel 3 February 12th 05 10:31 PM


All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"