Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

can't set standard font in excel

Posted on 2011-09-18
16
Medium Priority
?
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
  • 2
16 Comments
 
LVL 98

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 98

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

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!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

715 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