UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> [DumbQ - XL] Is there any way to enter your fullname in an XL wi    
 
   
Prateek
post Jul 12 2005, 04:02 AM
Post #1

New Member
Posts: 1
From: India
One feature of XL that I fondly put to use is Ctrl+; (combination of control key and semicolon), and Ctrl+: (combination with colon), which inserts current date and current time respectively into an active cell. Very neat.

Now, i need a feature for inserting my name (name you register in your PC) with a single key stroke, rather than to have to type it out every time (not that i don't like my name). Would be useful in XL file where you have a column for entering your name.

Any idea?
Go to the top of the page
 
+
Luceze
post Jul 12 2005, 08:31 AM
Post #2

UtterAccess VIP
Posts: 2,601
From: Dallas, Texas USA
Hello,

You can write a simple Sub in a module in your Personal.xls and assign a shortcut key to it.
CODE
Sub EnterName()
ActiveCell = "Eric Isom"
End Sub



HTH,
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 09:03 AM