MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Reduce all fonts sizes in Excel table

  Asked By: Leona    Date: Nov 14    Category: MS Office    Views: 773

I have an Excel table that I'm copying to a Word document. It's too big
to fit properly in the Word doc!

How do I reduce all of the fonts in that table in one fell swoop? Is this

No, I don't want to resize each font component if I don't have to.



1 Answer Found

Answer #1    Answered By: Laaibah Malik     Answered On: Nov 14

Sorry, it looks like someone started a new Topic as a response to
your question, so it looks like you've had a lively discussion
while in reality, you've been completely ignored...

First, Do you really mean an Excel table  or a spreadsheet?
(series of rows/columns of data)
Excel tables are not exactly like a table in, say, Word.
Excel tables are used to supply multiple values to a formula.
(among other uses).

If you're simply trying to select a groups of cells
(your data) and change the font , it's pretty simple.

I would start by recording a macro that selects
your data and changes the font.
The recorded macro will look like:
Sub Macro1()
Selection.Font.Bold = False
With Selection.Font
.Name = "Arial"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
End Sub

You can then paste this into your Word document.

Is there more to it? Or did I misunderstand...

Didn't find what you were looking for? Find more on Reduce all fonts sizes in Excel table Or get search suggestion and latest updates.