Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Problem?


13 Nov 2013   #11

Windows 7 Professional X64 Service Pack 1
 
 

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 Windows 7/64 Excel 2010. Just checked on my Win8/64 Excel 2013, it behaves the same as expected.

My System SpecsSystem Spec
.

13 Nov 2013   #12

Windows 7 Home Premium 64 bit sp1
 
 

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.
My System SpecsSystem Spec
13 Nov 2013   #13

Windows 7 Home Premium 64 bit sp1
 
 

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.
My System SpecsSystem Spec
.


14 Nov 2013   #14

Windows 7 Professional X64 Service Pack 1
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
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.
You are correct. Also discovered that if you move that box on the screen, it will remain there next time Ctrl+1 is used. Thanks for hanging in there with me!!!

As an added note, I like to have 2 sessions of Excel open at the same time, one on each screen. Makes data transfer/copying etc. easy. Second session opens while holding the Ctrl button and select Excel again
My System SpecsSystem Spec
Reply

 Excel 2010 Problem?




Thread Tools



Similar help and support threads for2: Excel 2010 Problem?
Thread Forum
Microsoft Office 2010 - Excel problem Microsoft Office
problem saving excel spread sheet in 2010 to 97-2003 format Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2010 Auto Refresh Problem Microsoft Office
Outlook 2010 EXCEL (64 bit) problem Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:32 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33