close

I use x^2 (power). I want to put the icon for this command in my tool ar. I
checked view/tools/format/format cell but could not find the icon for this
command. Where can find this icon and bring to tool bar?
Your comment is highly appreciated.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan

Have you tried quot;ALT 0178quot; ?

quot;Khoshravanquot; wrote:

gt; I use x^2 (power). I want to put the icon for this command in my tool ar. I
gt; checked view/tools/format/format cell but could not find the icon for this
gt; command. Where can find this icon and bring to tool bar?
gt; Your comment is highly appreciated.
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer
gt; Osaka, Japan

It doesn't work in my computer. Even if it worked, it is not a wiseway. I
want to bring the shortcut icon to toolrbar so that only by one click I can
do this. Alt 0178 needs 4 charcter input and is long
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japanquot;Waynequot; wrote:

gt; Have you tried quot;ALT 0178quot; ?
gt;
gt; quot;Khoshravanquot; wrote:
gt;
gt; gt; I use x^2 (power). I want to put the icon for this command in my tool ar. I
gt; gt; checked view/tools/format/format cell but could not find the icon for this
gt; gt; command. Where can find this icon and bring to tool bar?
gt; gt; Your comment is highly appreciated.
gt; gt; --
gt; gt; Rasoul Khoshravan Azar
gt; gt; Civil Engineer
gt; gt; Osaka, Japan

Create a macro as follows in an Excel file in quot;XLStartquot; folder

=========================
Sub InsertSquare()
Application.SendKeys (quot;²quot;)
End Sub
=========================

Assign the above macro to a Button using quot;View-gt;Tool Bars-gt; Customizequot;
Assign a keyboard short (whatever you wish) to it using quot;Rearrange commandsquot;.

Regards
NAVEENquot;Khoshravanquot; wrote:

gt; It doesn't work in my computer. Even if it worked, it is not a wiseway. I
gt; want to bring the shortcut icon to toolrbar so that only by one click I can
gt; do this. Alt 0178 needs 4 charcter input and is long
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer
gt; Osaka, Japan
gt;
gt;
gt; quot;Waynequot; wrote:
gt;
gt; gt; Have you tried quot;ALT 0178quot; ?
gt; gt;
gt; gt; quot;Khoshravanquot; wrote:
gt; gt;
gt; gt; gt; I use x^2 (power). I want to put the icon for this command in my tool ar. I
gt; gt; gt; checked view/tools/format/format cell but could not find the icon for this
gt; gt; gt; command. Where can find this icon and bring to tool bar?
gt; gt; gt; Your comment is highly appreciated.
gt; gt; gt; --
gt; gt; gt; Rasoul Khoshravan Azar
gt; gt; gt; Civil Engineer
gt; gt; gt; Osaka, Japan

Dear Naveen
Thanks for your reply.
I think Microsoft has already wrote this Macro and it is somewhere inside
the View command my problem is that I just can't find it. I am not familiar
with Macro and it is hard for to write it. I prefer to find where is that
icon. In my previous computers I had it and with this new computer in new
work palce I cant find it.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japanquot;NAVEENquot; wrote:

gt; Create a macro as follows in an Excel file in quot;XLStartquot; folder
gt;
gt; =========================
gt; Sub InsertSquare()
gt; Application.SendKeys (quot;²quot;)
gt; End Sub
gt; =========================
gt;
gt; Assign the above macro to a Button using quot;View-gt;Tool Bars-gt; Customizequot;
gt; Assign a keyboard short (whatever you wish) to it using quot;Rearrange commandsquot;.
gt;
gt;
gt;
gt;
gt; Regards
gt; NAVEEN
gt;
gt;
gt; quot;Khoshravanquot; wrote:
gt;
gt; gt; It doesn't work in my computer. Even if it worked, it is not a wiseway. I
gt; gt; want to bring the shortcut icon to toolrbar so that only by one click I can
gt; gt; do this. Alt 0178 needs 4 charcter input and is long
gt; gt; --
gt; gt; Rasoul Khoshravan Azar
gt; gt; Civil Engineer
gt; gt; Osaka, Japan
gt; gt;
gt; gt;
gt; gt; quot;Waynequot; wrote:
gt; gt;
gt; gt; gt; Have you tried quot;ALT 0178quot; ?
gt; gt; gt;
gt; gt; gt; quot;Khoshravanquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I use x^2 (power). I want to put the icon for this command in my tool ar. I
gt; gt; gt; gt; checked view/tools/format/format cell but could not find the icon for this
gt; gt; gt; gt; command. Where can find this icon and bring to tool bar?
gt; gt; gt; gt; Your comment is highly appreciated.
gt; gt; gt; gt; --
gt; gt; gt; gt; Rasoul Khoshravan Azar
gt; gt; gt; gt; Civil Engineer
gt; gt; gt; gt; Osaka, Japan


What's wrong with Shift 6?--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=515589Shift 6 doesn't work. Even Shift F6 doesn'twork.
I just found out that I have used this icon in Word, not in Excel. In word
if you go to View/toolbars/user setting/command/ and choose format then you
will see two icons one power and the other for index. I wonder why these
icons are not available in Excel?
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japanquot;Khoshravanquot; wrote:

gt; I use x^2 (power). I want to put the icon for this command in my tool ar. I
gt; checked view/tools/format/format cell but could not find the icon for this
gt; command. Where can find this icon and bring to tool bar?
gt; Your comment is highly appreciated.
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer
gt; Osaka, Japan

Not sure I understand, but the quot;^quot; (Exponentiation Sign) can be added to
the toolbar by customizing the toolbar....
Select quot;Commandsquot; Tab
Select the quot;Insertquot; Categories
quot;^quot; is about half way down the list (Excel 2003)

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Khoshravanquot; gt; wrote in message
...
gt; Shift 6 doesn't work. Even Shift F6 doesn'twork.
gt; I just found out that I have used this icon in Word, not in Excel. In word
gt; if you go to View/toolbars/user setting/command/ and choose format then
gt; you
gt; will see two icons one power and the other for index. I wonder why these
gt; icons are not available in Excel?
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer
gt; Osaka, Japan
gt;
gt;
gt; quot;Khoshravanquot; wrote:
gt;
gt;gt; I use x^2 (power). I want to put the icon for this command in my tool ar.
gt;gt; I
gt;gt; checked view/tools/format/format cell but could not find the icon for
gt;gt; this
gt;gt; command. Where can find this icon and bring to tool bar?
gt;gt; Your comment is highly appreciated.
gt;gt; --
gt;gt; Rasoul Khoshravan Azar
gt;gt; Civil Engineer
gt;gt; Osaka, Japan

You can either go to Insert-gt;Symbol and select the ^, but you would
have
to do this everytime you wanted the symbol.

To put a button in your toolbar go to View-gt;Toolbars-gt;Customize. Under
categories select quot;Insertquot;. Under commands scroll down until you see
the ^.
Select it and drag it to somewhere on your toolbar and it will insert a
button.

What do you mean Shift 6 didn't work? Did it put in nothing or just
another symbol? Make sure you are using the numbers above the keyboard
for this.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=515589Thanks for comments. I think I fall short in expressing what do I want to do.
I want to write 25 (2 to power of 5). 5 should be placed in power position,
which means should be super indexed (I am not sure about this expression, but
I mean 5 should be in a higher position). I know that I can go to
tools/cell/format cell and do this, but it is time consuming esp if I want to
do it for many times. In word, there is an icon which shows x2 (where 2 is
placed in a higher position. means that x to power of 2) and by selecting 2
and clicking the icon it do everything. I don't know why excel doesn't
provide this icon? How can make it myself?
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japanquot;mphell0quot; wrote:

gt;
gt; You can either go to Insert-gt;Symbol and select the ^, but you would
gt; have
gt; to do this everytime you wanted the symbol.
gt;
gt; To put a button in your toolbar go to View-gt;Toolbars-gt;Customize. Under
gt; categories select quot;Insertquot;. Under commands scroll down until you see
gt; the ^.
gt; Select it and drag it to somewhere on your toolbar and it will insert a
gt; button.
gt;
gt; What do you mean Shift 6 didn't work? Did it put in nothing or just
gt; another symbol? Make sure you are using the numbers above the keyboard
gt; for this.
gt;
gt;
gt; --
gt; mphell0
gt; ------------------------------------------------------------------------
gt; mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
gt; View this thread: www.excelforum.com/showthread...hreadid=515589
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()