Thread: entering number down to cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Terry Tipsy Terry Tipsy is offline
external usenet poster
  
Posts: 37
Default entering number down to cell
Enter 1 in cell A1. Then select both cells A1 and A2. Drag these two cells
down. The number 2 will be in cell cell A3, 3 in cell A5, etc.
--
T Tipsy


"kayani" wrote:

I wanted to enter numbers in a column in ascending order leaving one cell
blank for example if I entre 1 in cell A1 in A3, 2 comes automatically
leaving A2 cell blank.
Reply With QuoteReply With Quote