10/21 Nestle ♡ AMPS 90 PMPS 81 | Feline Diabetes Message Board - FDMB

10/21 Nestle ♡ AMPS 90 PMPS 81

Boys snuggling lately

1000124384.jpg

1000124524.jpg
 
Karolina & Nestle said:
Good afternoon
Could someone tell me how to create a new SS for 2026 with all the dates? I usually have to input all the dates manually and it takes a very long time 🙈🙊🙀
I'm not an excell wiz so any help would be appreciated.
Hope everyone is having a calm and peaceful Tuesday! 🐱🐱



10/20 Nestle ♡ AMPS 86 PMPS 79
Click to expand...
I ask Marje to help me with the spreadsheet each year. She’s a whiz and does it in a flash (I also suck with Excel) 💕
 
Karolina & Nestle said:
Good afternoon
Could someone tell me how to create a new SS for 2026 with all the dates? I usually have to input all the dates manually and it takes a very long time 🙈🙊🙀
I'm not an excell wiz so any help would be appreciated.
Hope everyone is having a calm and peaceful Tuesday! 🐱🐱



10/20 Nestle ♡ AMPS 86 PMPS 79
Click to expand...
Hi Karolina, I hope I'm answering the question you are asking correctly. All you need to do to enter your dates in the date column is go to the first cell under "date," and type 1/1/26 (+enter). Then, click back into that cell, put your cursor on the little blue dot at the bottom right of that cell and right click, hold, and drag down. The dates will populate for you automatically. I typically do mine for a few weeks at a time, but you can do the entire year at a time, if you prefer. Is this what you're asking??? Also, if you want to change the date format (I recently decided to add the actual day of the week along with the numeric day so it would read "Fri 10/31/25"), you just go to format + number, and at the bottom of that box, you'll see some standard options you can select, or you can select "custom" and come up with your preferred format. Remember, with Excel, if you do something you didn't mean to do, you just select the undo button

1761081930971.png
 
Mary & Jude said:
Hi Karolina, I hope I'm answering the question you are asking correctly. All you need to do to enter your dates in the date column is go to the first cell under "date," and type 1/1/26 (+enter). Then, click back into that cell, put your cursor on the little blue dot at the bottom right of that cell and right click, hold, and drag down. The dates will populate for you automatically. I typically do mine for a few weeks at a time, but you can do the entire year at a time, if you prefer. Is this what you're asking??? Also, if you want to change the date format (I recently decided to add the actual day of the week along with the numeric day so it would read "Fri 10/31/25"), you just go to format + number, and at the bottom of that box, you'll see some standard options you can select, or you can select "custom" and come up with your preferred format. Remember, with Excel, if you do something you didn't mean to do, you just select the undo button

View attachment 74532
Click to expand...
Thanks Mary. I'll try that and see what happens 🥰
 
You must log in or register to reply here.
Back
Top