FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 2, 2016 Quote of the Day

“In the depth of winter I finally learned that
there was in me an invincible summer."
-- Albert Camus --

Hi fellow Excel Addict,

Francis Hayes ( 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.

Mynda's FREE Excel Dashboards Webinar

Excel in Seconds with

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)

Move A Chart Using Arrow Keys_in_Microsoft_Excel_2007_2010_2013_2016_365

Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

 'Spreadsheets Tips From An 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