shortcut keys for comments

Is there a shortcut key to add a comment.  How about to 
edit a comment
0
anonymous (74722)
5/13/2004 12:07:37 PM
excel.misc 78881 articles. 5 followers. Follow

5 Replies
366 Views

Similar Articles

[PageSpeed] 31

Sherry, I don't think there is a short cut key for it, but you could use a
macro and assign it to a button or key. Have a look here for details

http://www.contextures.com/xlcomments03.html
-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Sherry" <anonymous@discussions.microsoft.com> wrote in message
news:c98d01c438e2$e1f942b0$a301280a@phx.gbl...
> Is there a shortcut key to add a comment.  How about to
> edit a comment


0
pbridgesnews (182)
5/13/2004 12:16:09 PM
Hi
one way:
record a macro and assign a shortcut to this macro
>-----Original Message-----
>Is there a shortcut key to add a comment.  How about to 
>edit a comment
>.
>
0
frank.kabel (11126)
5/13/2004 12:17:15 PM
Hi Sherry

Not that I know of other than select cell press the 'Alt' 
key then the 'I' key then the 'm' key.

HTH
Bob C.

>-----Original Message-----
>Is there a shortcut key to add a comment.  How about to 
>edit a comment
>.
>
0
anonymous (74722)
5/13/2004 12:24:52 PM
Right-o! And to edit a comment, SHIFT+F2.

-- 
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Robert Christie" <anonymous@discussions.microsoft.com> wrote in message
news:c9a701c438e5$4a8457f0$a301280a@phx.gbl...
> Hi Sherry
>
> Not that I know of other than select cell press the 'Alt'
> key then the 'I' key then the 'm' key.
>
> HTH
> Bob C.
>
> >-----Original Message-----
> >Is there a shortcut key to add a comment.  How about to
> >edit a comment
> >.
> >


0
DDMara (266)
5/13/2004 1:13:07 PM
Good catch  DDM,
This question has been posted several time recently and
I don't think anyone mentioned   Shift+F2

I'm  adding   "(Cell Comment)"  beside  "Cell Note"  in

Shortcut Keys in Excel 2000 (Excel Vers. 9)
 http://www.mvps.org/dmcritchie/excel/shortx2k.htm

and also updating
  Cell Comments
  http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"DDM" <DDMara@YaNOSPAMhoo.com> wrote in message news:uN2ZIwOOEHA.3300@TK2MSFTNGP09.phx.gbl...
> Right-o! And to edit a comment, SHIFT+F2.
>
> -- 
> DDM
> "DDM's Microsoft Office Tips and Tricks"
> Visit us at www.ddmcomputing.com
>
>
> "Robert Christie" <anonymous@discussions.microsoft.com> wrote in message
> news:c9a701c438e5$4a8457f0$a301280a@phx.gbl...
> > Hi Sherry
> >
> > Not that I know of other than select cell press the 'Alt'
> > key then the 'I' key then the 'm' key.
> >
> > HTH
> > Bob C.
> >
> > >-----Original Message-----
> > >Is there a shortcut key to add a comment.  How about to
> > >edit a comment
> > >.
> > >
>
>


0
dmcritchie (2586)
5/13/2004 11:24:30 PM
Reply:

Similar Artilces:

comments in fill-in form
I have a 9 page form which is protected. I know it is not possible in Word 2007 for the person completing the form to add formatting to the data inserted into the form (which would be very useful), but is there any way to add comments to a form? We have applications which sometimes get changed, and rather than having to complete a new application, we'd like them to be able to update the information on the form and indicate what has been changed using a comment. Any suggestions? You can provide a text form field for comments. -- Suzanne S. Barnhill Microsoft MVP (Word) ...

UseOutlook key
My Outlook addressbook has been shared to Outlook Express via a registry change. Please can you let me know how I can change my registry so that I can see my MSN Messenger contacts who are online and who are not online. (Or should I post this question in OE Newsgroup... please advise.) Thank you in advance for your help. Julia ...

Key segment not found, when printing Trial Balance
Have several users running GP (10.00.1368), with a shared report dictionary. When one user attempts to run the Trial Balance report, she gets the following errors: "Key segment not found" "Error registering GL_Acct_MSTR" and "Table Open Error". All other users seem to be able to print fine. This is a new install on this machine, and she seems to be able to do everything else fine. What should I look at to resolve this? Thank you Is this a modified report? If not, are you able to point this user to local reports dictionary and run the report. I woul...

Increasing PO Footer Comments
Hi, I was able to increase the line items comments on my PO using a great TK that I found on PS. I want to do the same with the PO level comments. I can't find anything on that and am not resourceful enough to figure it out on my own. Has anyone done this before? Thanks in advance! -- Jim Lines Sr. Microsoft Dynamics GP Applications Consultant Certified Microsoft Dynamics GP Specialist ...

SUdden change in Tab key behavior..
I have a 14 sheet workbook which is rather heavily reliant on VB. It's in Excel 2002 (XP). I recently added a batch of new code, and now the Tab key will only move to two cells on the "Setup" sheet. That sheet has 18 cells unlocked, with the rest of the worksheet locked and protected, so the user can just tab between the appropriate cells. I'm at a loss for a reason or direction to look. Tried options>transition, tried options>tab direction. Tried tearing hair...oops, no hair. TIA for the help. Greg Little glittle.at.sprynet.com Greg Have you checked your code hasn...

How to key in a formula
I have this formula, b = n (∑ty) – (∑t) (∑y)/ n (∑t2) - (∑t)2 and for each column I already assign with the function. I just don't know how to key in in one column in order the calculation will come out automatically. Please help me!. Thanks in advance. Let's assume the t-values are in A1:A100, and the y values in B1:B100 The formula you need is =COUNT(A1:A100)*(SUMPRODUCT(A1:A100,B1:B100)-SUM(A1:A100)*SUM(B1:B100))/(COUNT(A1:A100)*SUMSQ(A1:A100)-SUM(A1:A100)^2)) BUT!!!! I think you are computing the slope of a line so why not use =SLOPE(B1:B...

Cursor keys in multiline forms
I may be missing something but I need help with a simple question. In multiline forms cursor keys Up/Down move cursor to next/previous control so that I always put short code in Form_KeyDown to change this behavior to move cursor to next/previous record. I also need to set Form's KeyPreview to True. This is different from datasheets behavior. 1) Does it behave same way in US (EN) versions of Access? 2) Any workaround to change this behavior so that I don't need a code to move between records? TIA Vlado ...

Creating keyboard shortcut for Paste Value
Hi, is there a way to create a keyboard shortcut for the "Paste Value" command? I have tried using Customize Commands, but I can't figure out how to create the keyboard short cut. Why not just add the paste value to your toolbar. right click toolbar>customize>commands>edit>paste to values dragged to toolbar -- Don Guillett SalesAid Software donaldb@281.com "John Holland" <johnfromberkeley@yahoo.com> wrote in message news:8aa5b11f.0407160655.31e69e6@posting.google.com... > Hi, is there a way to create a keyboard shortcut for the "Paste Value...

desktop shortcuts
Anyone else ready to drop money because you are tired of deleting the shortcuts for ING and Bank One everytime you open money? How do you make it stop? Enough already! It's been posted in this group - try the following: Set Tools->Options->General->TurnOffSponsorshipsAndShoppingLinks -- Glyn Simpson, Microsoft MVP - Money http://money.mvps.org Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send Microsoft your wishes or suggestions, use http://register.microsoft.com/mswish/suggestion.asp or http://www.microsoft.com/u...

Comments not showing on peer computer
We have a peer to peer network of 4 computers. One of our computers does not show comments added on another computer on a shared file. Any suggestions? -- David P. Hi David, Tools>Options>View, check the right Comment options -- Kind regards, Niek Otten "David P." <DavidP@discussions.microsoft.com> wrote in message news:19152311-04EC-4BC0-92A0-8207965F9762@microsoft.com... > We have a peer to peer network of 4 computers. One of our computers does > not > show comments added on another computer on a shared file. Any suggestions? > -- > David P. ...

RM Keys
We have a customer that is trying to post an RM Batch. We removed all stuck sessions and ran a select statement on the sy00500 and found that the status was Table Updates Interrupted. The batch will not post and is returning an error message in Batch Recovery - Batch failed to complete posting. Get/Change Operation on table RM_Keys_Master could not find a record. Would Checklinks resolve this issue or will it be necessary to rebuild the RM Keys? If so, is there an automated solution for this? Can't seem to find anything in Knowledgebase. Thank you! Susan, Take a good backup...

Missing a number or letter for product key
Hello I have a publisher disc I purchased the program off the internet and downloaded the program but I need to add back to computer but I am missing a number or letter I have 24 instead of 25 for the key to be complete. What should I do? irish wrote: > Hello > I have a publisher disc I purchased the program off the internet and > downloaded the program but I need to add back to computer but I am > missing a number or letter I have 24 instead of 25 for the key to be > complete. What should I do? ==================================== Maybe the following article w...

eseutil /p Illegal duplicate key error
Hi all, I have an exchange 2003 server, and when I try to repaire my priv1.edb file I get Operation terminated with error -1605 (JET_errKeyDuplicate, Illegal duplicate ke y) after 64.16 seconds. I can not find any article about this please help me... "hasan" wrote: > Hi all, > I have an exchange 2003 server, and when I try to repaire my priv1.edb file > I get Operation terminated with error -1605 (JET_errKeyDuplicate, Illegal > duplicate ke > y) after 64.16 seconds. > > I can not find any article about this please help me... This error is unrecoverable...

Globally Trap Escape Key
I have a form with several controls. Rather than writing code for each keypress or a single procedure call by every controls keypress event, what is the best way to globally trap the escape key? David wrote: > I have a form with several controls. > > Rather than writing code for each keypress or a single > procedure call by every controls keypress event, > what is the best way to globally trap the escape key? Global's a little tricky. Have you fiddled with the form's KeyPreview property, though? -- ..NET: It's About Trust! http://vfred.m...

Comment Font #2
Where do you chage the font default for a comment box. Each time I insert a cooment box into excel, it defaults to a font size of 8 and I have to change it to read it. Where is the setting to change this to a different font size. I am using Windows XP and Office 2003. Thanks for the help. Visit Debra Dalgleish's site: http://contextures.com/xlcomments02.html#Default Craig wrote: > > Where do you chage the font default for a comment box. Each time I insert a > cooment box into excel, it defaults to a font size of 8 and I have to change > it to read it. Where is th...

One or more rows contain values violating non-null, unique, or foreign-key constraints
Populating a typed dataset from xml document: I created an xml schema (attached below), generated a typed dataset from it, and then programatically I tried to populate the typed dataset by calling its ReadXml method. I keep getting a constraint exception. I have validated that my xml matches the schema using xmlspy. I've included the schema, xml, code and exception information below. I can't figure out why I would get the exception if my xml validates against the schema, and the dataset was generated from the same schema. Exception--------------------------------------------...

Capturing key press combination
Hi all, here is the scenery: My dll is loaded into an application at runtime. Since this application does not support runtime-creation of accelerator-keys (e.g. CTRL+F, CTRL+SHIFT+K, ...), I want to create a function which catches all (or only the ones I want) key presses, looks if a certain key combination is pressed, invoke a function and abandon the message in this case. Other key events should remain unhandled (of course). My evaluation yielded a message hook to be the only possibility to implement this, but I couldn't find any good examples, especially concerning the filter technique...

Outlook won't accept my product key???
I have just bought Outlook . The opening page won't accept my product key. I have tried many variations and still it won't work??? Got it online from Amazon Hi polly, did you call amazon or Microsoft? Did you check this site? "How to contact a Microsoft Product Activation Center" http://support.microsoft.com/kb/950929/en-us -- Oliver Vukovics Share Outlook without Exchange (Vista Ready): Public ShareFolder Synchronize Outlook between PC and Notebook: Public SyncTool http://www.publicshareware.com "polly" <polly@discussions.microsoft.com> schrieb im...

Printing Comments as displayed on the page.
I am trying to print Comments as displayed on the page and they don't print. I am running Excel 2000, version 9.0.3821 SR-1. I am using an HP printer (LaserJet 2100). Anyone have any ideas?? File > Page Setup > Sheet tab and select "As displayed on sheet" in the Comments box. HTH Jason Atlanta, GA >-----Original Message----- >I am trying to print Comments as displayed on the page and >they don't print. I am running Excel 2000, version >9.0.3821 SR-1. I am using an HP printer (LaserJet 2100). >Anyone have any ideas?? >. > Make sure...

Tab key problem in Microsoft Office Excel 2003
I upgraded from Windows Vista to Windows 7 and now when I am using Excel and hit the tab key, the cursor always jumps to cell P rather than moving to the adjacient cell to the right. How do I correct this? Whether this is happening in new workbook also or in a specific file only? -------------------- (Ms-Exl-Learner) -------------------- "SFG" wrote: > I upgraded from Windows Vista to Windows 7 and now when I am using Excel and > hit the tab key, the cursor always jumps to cell P rather than moving to the > adjacient cell to the right. How do I corre...

Comments on data points
I am recording daily turnover data. Occasionally alongside this I also register some explanations for extraordinary events eg "new dealership opened today" The turnover data is then presented on a line chart using the "dynamic area" technique (thanks for your help with that!). Now I would like to show the verbal explanations in the graph too - I was thinking of possibly adding another data series as bar-chart (bar hight being constant at "max turnover + something" and then somehow get the explanations displayed in those bars as labels - but so far unsucce...

Embedding an annotation or a comment to a chart in Excel 2007
Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and a comment pops out (in a bubble or something). Thanks. P.S. Is it possible to do this in Office 2003? You cannot edit the text in these popups ("chart tips"). You can add a text box or data label to the chart, which is always visible, or you could write some code that makes a text box visible sometimes and hidden other times. Tushar Mehta has a utility that accomplishes this for you. Look for Chart hover Label on his ...

Key for pos in rms 2.0
Hi all, my name is Scilla. I from Italy I have download the version 2.0 of RMS and when i open POS ask me a key. Where i can find a key for 30 days evalution for use the POS? Thank you so much. Reply on email o by msn. msn: missdata@hotmail.com Scilla ...

Excel Encryption Key
I have been working on a password protected Excel file. I have been able to identify the Encryption key that was used by MS Excel. But now I need to know how to decrypt the file using the encryption key. This file is part of a criminal investigation. Any assistance would be appreciated. Commander Chris Wagoner Computer Crime Investigations Santa Fe Community College Police Department chris.wagoner@sfcc.edu Why reinvent the wheel? Do a Google group search and you will find lots of answers to that question in the Microsoft Excel newsgroups. You have not stated if the file has an Open pas...

comments printing
Is it possible to print sheet contents and comments without the comment cell addresses being printed? Thanks Tony Thanks Jim, will try. Tony "Jim Rech" <jrrech@hotmail.com> wrote in message news:eEkWKlFeDHA.3224@tk2msftngp13.phx.gbl... > >>Is it possible to print sheet contents and comments without the comment > cell addresses being printed? > > If you pick the Print at End option then you have no control over how Excel > prints. If you don't want to print comments "as they appear" you might want > to use a macro to list all your ...