Possible to enlarge all cells in excel at the same time?

MitzEclipse

Senior member
Nov 15, 1999
314
0
0
Possible to enlarge all cells in excel at the same time?

Hi Everyone-

Is it possible to enlarge all cells in excel at the same time? I have this calendar that i want to enlarge, but each cell is different sizes. Since its for 12 months, i don't want to enlarge each cell, that would be stupid and tedious! Is there a way to select all and resize?

Thanks
 

btvillarin

Senior member
Nov 3, 2001
469
0
0
Select the columns (or rows) that you want to change by selecting the tabs (A,B,C...1,2,3...), the enlarging just one. They will all change to the same size as the one you're resizing. I hope that's easy enough to understand, since I can't show it to you.
 

MitzEclipse

Senior member
Nov 15, 1999
314
0
0
that doesn't work... what i need to do is to resize each cell respectivly. meaning, if cell A was size 5 and cell B was size 10, and I want to enlarge ALL CELLS by 10, call A would be 15 and cell B would be 20.

Does that make sense?
 

RayH

Senior member
Jun 30, 2000
963
1
81
With your workbook open hit Alt-F8 to bring up the macro window.
Type in a name for the new macro (ex. "colw") and click on the create button.

Paste the following code replacing the "25" with the amount you want to increase the width by:

For Each col In Selection.Columns
col.ColumnWidth = 25 + col.ColumnWidth
Next

Go back to your spreadsheet and select the cells you want to resize then press Alt-F8 again, select the macro you've just created and hit the run button.