Copying fill of month series but don't change formatting

[ammartino44]

Hello. If I use the fill handle to fill a series of Jan, Feb (copy the full year series) how can I fill that without impacting the formatting and just fill the series values?

[NeedForExcel]

Hi, Instead of holding down the left mouse button and dragging down, hold down the right mouse button and drag down, after releasing the button select 'Fill Without Formatting'..

Hope this helps!

Cheers