Spreadsheet Tips

Shortcut: Quickly Create Charts

August 06, 2019
A user selects their spreadsheet data and presses Alt+F1 to automatically create a bar chart based on the data.

If you have data, Excel can automatically create a chart to go with it. All you need to do is select the your data and hit Alt+F1 (Option+F1 on Mac).

It's a great way to get a quick visual and you can always customize the chart from there.