fill handle
Hi all
I have a small problem. I have a list of numbers and normally would use the fill handle to carry on the list EG. Select the last two numbers and rest over the fill handled and click and drg down and it gives the next numbers in the list. However on a spreadsheet I have inherited it does not work and just repeats the smae numbers over again. I have also tried the EDIT fill series but that does not work. Any help appreciated cheers Rexmann |
Is your list filtered?
If yes, try showing all the data. Then do your autofill. rexmann wrote: Hi all I have a small problem. I have a list of numbers and normally would use the fill handle to carry on the list EG. Select the last two numbers and rest over the fill handled and click and drg down and it gives the next numbers in the list. However on a spreadsheet I have inherited it does not work and just repeats the smae numbers over again. I have also tried the EDIT fill series but that does not work. Any help appreciated cheers Rexmann -- Dave Peterson |
Hi Dave
That sorted it out, nice one (it was really bugging me!!) Cheers Dave "Dave Peterson" wrote: Is your list filtered? If yes, try showing all the data. Then do your autofill. rexmann wrote: Hi all I have a small problem. I have a list of numbers and normally would use the fill handle to carry on the list EG. Select the last two numbers and rest over the fill handled and click and drg down and it gives the next numbers in the list. However on a spreadsheet I have inherited it does not work and just repeats the smae numbers over again. I have also tried the EDIT fill series but that does not work. Any help appreciated cheers Rexmann -- Dave Peterson |
All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com