Solved

can't set standard font in excel

Posted on 2011-09-18
16
197 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 90

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 90

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
 

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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now