View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I set F11 to insert worksheet Excel 2003?

Maybe you hit shift-F11 to get the new worksheet and you're memory is going
<vbg.

Chip Pearson has a list of shortcuts he
http://cpearson.com/excel/KeyboardShortcuts.htm

But I can never remember those keys (except for a couple--it's hell getting
old!).

So I've added a couple of icons to my favorite toolbar:
Tools|Customize|Toolbars tab|create a new toolbar if you like
then
On the Commands Tab|Insert category|drag the Worksheet icon to that favorite
toolbar.

I also dragged an icon from the Forms category--it was the Toggle Grid icon.
Then I can show/hide those gridlines really easily.



laineywolff wrote:

At other locations using Excel 2003 I was able to insert a new worksheet into
the workbook in which I was working by pressing F11. Where I work now, when
I press F11 it inserts a chart not a worksheet. Do you know how I can reset
the default so that F11 will insert a worksheet?

Thanks,

laineywolff


--

Dave Peterson