Solved

can't set standard font in excel

Posted on 2011-09-18
16
202 Views
Last Modified: 2012-05-12
When I export a query from access to excel the font used is that which I set in the tools - options - general - standard font.  However, if I use an additional column to work with the data it uses a larger font size.  Where can I set it to always use the one I set as standard?
0
Comment
Question by:robinbernett
  • 8
  • 6
  • 2
16 Comments
 
LVL 94

Expert Comment

by:John Hurst
ID: 36556313
The font setting for Excel is for new workbooks. Is the query export bringin a font along with it?

If no, try doing an Office Repair (method depends on the version of Office). ... Thinkpads_User
0
 

Author Comment

by:robinbernett
ID: 36556336
I don't know, thinkpads user.  The columns used by the query are in 8 which is what I want, the rest of the ss is in 10 which I don't.  How could I tell?

I will try the repair when I am able to close current work.
0
 
LVL 94

Expert Comment

by:John Hurst
ID: 36556358
Most of my pastes are from text or formulas, and I have to use Paste Special to get rid of incoming fonts. But I don't use query imports much. The only suggestion I have is to look at the various Paste or Import options.

Someone with more query expertise may know also. ... Thinkpads_User
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:robinbernett
ID: 36575999
If anyone out there has an answer for this I would be grateful
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 37340556
robin - can you clarify a few points?

What version of Excel are you using? (I'm guessing 2003?)
Where did you set the "standard" font - Excel or Access?
If you create a new, blank workbook, what font is used?
Are you inserting a new column to work with the query data, or just using an existing blank column?
0
 

Author Comment

by:robinbernett
ID: 37341561
mark

Yes, 2003
Standard font set in excel - although I've checked and the same is the default for access too
Arial 8
just using an existing blank column

thanks for taking an interest!
robin
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 37341661
robin - thanks for the info

A couple more follow-up question:  Can you describe your process for populating the spreadsheet?  Are you importing from a text file exported out of Access or ...?
0
 

Author Comment

by:robinbernett
ID: 37341714
A query in access, using, from access,  tools>office links>Analyze it with Microsoft Excel
0
 

Author Comment

by:robinbernett
ID: 37341741
the file sets with the correct font size, but when I run a macro on the ss in excel additional columns are in font size 10 rather than 8.  There is nothing in the macro that states any different font or size.
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 37341799
Can you post a "sanitized" example of the spreadsheet in question? (no sensitive data)

The macro is populating the additional column(s) then?

0
 

Author Comment

by:robinbernett
ID: 37341872
mark, sorry to seem ungrateful, but can I continue with this tomorrow?  I have a dependent adult waiting for me.  Sorry.  I thought I was just initiating closing this question earlier, not working towards a solution this evening.  Much appreciate your time and expertise on this.
0
 
LVL 10

Assisted Solution

by:mark_harris231
mark_harris231 earned 500 total points
ID: 37341908
Something to try/check...

Is the undesired font/size the same as the default Word font/size?  If yes, try changing the default Word font and re-testing.  I've found some indication that if you don't explicitly dictate the font characteristics, a macro will default to Word characteristics.

To change the Word default: http://support.microsoft.com/kb/291291

If that "fixes" the issue, then you'll have a couple of options:

Leave the default Word font at the settings you want for Excel
Change the Word default back and explicitly define the font characteristics in your macro/VBA
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 37341911
No problem, robin.  I'll await your next update.
0
 

Accepted Solution

by:
robinbernett earned 0 total points
ID: 37345512
mark,

I have found the problem - a template called by the macro, although having the font/size setting that I want for some reason had part of the ss somehow 'set' to the larger font size.  I don't quite understand it, but I have selected all cells in the ss and set and saved them to size 8 and it seems to have ironed out the fault.  I wouldn't have gone looking there if it hadn't been for your intervention, so thank you.

robin
0
 

Author Closing Comment

by:robinbernett
ID: 37362780
Cheers - have been trying to solve that one for months!
0
 
LVL 10

Expert Comment

by:mark_harris231
ID: 37345650
Glad you found the issue and happy to have been of (indirect) assistance.  Cheers - mark
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question