http://www.microsofttraining.net/microsoft-office-hints-tips.html Software application hints and tips from our Microsoft certified trainers en Sat, 17 May 2008 03:55:19 GMT Sat, 17 May 2008 03:55:19 GMT http://www.microsofttraining.net/rss-feeds.php Select the data and press the function key F11 and the chart will be created on a separate worksheet. http://www.microsofttraining.net/tip-555-create-chart.html Mon, 31 Mar 2008 00:00:00 GMT http://www.microsofttraining.net/tip-555-create-chart.html When inserting a jumpmenu to a page, the only option available for 'open in' is usually 'main window'. There would be other options available if the page was a frameset. To change the jumpmenu to open in a new window, change the target parameter of the selectbox in your code to 'window.open()'. eg. [code]<select name="menu1" onChange="MM_jumpMenu('window.open()',this,0)"> [/code] source: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16166&sliceId=1 http://www.microsofttraining.net/tip-554-jumpmenu-in-new-window.html Mon, 11 Feb 2008 00:00:00 GMT http://www.microsofttraining.net/tip-554-jumpmenu-in-new-window.html There is a quicker way of copying a formula down a column. Just point and double click on the black autofill handle in the right hand corner of a cell. This will work providing you have some data in the column to the left of the column. Sandy http://www.microsofttraining.net/tip-553-formula-using-autofill-handle.html Mon, 17 Dec 2007 00:00:00 GMT http://www.microsofttraining.net/tip-553-formula-using-autofill-handle.html When you have several workbooks open in Excel and want to just close them all at once: 1) Hold down the SHIFT key before selecting the File menu. 2) Once in File menu release SHIFT key and select Close All option. 3) All your files will close. If files require saving Excel will ask if you want to save the changes. http://www.microsofttraining.net/tip-552-close-all-open-workbooks.html Thu, 11 Oct 2007 00:00:00 GMT http://www.microsofttraining.net/tip-552-close-all-open-workbooks.html If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. http://www.microsofttraining.net/tip-551-lost-your-field-handle.html Wed, 10 Oct 2007 00:00:00 GMT http://www.microsofttraining.net/tip-551-lost-your-field-handle.html Clicking on links in Firefox with your middle mouse button (scroll wheel) opens links in new tabs. Clicking on tabs with your middle mouse button (scroll wheel) closes the tab. http://www.microsofttraining.net/tip-550-middle-mouse-button-firefox.html Thu, 05 Apr 2007 00:00:00 GMT http://www.microsofttraining.net/tip-550-middle-mouse-button-firefox.html To open a dialog box allowing you to enter the date in Normal View press Alt+Shift+D http://www.microsofttraining.net/tip-547-enter-date.html Mon, 12 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-547-enter-date.html To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1) http://www.microsofttraining.net/tip-548-separate-year-from-date.html Mon, 12 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-548-separate-year-from-date.html In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 http://www.microsofttraining.net/tip-549-find-month-last-day.html Mon, 12 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-549-find-month-last-day.html To select a single data marker in a chart, ie line, bar or column; After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series. http://www.microsofttraining.net/tip-544-select-single-data-marker.html Wed, 07 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-544-select-single-data-marker.html When you are saving (or opening) a file, try these; (Note the numbers are on the keyboard not the numeric keypad) 1. Go to previous folder Alt+1 2. Go up one folder level Alt+2 3. Search the Web Alt+3 4. Delete selected file Alt+4 or Delete 5. Create a new folder Alt+5 6. Cycle through all views Alt+6 repeatedly 7. Display the Tools menu Alt+7 http://www.microsofttraining.net/tip-545-alt-in-save-dialog.html Wed, 07 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-545-alt-in-save-dialog.html Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!! 1. Press Shift+F11 to create a new worksheet 2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK. 3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt) 4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash) Name your templete sheet.xlt, then press Enter. Sheet.xlt is used when you insert a new worksheet (Shift+F11) Note: These changes are permanent changes on your PC. http://www.microsofttraining.net/tip-546-new-normal-worksheet.html Wed, 07 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-546-new-normal-worksheet.html If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered. http://www.microsofttraining.net/tip-541-sorting-list-subtotals.html Sun, 04 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-541-sorting-list-subtotals.html To manually rotate a 3D chart; Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice. If you dont get it right first time, dont worry, the manoeuver is a little bit tricky. http://www.microsofttraining.net/tip-542-rotating-chart-manually.html Sun, 04 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-542-rotating-chart-manually.html In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. http://www.microsofttraining.net/tip-543-shared-conditional-formatting.html Sun, 04 Mar 2007 00:00:00 GMT http://www.microsofttraining.net/tip-543-shared-conditional-formatting.html