View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default how can i repeat one thing to a row?

Hi Brenda

You could do this with formatting.
Mark the columnFormatCellsNumberCustom # # # # #OK

Then as you enter the numbers, they will be spaced out.

--
Regards
Roger Govier

"brenda" wrote in message
...
hi i want to know how to do a thing to all the rows

well what i mean is
im writting number in one colum n want to do the same thing to the other
rows

i want to do this

1 2 2 3 1
in one coloum n im doing that for many rows is there a way to just write
numbers and the spaces between come actomatically

or i have to write one number then space bar second number then space
bar??