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
meebers

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 Win7/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
Ranger4

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
Ranger4

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
meebers

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
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Microsoft Office 2010 - Excel problem
Well not really a problem with Excel, more of a memory problem with me. A few years back (in '03 Office) I collapsed the Excel file by way of a phone conversation. And now I forget nor find the way to un-collapse and get my lines 1 thru 95 back. Although I have used info on lines 96 and on. Any...
Microsoft Office
problem saving excel spread sheet in 2010 to 97-2003 format
I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Outlook 2010 EXCEL (64 bit) problem
Hi there This might be more related to IE8 rather than EXCEL but I find using EXCEL 2010 X-64 bit version with macros to dynamically create WEB QUERIES (retrieve external data from web sites), download into spread sheet and "Auto" update doesn't work properly. This means some things like Stock...
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 15:23.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App