TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)
Please be sure to mention the version of Office you are using when you send your question.
I answer all e-mails that I receive via this form, as long as they are polite :)
Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.
Format multiple chart elements without closing the dialog box (Excel 2007)
Good morning! With everything I covered in yesterday's turbo tips for Excel 2007 charts, I forgot to show one of my favorite little timesavers ...
Open a Format dialog box for a chart element (to do this, select the chart element and then select the Format option from either the right-click menu, the Current Selection group on the Chart Tools Layout or Format tabs, or with the CTRL+1 shortcut...
Make a change and then click on the chart to select another chart element - without closing the format dialog box. The dialog box will change to reflect your new selection and you can make changes to it as well. When you close any format dialog box, all changes you made since you opened a Format dialog box will be kept.
Now that's a very nice timesaver, and quite worth losing the ability to open the Format dialog box with a double-click :)
Happy Friday everybody!
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt2/mt-tb.cgi/244
