98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Excel - running Vista - fill handle not working to copy formulae
microsoft+excel+training - Excel - running Vista - fill handle not working to copy formulae
Resolved · Low Priority · Version Standard
Pat has attended:
No courses
Excel - running Vista - fill handle not working to copy formulae
My daughter and I both have same problem on new Vista laptops - both Excel 2003 and 2007.
When using the fill handle to copy formulae into adjacent cells, instead of copying the formulae (i.e. the totals at bottom of columns for instance) it copies the actual figures, not the formulae. This worked fine on my 2003 version on XP desktop but not on Vista laptop.
HP are stumped too at present and Microsoft is sooo..expensive to contact.
Can anyone help please?
thank you
RE: Excel - running Vista - fill handle not working to copy form
Hi Pat
Thanks for the question, I have checked with my colleagues and they too are unclear why Exel is acting this way.
Have you tried to use the fill handle with the right mouse click? This should then give you some options on what you are copying.
Regards
Jacob
RE: Excel - running Vista - fill handle not working to copy form
My local pc shop looked at this with 'remote access' and it worked at first. He said it was to do with the laser mouse and to uninstall the Logitech software. It worked at first but now it doesn't.
Ref your suggestion - just tried it but I am not sure which option to select - though I think I tried the likely ones and this does not work either. I am still getting the total for column one in the other columns which is incorrect!
Thank you for your suggestion but the case is still open!
Pat
RE: Excel - running Vista - fill handle not working to copy form
When you do a standard copy and paste on these cells, do you get the result you want?
RE: Excel - running Vista - fill handle not working to copy form
HP suggested I uninstall Office 2003 and reinstall. At first the problem was still not resolved, but I think I may have triggered some patches or updates and it is all now working fine.
My daughter has not tried hers yet though on her Compax/Vista/Excel 2007 laptop.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |