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: Bug in Excel 2010?

02 Feb 2015   #1
GRoston

Windows 7 x64
 
 
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?


My System SpecsSystem Spec
.
02 Feb 2015   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

How have you set the default font. You can set the Default Font by opening Excel, select file & then Options & under General there is a Sub Heading "When Creating new Workbooks" & there you will see "Use this as the default font". Then you can use the drop down list to select the font & size. If you change this it will only operate on any new workbooks that you create. Any previous ones will remain in the font that was originally used.
I use Excel 2013 so this info comes from that, but I think Excel 2010 is the same or very similar.
My System SpecsSystem Spec
04 Feb 2015   #3
GRoston

Windows 7 x64
 
 

Ranger4,

Thanks for the reply. I take it, based on your comment, that once a workbook is created, it is not possible to change the default font? While technically this would not be a bug, it is a a rather poor design decision.
My System SpecsSystem Spec
.

04 Feb 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Quote   Quote: Originally Posted by GRoston View Post
Ranger4,

Thanks for the reply. I take it, based on your comment, that once a workbook is created, it is not possible to change the default font? While technically this would not be a bug, it is a a rather poor design decision.
No I did not mean it that way. Once you have changed the default font, any workbook created after that should have the new font, but older workbooks, that is ones created before resetting the default font will remain in the original font.

To change the font on older ones, open it & select all & click on the font & size desired & this should update the whole worksheet. Then be sure to select save when closing.
My System SpecsSystem Spec
05 Feb 2015   #5
GRoston

Windows 7 x64
 
 

Ranger4,

You are correct - one can select the entire worksheet and update the font. The problem arises if you do a 'Clear Formats' or 'Clear All'. In this case, the original default font is used instead of the desired font.
My System SpecsSystem Spec
05 Feb 2015   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

GRoston,

Yes that certainly could be the case. I assume what's happening there is that it is reverting to the font that was used when the workbook was originally created. This is not the same as creating a new workbook, it is just bringing that workbook back to its original state, as it would have been when first set up.
Is this a major problem for you?. Do you need to "Clear formats" or "Clear all" very often?.
My System SpecsSystem Spec
05 Feb 2015   #7
GRoston

Windows 7 x64
 
 

Major problem - no. Annoyance - most definitely.
My System SpecsSystem Spec
05 Feb 2015   #8
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

I can understand your irritation, but I really can't see away around it.
My System SpecsSystem Spec
06 Feb 2015   #9
GRoston

Windows 7 x64
 
 

I took a quick stab at editing the XML files, but that got me no place. Would have to study this in more detail to figure it out. There must be some way to accomplish this as the default is clearly stored in the file and the file is merely a bunch of XML.
My System SpecsSystem Spec
Reply

 Bug in Excel 2010?




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Formatting in Excel 2010
Hello all, In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box. My question is, why we use those formats? Is there any benefit for it please?
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
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Excel 2010 help
I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation. Currently there are 200 unique names in 1st column and of course 200...
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
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
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 19:38.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App