#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default auto sequence

how to make a cell advance numericialy
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
SETUP AUTO SEQUENCE Steve Excel Discussion (Misc queries) 5 October 27th 06 09:45 PM
How do I set up Auto sequence number in excle Nassir Charts and Charting in Excel 0 June 8th 06 08:09 PM
min and max in a sequence bill gras Excel Worksheet Functions 11 May 16th 06 11:33 PM
auto fill sequence... tiaj Excel Worksheet Functions 3 March 24th 06 04:59 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"