Zooming

• I have a column header full of text. When I zoom in the text no longer fits in the cell. What can I do? Resizing the columns and rows is out of the question as it takes too long. Why is the text sized up more than the cell itself?