with Excel 2007 the Help options seem to be much better. Along with this a pretty extensive list of shortcut keys
http://office.microsoft.com/client/helppreview.aspx?AssetID=HP100738481033&QueryID=2M8Hx7LZd&respos=5&rt=2&ns=EXCEL&lcid=1033&pid=CH100947761033 some of my favorites: CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar. CTRL+ENTER fills the selected cell range with the current entry and keeps that cell selected. CTRL+; Enters the current date. On Mar 18, 7:48 am, Ayush <jainayus...@gmail.com> wrote: > Thanks group for your overwhelmed response on this topic. > > @Shyam : Thanks for sharing tips and bugs. you are excellent member of > group. I am proud that you are part of this group. Keep Posting. > > @Sudhir : Thanks for idea but it appears tedious to edit the file and > upload in the group. There will be two many copies. Very difficult to > consolidate all tips into one. > If you want consolidated output then we I can upload > these tips on our group blog @ exceldailytip.blogspot.com . Here you > will already find more than 50 tips published. > > @draco664 : Thanks for sharing Best Practice. I loved it. > > Best regards, > Ayush Jain > Group Owner. > > On Mar 18, 7:28 pm, draco664 <draco...@hotmail.com> wrote: > > > > > Personally, whenever I start a new job, or install a new version of > > Excel, the first thing I do is record the following macro. > > > Sub CopyPasteSpecialValues() > > ' > > ' CopyPasteSpecialValues Macro > > ' Macro recorded 27/11/2008 > > ' Keyboard Shortcut: Ctrl+Shift+V > > ' > > Selection.Copy > > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > > SkipBlanks _ > > :=False, Transpose:=False > > Application.CutCopyMode = False > > End Sub > > > Most of my job involves data manipulation/extraction. To do this, I > > often write temporary functions which take existing raw data and turn > > it into more easily-readable formats. > > > Since I share this data with sub-contractors and clients, I'm not > > permitted to release what is in effect, my employer's intellectual > > property. The macro allows me to highlight a range of cells, and with > > one keystroke, replace the existing functions with the values. > > > On 18 Mar, 04:26, Ayush <jainayus...@gmail.com> wrote: > > > > Hello Everyone, > > > > I request you all to share any tips or tricks that you have about MS > > > Excel in the group. It really helps. > > > > The tip can be anything like formula, most used calculation, excel > > > trick, hidden truth or could be anything which you think can be done > > > in an easier way. > > > > It can be any bug of excel also. Anything about excel that you > > > know....anything > > > > Sharing just increases the knowledge. > > > > Keep Posting... > > > > Best regards, > > > Ayush Jain > > > Group Owner- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
