Weekly Computer Tip # 285
3 October 2009

take a shortcut (Excel 2003-2007)

Following last week's call for your favourite shortcuts I'm sharing one of Jonathan Grant. (Thanks, Jonathan!) Jonathan (an IT trainer himself, or as his title reads: IT & Best Practice Trainer) came across a shortcut for inserting a new worksheet, which his class loved. (And I'm starting to like it too!)

Here's how:

1. Press Shift+F11

A new sheet, called something like "Sheet4", will be placed before the one you had active when you pressed Shift+F11. Simply double-click its sheet tab at the bottom of the screen to rename it and/or drag and drop it to a more appropriate spot.

By the way, does anybody remember what F11 does? (without the shift key) See http://www.roem.co.uk/tip_18.html

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   Virtual Press Room   Disclaimer