Hi Ayush, Name: Damodaran Sub: Subtotal selection of items Details: when we do a sub-total function we normally need to use the mouse to select the line items that we need to find the sum or count.... instead we can Select "Data" & "Sub-total" & do this " ALT+D" & USE "SPACE BAR" to select the line items.
I hope this would make sub-totalling very easy. Regards, Damo On Mon, Jun 15, 2009 at 10:41 AM, Ayush <jainayus...@gmail.com> wrote: > > Dear Members, > > Thanks for your great response in the Week 24 competition. It was > great learning for the members of the group. I was delighted with the > response of members on this initiative. The winner of week # 24 will > be declared soon. Keep watching this Space...... > > Let us begin week # 25 quiz with the more spirit. > > Last Date of Submission of tips : 21st June 2009. > > PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE > CONSIDERED FOR PRIZES. > DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. > > You need to submit your name, Subject & the details of tips and > tricks. > DO let me know if you need any clarifications. > > Let me begin by submitting the first tip for this week competition. > > --------------------------------------------------------------------------------------------------------------------------------------------------- > Name : Ayush Jain > Subject : Format all the worksheets in a workbook > Detail : If you need to format all the worksheets in a workbook the > same way, you can hold down the Shift or Control button and select the > worksheets. Now that you have the worksheets selected, you can change > things like cell or page properties that will apply to all the > worksheets selected. After you're done, click on an inactive worksheet > (if you've selected all the worksheets) or click on an unselected > worksheet (if you did not select all the worksheets) to release the > hold. > > Who is next ???????????????????? > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
