answersLogoWhite

0


Best Answer

That depends on what way you use it. You can use it for dates and have the date increase by a year each time, so each successive cell would have the same day and month, but increase the year by one. You can also get it to increase by more than one, using the Series facility, so each date jumps by several years. You can also get the date to increase by a smaller amount, like a day, which may not change the year at all. So the Fill can be very flexible allowing you to determine what way it deals with dates and the year in those dates, meaning there is no definitive answer to your question.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

If you type in the day of the week, and then drag the completed entry down, the other days of the week will follow and this will continue going through all 7 days repeatedly.

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

It will increase the days as the list goes one by the amount of days specified, which is normally 1.

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

It will increase the years as the list goes one by the amount of years specified, which is normally 1.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What will happen to the year in a spreadsheet if it has been inserted using the autofill feature?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What will happen to the day in the spreadsheet if it has been inserted using the auto fill feature?

If you type in the day of the week, and then drag the completed entry down, the other days of the week will follow and this will continue going through all 7 days repeatedly.


When did Operation Creature Feature happen?

Operation Creature Feature happened in 2007.


What would happen to the current modal of the atom if new information about its is discover in the feature?

what would happen to the current modal of the atom if new information about its is discover in the feature


What will happen to the electric field when a dielectric is placed?

The electric field is weakened when a dielectric is inserted.


What can happen in a motherboard when you have not inserted the ram completely?

If the Ram is not inserted properly the display does not occurs in Ur Computer and the Beep sound comes from Ur PC. Vipin Shet


When does errors come in spreadsheet?

Errors can happen for may reasons... One of the commonest is missing a bracket ( from a formula.


What would happen to the voltage impulse value and the magnet is inserted in and withdrawn from the coil?

the voltage will be decreased


What will happen when a inverted test tube is inserted into a measuring cylinder containing water?

the air would be trapped in the measuring cylinder. basically, nothing would happen


Why does a text box show when you try to click a cell in Excel spreadsheet?

Normally that does not happen. If you have an empty text box positioned over a cell, then it might happen when you try to click that cell.


What are some of Sir Isaac Newton's experiments?

he inserted a long needle into his eye and scraped it around to see what would happen!


Why does your computer not recognize your external iomega hard drive?

Probably the disk is bad. I had this happen and I inserted another disk and it recognized it.


What will happen if you are possibly pregnant and get the Mirena inserted?

It will usually abort the fetus. Take a pregnancy test from the store and/or your doctor to be sure. S