Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sequence
how to make a cell advance numericialy
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sequence
What does that mean? Accumulator?
http://www.mcgimpsey.com/excel/accumulator.html If you mean that if you have a number in a cell like 1 and when you copy it down it will change to 2 in the next cell and 3 and so on. Right click and copy then select fill series or select a range of cells and use editfillseries or put 1 in one cell and 2 in the next and grab both cells and copy down -- Regards, Peo Sjoblom "samszoo4" wrote in message ... how to make a cell advance numericialy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sequence
Forgot one, type 1 in a cell, hold down ctrl and copy down and it will
increment -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... What does that mean? Accumulator? http://www.mcgimpsey.com/excel/accumulator.html If you mean that if you have a number in a cell like 1 and when you copy it down it will change to 2 in the next cell and 3 and so on. Right click and copy then select fill series or select a range of cells and use editfillseries or put 1 in one cell and 2 in the next and grab both cells and copy down -- Regards, Peo Sjoblom "samszoo4" wrote in message ... how to make a cell advance numericialy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sequence
I have created a worksheet. I would like it to keep a record of each time I
open the worksheet. Each time I open it, it will open a new worksheet with the next sequencail number. "Peo Sjoblom" wrote: Forgot one, type 1 in a cell, hold down ctrl and copy down and it will increment -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... What does that mean? Accumulator? http://www.mcgimpsey.com/excel/accumulator.html If you mean that if you have a number in a cell like 1 and when you copy it down it will change to 2 in the next cell and 3 and so on. Right click and copy then select fill series or select a range of cells and use editfillseries or put 1 in one cell and 2 in the next and grab both cells and copy down -- Regards, Peo Sjoblom "samszoo4" wrote in message ... how to make a cell advance numericialy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
SETUP AUTO SEQUENCE | Excel Discussion (Misc queries) | |||
How do I set up Auto sequence number in excle | Charts and Charting in Excel | |||
min and max in a sequence | Excel Worksheet Functions | |||
auto fill sequence... | Excel Worksheet Functions |