Forum home » Delegate support and help forum » Microsoft Excel Training and help » Highlighting 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. |
Highlighting cells
Resolved · Low Priority · Version 2003
Reply Wed 9 Apr 2008, 16:29Delegate Nikki said...
Nikki has attended:
Excel Advanced course
Highlighting cells
How do you highlight visable cells only? i.e. on a subtotal page ?
For upcoming training course dates see: Pricing & availability
RE: Highlighting cells
Hi Nikki, Welcome to the forum, Thank you for your post, This is a great question and one which has had a lot of people stumped, but to sort your problem we have to use a little cheating;
Follow these steps;
1. View just the subtotals you wish to highlight (Click level 2 or similar)
2. Select just the cells you want to highlight
Here comes the cheat
3. Click Edit>Go To (Ctrl+G)
4. In the dialog box click the Special Button
5. In the Go To Special dialog box select Visible Cells Only
Click Ok - Now Format the cells as required; Click to View all of your Datasheet and you will see only the Selected cells have been formatted.
Do you like it? If so please click the Resolved link, best regards Pete Emmerson Microsoft Office Specialist Master Instructor
|