Results 1 to 2 of 2
Hi, I can't figure out how to perform a certain task in Calc. I need to put the same date in one column, consisting of about 2000-3000 rows. But each ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 03-30-2006 #1
- Join Date
- Feb 2005
openoffice.org calc problem
I can't figure out how to perform a certain task in Calc. I need to put the same date in one column, consisting of about 2000-3000 rows.
But each time I put the date in one cell, and then click on the lower right hand side of the cell, (like MS Excel), it distributes the date down through the column, but the dates are ascending. 3/30/06, 3/31/06, 4/1/06, etc. I have even tried to put the date in two cells, select both cells, then double-click on the right hand corner, but I get the same result.
How do I accomplish this without having to copy and paste the same date in each cell?
Any help or suggestions would be greatly appreciated!
- 03-30-2006 #2
Easiest way I can think to do it:
Put the date in one cell, right-click and copy it (or select copy from the Edit menu).
Go down to the last cell where you want the date.
Hit CTRL-SHIFT-HOME to highlight all the cells from that one to row 1 (if you're not in column 1, you may need to arrow over while still holding the SHIFT key).
Paste.Stand up and be counted as a Linux user!