Select various chart elements with TAB key (arrow keys in older version) Do it one, now select the other axes and press F4. Say you want to change axis color of all charts to dull gray. When you are working with lots of charts, often we repeat various formatting / customization steps on all of them. But do you know that you can use them with charts too? Yes, if you want to add extra series to your chart, simply copy the data, highlight the chart and press CTRL+V to add it. Who could forget the trusty copy and paste shortcuts. Now select the second chart and press ALT E S T (your press ALT E, leave both keys and press S followed by T in a sequence) and voila your formatting is replicated.Īdd new data to a chart with CTRL+C, CTRL+V If you want to copy the formatting of one chart to another, simply select first chart and press CTRL+C. Copy formatting from one chart to another with ALT+E S T In newer versions of Excel, you will see the format pane to the right. In older versions of Excel, this would launch format dialog.
Select any part of a chart and press CTRL+1 to format it. It is easy to remember and it is versatile. If there is a contest for most memorable and super helpful shortcuts, then CTRL+1 would win it. Ready for top 5 keyboard shortcuts for Excel charts? Read on. But do you know that you can use few simple shortcuts to do most day-to-day chart related things? But when it comes to charting, we automatically reach for mouse.
Most pro users rely on a handful shortcuts when working with large spreadsheets. We all know that learning a few keyboard shortcuts can speed-up your Excel game.
0 kommentar(er)
