Forum home » Delegate support and help forum » Microsoft Office general help » Excel
|
|
|
The UK's most regular Training information: |
|
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
Resolved · Low Priority · Version Standard
Reply Wed 12 Mar 2008, 17:58Delegate Terry said...
Terry has attended:
Multiple applications course
Excel
How to create a text box with the keyboard on a chart
For upcoming training course dates see: Pricing & availability
RE: Excel
Hi Terry, Thank you for the post, If like me you are a keyboard shortcut user you will like this one:
Press F10 (Function 10) then CTRL+Tab to select the Drawing Toolbar, then use the Right Arrow to select the Text box button, Press CTRL+ENTER. Type the Text you want in the text box. To return to the worksheet when you have finished typing, press ESC twice. To format the Text box, while it is selected, press ESC, then press CTRL+1 to display the Format Text box dialog box. When you finish formatting, press ENTER, and then press ESC to return to the worksheet. hope that helps, best regards Pete
Reply Thu 13 Mar 2008, 13:59Delegate Terry said...
RE: Excel
Thanks Pete it certainly has helped. The problem is that sometimes you get the Drawing Tab sometimes the Chart tools and sometimes nothing will continue to play to get it right.
Thanks again.
Terry Bensted
Reply Fri 14 Mar 2008, 08:03Delegate Terry said...
RE: Excel
Pete,
Your advice has improved the position of how to use the keyboard with text boxes on charts but I still have three problems.
1. How do you delete a text box maybe obvious but not to me.
2. With a chart on separate page, chart1 and you have come out of the chart you loose the Chart Tools. You can get it back with the mouse but how do you do this with the keyboard.
3. Sometime I get the Drawing Tool, sometimes the chart tool and sometimes as in 2 nothing is there atechnique to ensure I get the chart tool.
Terry Bensted
|