3 New Tips In The August 2016 Edition Of The How To Excel At Excel Newsletter

View this email online if it doesn't display correctly
Don't Forget To add barbara@howtoexcelatexcel.com to your safe or contacts list to ensure you always receive your 3 FREE Excel Tips. August 3 2016 Hello How Welcome to the August 2016 edition of the How To Excel At Excel Newsletter.  I hope you enjoy these next 3 tips. You can download the examples used in this newsletter here and follow along with the tips. Below are other places you can find and follow me for more Excel Tips on Social Media or download the FREE How To Excel At Excel App (IOS only) from the App Store for updates directly to your iPad or iPhone. Your 3 Excel Tips Are- 1. Manually Sort An Excel Pivot Table 2. Copy A Worksheet From One Workbook To Another 3. Print Two Or More Excel Worksheets Together My Recent Blog Posts You Might Like- Formula Friday – Use The INDEX and MATCH Functions In Excel To Calculate Distances Between US National Parks Create A Micro Chart In Excel From A Normal Chart Formula Friday – Searching Made Easy With SEARCH Function in Excel 1. Manually Sort An Excel Pivot Table. As well as using the usual sort options in a Pivot Table, buy value and label, you can also decide yourself the sort order, by using the Manual Sorting option.  I find this useful if maybe the labelling you have used is more bespoke than the usual chronological order of dates for example you may have some periods that are labelled like my data set below running every 4 weeks. If I try to use the built in options, Excel will sort it incorrectly for me as it will sort on the first numbers in the data labels.  That's ok though because we can take control of the situation.  So once I have created my Pivot Table I can sort manually by rows or columns. To sort manually- Select the cell you want to move- in my example I want to move 27 Jun to 03 July 2016 Hover over the border of the cell until you see a four headed arrow When you see the green line drag it to the position you want, your value field will be moved also My data is not sorted exactly as I want it to be. If you now go to your normal sort options in your Pivot Table, you will now see that the options are set to Manual.  To return the sorting back to normal just select either ascending or decending for your sort options. 2. Copy A Worksheet To Another Workbook. I find this is such a time saver.  If you want to duplicate a worksheet into another workbook, wihtout haveing to copy a whole workbook then delete the worksheets you do not want.  I used this recently to copy one League Table worksheet to another workbbok, and it saved me having to delete all of the pages I didnt need in the workbook, if I had copied the whole workbook. As usual in Excel there are a couple of ways to achive the same thing.  So here is longer process (then I will share a quick shortcut). Open the source and the destination workbook Navigate to the source workbook and sheet (the one you want to copy) Right click on the source sheet tab Click the Move or Copy option Click to Create A Copy Choose the target sheet from the To Book dropdown. Excel will display only the open workbooks in this list Click Ok.  Job Done. I find this method a lot quicker though :-) Again have the source and destination workbook open side by side Click the sheet tab in the source workbook and drag it to the target workbook. If you want to copy the sheet instead of move it, hold down the [Ctrl] key while you drag the sheet to the target workbook. That's it. Which method do you prefer?????? 3. Print Two Or More Excel Worksheets Together. Here is a great time saving tip.  If you need to print two or more Excel worksheets in the same workbook, we can group the Excel worksheets together and the worksheets don't even need to be next to each other in the workbook. Select your first sheet Hold down the CTRL key then select the other sheets one by one you want to print The sheets will now be in a GROUP and will appear white against the ungrouped In the example below you can see the 3 worksheets that are grouped together With your group of worksheets still active, go ahead and proceed with your printing tasks as normal. Let me know what you think of the Excel tips. If you want a tip mentioned in the Excel at Excel Newsletter- at the email address below. I really hope you enjoyed this edition of the How To Excel At Excel Newsletter.  If you have any tips you want to share with other Excellers just email me- barbara [at] howtoexcelatexcel [dot] com and I will share with newsletter readers.   Keep Excelling!! BJohnston MSc,Bsc(Hons),MCP,MOS Don't forget you can follow me on Twitter for even more Excel Tips and Updates. The How To Excel At Excel Newsletter Is Available To Subscribers Only.  My records show that star.basak.howtodoit@blogger.com subscribed to this newsletter. If you have been forwarded this newsletter or you would like your own copy then send a blank email to me at the address above to subscribe or visit www.howtoexcelatexcel.com and hit Sign Up. Copyright B.Johnston All Rights Reserved
Barbara (at) howtoexcelatexcel (dot) com Co.Kildare, 00447510677 418 Ireland You may unsubscribe or change your contact details at any time. Powered by: