I have just upgraded from Appleworks and this is driving me crazy. I have a column with a hundred rows that I want to inster the same date in all the rows. I type the date in the first row and try to fill down. Numbers insists on adding on day to each row. I've even tried to force a text format by typing "Date 5//7/09" and it still a day to each row. Do I have to type a date for each row? There's got to be an easier way.
Put the same date in two consecutive rows. Select both cells then drag down on the little circle at the bottom right of the box. Or you can put the date in one cell, copy the cell, then paste it to the rest of the cells.
Put the same date in two consecutive rows. Select both cells then drag down on the little circle at the bottom right of the box. Or you can put the date in one cell, copy the cell, then paste it to the rest of the cells.
I have just spent the last 4 hours searching both help and the user guide without being able to find the answer. I will admit that I have not read all 245 pages of the user guide.
While I agree with you that some people do not do enough reaserch in finding their answers, there is a limit to how much effort they should use before asking for help.
I would very much appreciate it if you could tell me what page in the user guide the answer is. I may just learn something.
It is found in Chapter 4 on page 76. The problem with users manuals is it's easy to find something after you know what to look for but you don't necessarily know what to look for until after you've found it.
+You can also add values to cells based on value patterns. For example, if a cell contains+
+a day of the week or a month, you can select the cell and then drag to the right or+
+down to add the next day of the week or month to the adjacent cell.+
+To create new values based on numeric patterns, select two or more cells before+
+dragging. For example, if two selected cells contain 1 and 2, the values 3 and 4 are+
+added when you drag through the adjacent two cells. And if two selected cells contain+
+1 and 4, the values 7 and 10 are added when you drag through the adjacent two cells+
+(values are incremented by 3).+
I agree, but sometimes it's better to have 20/20 hindsight. I 've read that section over and over and still couldn't see the answer. With hindsight I guess the answer is
If two selected cells contain 1 and 1, the values 1 and 1 are
added when you drag through the adjacent two cells.