Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Leona Wright   on Nov 14 In MS Office Category.

  
Question Answered By: Laaibah Malik   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...

Share: 

 
 
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: