Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying 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. |
Copying visible cells
Resolved · Low Priority · Version 2003
Reply Thu 9 Sep 2010, 16:39Delegate Steven said...
Steven has attended:
Excel Intermediate course
Excel Advanced course
Copying visible cells
How do you copy visible cells only?
For upcoming training course dates see: Pricing & availability
RE: copying visible cells
Steven apologies for the delay I'm assuming that you want to copy only data displayed on the worksheet
1. Highlight the data displayed in the worksheet
2. Press the F5 key to display the GoTo dialog box.
3. Click the special button in the GoTo Box
4. The Go to Special dialog box should be displayed, select the option Visible cells only and click OK
5 From the Home ribbon select the Copy command OR hold down the Ctrl key and press the letter C to copy the visible cells.
6. Go to a blank cell or worksheet and either Right click and select paste from the shortcut menu OR hold down the Ctrl key and press the letter V to paste. This should paste the visible cells only.
Any problems please do not hesitate to contact me
Thanks
Newson
Fri 17 Sep 2010: Automatically marked as resolved.
|