How do I change size of the cells?

Jan 26, 2011 at 9:57 AM

How do I change size of the cells?

And thank you for a fantastic add on for excel.



Jan 26, 2011 at 7:07 PM

You can't change size of individual cells, you change column width or row height for a cell. Here is an example that changes active cell height and width:

$ActiveCell.Rows.Item(1).RowHeight = 30
$ActiveCell.Columns.Item(1).ColumnWidth = 20

Thank you for the comment.

Jan 27, 2011 at 8:27 PM
Thank's for the help, I actually thinking rows and columns, that's a
good example of me not thinking when I type.

Nov 9, 2012 at 11:08 PM


Please explain how to add powershell to excel?

Thank you