Logo 
Search:

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: 955
  

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
possible?



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

Share: 

 

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()
Cells.Select
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
Cells.Select
Cells.EntireColumn.AutoFit
Range("A1:C3").Select
Range("C3").Activate
Selection.Copy
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.




Tagged: