Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reduce the number of lines in a spreadsheet? | New Users to Excel | |||
I want to split a cell diagnally and put a number on both sides. | Excel Discussion (Misc queries) | |||
What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
How do I limit number of rows and columns on a spreadsheet | New Users to Excel |