Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sue
 
Posts: n/a
Default can you customize a keyboard short cut in excel?

can someone tell be if this is possible? I use the copyright symbol often
and would like to have a shortcut for it.
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Sue wrote:
can someone tell be if this is possible? I use the copyright symbol often
and would like to have a shortcut for it.


You could create a macro so that Ctrl-a, for example, would insert a
symbol into the cell. Or clicking a button would put the symbol into
the cell.

I don't know that you can customize a key directly as you really want
though. Perhaps someone wiser will speak up....

Bill
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you type (c), then Office's AutoCorrect will change it to a "©".

If you don't like typing those three characters, maybe you could choose a
combination of seldom used characters that you could use instead (@@ or !!).

tools|autocorrect options|autocorrection tab

This is shared between the programs in Office (Word, excel, powerpoint...)

Sue wrote:

can someone tell be if this is possible? I use the copyright symbol often
and would like to have a shortcut for it.


--

Dave Peterson
  #4   Report Post  
Sue
 
Posts: n/a
Default

Perfect! Thank you.

"Dave Peterson" wrote:

If you type (c), then Office's AutoCorrect will change it to a "©".

If you don't like typing those three characters, maybe you could choose a
combination of seldom used characters that you could use instead (@@ or !!).

tools|autocorrect options|autocorrection tab

This is shared between the programs in Office (Word, excel, powerpoint...)

Sue wrote:

can someone tell be if this is possible? I use the copyright symbol often
and would like to have a shortcut for it.


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM
Is there a keyboard shortcut for centering data in Excel? Antartica Excel Discussion (Misc queries) 2 November 30th 04 05:30 PM
In Excel, what is the keyboard shortcut to toggle between displayi Jaison Excel Worksheet Functions 1 November 24th 04 08:25 PM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"