| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto copy of Numbers or date
I know how to put a number or date in a cell and then generate sequencial
numbers or dates in the following cells on a horizontal plain but is it possible to say but the digit 1 in a cell and do the same for the vertical plain so that I then have a whole column of sequential numbers going down the sheet. Any help would be apprecated. Regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto copy of Numbers or date
try this
write starting number in cell A1 then standing in cell A1 go to Edit | Fill | Series | And there you can select SERIES IN Rows or Colums of course specify Stop Value. -- M.A. "chesjak" wrote in message ... I know how to put a number or date in a cell and then generate sequencial numbers or dates in the following cells on a horizontal plain but is it possible to say but the digit 1 in a cell and do the same for the vertical plain so that I then have a whole column of sequential numbers going down the sheet. Any help would be apprecated. Regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto copy of Numbers or date
Hi Marijus
Thanks for the help. Just what I wanted. "Marijus" wrote: try this write starting number in cell A1 then standing in cell A1 go to Edit | Fill | Series | And there you can select SERIES IN Rows or Colums of course specify Stop Value. -- M.A. "chesjak" wrote in message ... I know how to put a number or date in a cell and then generate sequencial numbers or dates in the following cells on a horizontal plain but is it possible to say but the digit 1 in a cell and do the same for the vertical plain so that I then have a whole column of sequential numbers going down the sheet. Any help would be apprecated. Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto date | New Users to Excel | |||
| auto working week-ending date for timesheet | Excel Worksheet Functions | |||
| the auto date feature is not functioning properly - how to reset | New Users to Excel | |||
| Changing date serial numbers | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Hybrid Mode
