Excel Tip - Workbook wide header/footer change

I admit I feel a little stupid now that I know how to do this.  "This" meaning how to change multiple headers and footers of Excel spreadsheets within a single workbook.  Good ole Lytebyte informs me that all you have to do is use the CTRL (Win) or Command key (OS X) to select multiple spreadsheet tabs, go to File -> Page Setup -> Header and Footer, make changes, and hit OK.

That's it.  No more clicking through each spreadsheet to make the change.  You simply use the CTRL/Command key for what it what was meant...selecting various things at once.  AAAHHHHH.  Sorry.  I could have used this trick a long time ago.

OS X Tip - Missing Window

I use multiple spaces (now called Desktops I think in Lion) and multiple monitors.  Lately after I disconnect my monitor to take my Air somewhere else, when I open up my laptop I notice there are a few windows open that will not leave the phantom space/desktop.

In Windows, you can right click the app in the dock, select MOVE, and you can use your cursor to move the window back to where you can use it.  OS X doesn't have that functionality.  The ONE solution I have found to work without fail is the Zoom function.  I think this relates to the green plus that resides at the top left of a window.

If you create a new window in the app, such as Word, and then click on the Zoom button, the window magically pops into view.

Saved my butt a few times, hope it does for you too.

UPDATE: Not sure if this is a Lion update issue or not but my technique has not been working lately.  Try this instead.  Go to Word, then Window, then "Zoom Window".  This does the same thing as the green "+" as mentioned above but is probably more effective.