February 2, 2016
Hi fellow Excel Addict,
Thanks for joining me today for another quick time-saving tip that I hope you can use. If you missed Thursday's tip that showed how you can 'Display Negative Numbers with Red Font and Parentheses', you can read it here.
I've had a few subscribers tell me that they cannot use their arrow keys to reposition their charts. I think you could do that back in earlier versions of Excel. So, today I have a simple solution if you experience the same problem.
I hope you find it useful.
Please feel free to share this with anyone else you think it may help.
Take care and keep Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
How to Move a Chart Using the Arrow Keys
Usually when you select an object (i.e. shapes, pictures, etc...) in Excel, you can use the arrow keys to move it around on the worksheet. However, when you select a chart and press the arrow keys, it just selects the different parts within the chart. So it seems that your only option is to use your mouse to move the chart around.
But wait! There is a little-known trick that allows you to move your chart using the arrow keys.
The trick is to 'hold down the CTRL key' while selecting your chart. You will see a small circle on each corner of the chart.
NOW you can use your arrow keys to move the chart around. (Try it here)
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630