Excel Fill Handle for Dates

I want to fill dates across a row on Excel for every Friday of the week; e.g. 2/17/23, 2/24/23, etc.

Why does the fill handle for this series only work going down a column and not across a row? How can I get it to fill in this pattern across instead of down?

Answer
Answer

Perhaps you have formulas set to manual calculation? Does pressing f9 change the values?

Regards,
Rory

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

On the Formulas tab, you can change the calculation back to automatic in the 'Calculation options' dropdown on the right hand side.

Regards,
Rory

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 21, 2023 Views 28 Applies to: