Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill
I know to create 1, 2, 3, 4, etc., down 1 column, I would use the fill handle
and drag down or to the side to continually number. However, the numbering I need to create is 1L, 2L, 3L, 4L, etc., down in 1 column. Is there a way to do this easily in Excel? I am sure it is very simple and I just can't seem to figure it out. Thanks! |
#2
|
|||
|
|||
Shan,
I don't think the Fill Handle, nor paste special will do what you want. If you can use L1, L2... instead, the Fill Handle will do it. You could put only the 1, 2, 3, etc. in the cell (which the Fill Handle will facilitate), and format (Format - Cells - Number - Custom) as General"L" Any formulas with reference to the cells will get the number only, without the L. -------------------------------------- You could use =ROW() & "L" This works only starting in row 1. --------------------------------------- If L1 will be in a row other than row 1, you could put 1L in the first, then in the next cell down, use: =ROW() -ROW(A2) + 1 & "L" This is for the first one being in A2. Change the reference to A2 as needed. The formula above would go in A3. Copy down. You won't be able to move these around, or sort the table, or delete or insert rows, as everthing will get renumbered consecutively. To make them permanent (so each will be a hard value, and can be sorted, deleted, moved, etc), you could copy all these cells, then Paste Special - Values. now you'llhave a hard 1L, 2L... in each cell, as if you'd typed them. -- Earl Kiosterud www.smokeylake.com "Shan" wrote in message ... I know to create 1, 2, 3, 4, etc., down 1 column, I would use the fill handle and drag down or to the side to continually number. However, the numbering I need to create is 1L, 2L, 3L, 4L, etc., down in 1 column. Is there a way to do this easily in Excel? I am sure it is very simple and I just can't seem to figure it out. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Fill Color Red | Excel Discussion (Misc queries) | |||
Fill colour red | Excel Discussion (Misc queries) |