Find the answer to your Linux question:
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.
  1. #1
    Just Joined!
    Join Date
    Feb 2005
    Location
    Californ-i-a
    Posts
    9

    openoffice.org calc problem


    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 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!

    Thanks, th3gh05t

  2. #2
    Linux Engineer Zelmo's Avatar
    Join Date
    Jan 2006
    Location
    Riverton, UT, USA
    Posts
    1,001
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •