| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
filling a series
How can I fill a series of cells with dragging, where the first entry is
"PV-A", and the filled cells are "PV-B", "PV-C", and so on? |
|
#2
|
|||
|
|||
|
Hi
try the following in A1: ="PV-" & CHAR(64+ROW()) and copy down -- Regards Frank Kabel Frankfurt, Germany Wazooli wrote: How can I fill a series of cells with dragging, where the first entry is "PV-A", and the filled cells are "PV-B", "PV-C", and so on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Plotting different length series in a chart | Charts and Charting in Excel | |||
| Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
| How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel | |||
Linear Mode
