Excel

Resolved · Low Priority · Version Standard

Wed 12 Mar 2008, 17:58 Delegate Terry said...

Terry has attended:
Multiple applications course

Excel

How to create a text box with the keyboard on a chart

Thu 13 Mar 2008, 12:20 Trainer Pete said...

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

Thu 13 Mar 2008, 13:59 Delegate 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

Fri 14 Mar 2008, 08:03 Delegate 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Using the Windows Keyboard key

The Windows Key,(WK) typically found at the bottom left hand corner, can be found on most keyboards, and has a number of different uses:

To open the Start menu: WK
To minimise all windows WK+ D
To open all windows again WK+ shift + M
To open Windows Explorer WK + E
To move across the Task Bar WK + tab
To open the Search window WK + F
To open the Run dialogue box WK + R
To open the System Properties dialogue box WK + break

You may be able to perform other actions with the windows key depending on which programs you have installed on your PC.

View all Microsoft Office hints and tips