Name: Aindril De Subject: Useful Shortcut keys Using Ctrl and Shift Tips: Ctrl+Shift+4 (i.e. Ctrl+$): Formats your current selection as currency Ctrl+Shift+5 (i.e. Ctrl+%): Formats your current selection as a percentage Ctrl+Shift+6 (i.e. Ctrl+^): Formats your current selection as scientific notation Ctrl+Shift+8 (i.e. Ctrl+*): To highlight the active range Ctrl+9 : Hide Row Ctrl+Shift+9 (i.e. Ctrl+(): Unhide Row Ctrl+0 : Hide Column Ctrl+Shift+0 (i.e. Ctrl+)): Unhide Column Ctrl+PgUp and Ctrl+PgDn: To navigate through worksheets within a workbook Ctrl+Space: Select Column Shift+Space: Select Row Ctrl+1: Brings up Format Cell Dialog Box Ctrl+2: Toggles Cell format to *Bold* Ctrl+3: Toggles Cell format to *Italic* Ctrl+4: Toggles Cell format to *Underline* Ctrl+5: Toggles Cell format to strikethrough
Regards, Andy 2009/6/11 Aindril De <aind...@gmail.com> > Name: Aindril De > Subject: Shortcut keys for selecting cells, rows, and columns in Excel 2003 > Tips: > > 1. Extend the selection in the direction of the arrow key > [Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑] > > 2. Select the current column > [Ctrl]+[Spacebar] > > 3. Select the current row > [Shift]+[Spacebar] > > 4. Select all cells on the current worksheet > [Ctrl]+[A] > > 5. Reduce the selection to the active cell > [Shift]+[Backspace] > > 6. Select all the objects on the current worksheet while retaining the > current selection > [Ctrl]+[Shift]+[Spacebar] > > 7. Toggle Extend mode on and off > [F8] > > 8. Toggle Add mode on and off > [Shift]+[F8] > > 9. Extend the selection to the first or last cell in the data area > [Ctrl]+[Shift]+[→], [Ctrl]+[Shift]+[←], [Ctrl]+[Shift]+[↓], > [Ctrl]+[Shift]+[↑] > > 10. Extend the selection to the first cell in the row > [Shift]+[Home] > > 11. Extend the selection to the first cell in the worksheet > [Ctrl]+[Shift]+[Home] > > 12. Extend the selection to the last cell used on the worksheet > [Ctrl]+[Shift]+[End] > > 13. Extend the selection to the last cell with contents in the active > column or row > [End], then [Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑] > > 14. Extend the selection to the last cell with contents on the worksheet > [End], then [Shift]+[Home] > > 15. Extend the selection to the last cell in the active row > [End], then [Shift]+[Enter] > > 16. Extend the selection downward by one screen > [Shift]+[PageDown] > > 17. Extend the selection upward by one screen > [Shift]+[PageUp] > > 18. Extend the selection to the first cell in the window > [ScrollLock], then [Shift]+[Home] > > 19. Extend the selection to the last cell in the window > [ScrollLock], then [Shift]+[End] > > Regards, > > Andy > > > > On Wed, Jun 10, 2009 at 11:39 PM, harsh shah < > harshsha...@gmail.com> wrote: > >> name: harsh shah >> subject : formula reference >> tip : press ctrl + [ (will show from where the formula has been derived) >> & ctrl + ] (will show where this cell has been used in formula) >> >> >> On 10/06/2009, Rakesh Sharma <rak_sha...@yahoo.co.in> wrote: >>> >>> >>> HI All, >>> >>> >>> Name : Rakesh Shar,ma >>> Subject : Show formulas in printable format >>> Tip : Press Ctrl + ~ ( To View formulas in printable format or >>> to take a printout for forumlas enter in cells) >>> >>> >>> >>> >>> >>> >>> On Jun 5, 8:41 pm, Ayush <jainayus...@gmail.com> wrote: >>> > Hello Everyone, >>> > >>> > Please submit your tip in this post for Week # 24. I am looking for >>> > your overwhelming response in this competition.You just need to submit >>> > your name along with the tip and subject. The tip can be shortcut, >>> > trick, hidden secret, etc. >>> > >>> > Last Submission Date -----13th June 2009. >>> > Winner Declaration Date -----14th June 2009. >>> > >>> > Example : >>> > >>> > Name : Ayush Jain >>> > Subject : the Great 'F4' >>> > Tip : The 'F4' is easily the most useful shortcut key in Excel. >>> > Basically it repeats your last command. >>> > So say you changed the color of a font in a cell. Now click in a new >>> > cell and hit 'F4' and it will change the font in the new cell to the >>> > same color.Wonderful, right? Well what's great about this is that it >>> > works for nearly everything else in Excel too.Highlight a row, right- >>> > click and choose 'Delete'. Now highlight another row and hit 'F4'. It >>> > deletes that row.Whatever you did last, Excel will attempt to repeat >>> > the same command until you do something else. This works great for >>> > things that require you to go to the menus or right-click and make >>> > choices or click buttons that bring up more dialogs. It can be huge >>> > time saver once you get used to using it. As the help says, it doesn't >>> > work in every situation but most times 'F4' works great. >>> > >>> > SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP & WIN PRIZES. Invite >>> > your friends too for participation in the contest. The more >>> > participation means more learning. >>> > >>> > Thanks again, >>> > Ayush Jain >>> >>> >>> > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
