Forum home » Delegate support and help forum » Microsoft Excel Training and help » Visible cells
|
|
|
The UK's most regular 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. |
Visible cells
Resolved · Medium Priority · Version 2011 (Mac)
Reply Tue 25 Oct 2011, 15:57Delegate Karen said...
Karen has attended:
Excel Intermediate course
Visible cells
Do you have an icon/function that you can copy to use to copy just visible cells and exclude those grouped or hidden? Excel 2010 has this function?
For upcoming training course dates see: Pricing & availability
RE: Visible cells
Hi Karen
Thanks for your question - there is a paste values function in Excel 2010 and a button that can be added to the Quick Access Toolbar. In 2011 we would have to either paste special - Value or use some vba. I have some code that might help and we can look at that later today.
Kind regards,
Andrew
|