To select blank cells in a range: Select the range, then hit Cntl + G > Alt + S (special) > k (blanks) > hit enter.
Srinivasan Ethirajalu. On Sat, Jun 6, 2009 at 1:13 PM, Manoj S Negi < manojsnegi.uttranc...@gmail.com> wrote: > Hi all, > > > Name : Manoj S Negi > Subject : Insert a new sheet in the excel workbook > Tip :Use *Shift+F11* to insert a new sheet > > in the excel workbook just hit Shift with F11 and you will see a new sheet > in the excel workbook. > > *Unfeigned Regards > Manoj S Negi > "Miles & miles to go before I sleep"* > *¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) > `·.¸(¨`·.·´¨)¸.·´ > `·.¸.·«*:·. > .·:* > *:·. > *«*:·. > .·:* > *:·. > > > * On Sat, Jun 6, 2009 at 9:06 AM, Satti Charvak <sat...@gmail.com> wrote: > >> Name : Satti Charvak >> Subject : the Great 'F2' >> Tip : The 'F2' is easily the most useful shortcut key in Excel, and in >> the Microsoft Windows Operatin System (All Versions) of course. >> >> Basically it it helps you rename many things:- >> >> 1. File/Folder names in Windows OS >> 2. Cell text in Excel cells >> 3. Nodes in explorer, database, msc files etc etc...i don't what all >> >> (no need to click/dbl click/right click etc) >> >> Just select, hit f2 and put the new name and enter ...it's done >> >> Thanks and regards, >> Satti Charvak >> ____________________ >> >> >> > > > > -- Srinivasan Ethirajalu, +91-9789090062 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---