Excel 2010 Problem?

OK, now I know I am not the only one back to the original question. It seems like the format window is relative to the cell that is to be formatted. (below and centered on that cell) for the most part. I do not know if there is an "option" to keep the format window within excel's border. i.e. If I insert a clip art, even though I have A1 selected, that clip art will remain within the border. I looked at options ad nauseam, just do not see anything. I do a lot of excel @ work and when working near the border, I have to constantly move the window to see all the options when formating etc. I would want it to remember its last location so to speak.

My initial problem is with Win7/64 Excel 2010. Just checked on my Win8/64 Excel 2013, it behaves the same as expected.

Hi meebers, I don't know of any option to keep the format window within the border as you describe.

Can you easily use one of the options I listed in post 10. It does possibly mean working with only one screen in some cases but it does get away from the format window problem in the extreme LH cell columns.

Hi meebers & AirPower4ever I have found a very quick & easy solution for the format window in Excel. Instead of right clicking on the cell & selecting format, select the cell & use Ctrl+1. This drops down the format box around the centre of the screen.