Name : Aindril De (Andy) Subject : Format Painter for different ranges in different places in the worksheet Detail : Continuing from Ayush's tip before. The "format painter" can be used to change the format of different cells in different parts of the worksheet. Highlight a cell with the formating that you want, "Double Click" the button and click on the different cells that you want with the same format as the source cell. These can be different cells in different parts of the worksheet. Click on the Format Painter button again to switch off the option.
On Sun, Jun 21, 2009 at 10:19 PM, Ayush <jainayus...@gmail.com> wrote: > > Dear Members, > > Thanks for your great response in the Week 25 competition. It was > again great learning for the members of the group. > Let us begin week # 26 quiz with the more spirit. This is last chance > for you to be eligible for June month competition.The winner of week # > 25 will be declared soon. Keep watching this Space...... > > Last Date of Submission of tips : 28th 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 Painter > Detail : The little "format painter" is the most useful button in > Excel. It looks like a paintbrush and is grouped with the > cut,copy,paste buttons. Basically highlight a cell with the formating > that you want, click the button, and then highlight cell(s) that you > want to just paste the format. HUGE time saver! > > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
