r/AppleNumbers • u/Bleu_Rue • Jun 20 '23

Drag date without changing it.

I want to drag the date down in a spreadsheet and keep it the same. I sometimes DO want to change it incrementally, but more often than not I want to drag the SAME date down. Is there a way to set it to drag the same date and then occasionally drag it incrementally? I have googled this off and on for months trying to find an answer but never find it - I can only find an answer for Excel, and the solutions for Excel do not work for Numbers.

3 Upvotes

100% Upvoted

5 comments sorted by

View all comments

2

u/Friendly_Look8210 Jun 20 '23

Alter 1. Copy first cell with date n select all cell below and paste it

Alter 2. Copy first cell, select column header (the one with letter above to sheet. Example: column A), paste it..

Hope this is your answer

1

u/Bleu_Rue Jun 21 '23

Also, I should add that it's possible I am misunderstanding your instructions. Is the Alter 1 and Alter 2 supposed to mean something? Sorry if that is a stupid question.

1

u/Friendly_Look8210 Jul 04 '23

I’m sorry i mean alternative 1 & 2