Monday, December 3, 2012

Trick of the day: New Sheet in Excel

Click here for an updated version of this post

If you want to create a new sheet in an Excel Workbook, you can use the mouse an click next to the rightmost existing sheet. But why not use a shortcut instead?

Alt + Shift + F1















Saturday, December 1, 2012

Trick of the day: Chart Shortcut


If you want to create a chart in Excel, you can always select the data table, go to the Insert menu and choose a chart. But why not use a shortcut instead?

Select the data table and use this shortcut: 

Alt + F1

You will get a chart on the same sheet in a second!