PowerShell - No Ellipses

No Ellipses:

| Format-Table -AutoSize

Excel 2013 - Freeze Top Row and First Column

Click B2 > Ribbon > View tab > Freeze Panes

PowerShell - SharePoint Database Size Report

$SMTPServer = "" 
$emailFrom = "" 
$emailTo = "" 
$subject = "Sharepoint DB Size Report"

$total = ""
$each = Get-SPDatabase | Sort-Object disksizerequired -desc | ForEach-Object {$db=0} {$db +=$_.disksizerequired; $_.name + " - " + ("{0:n0}" -f ($_.disksizerequired/1024/1024)) + "`t"} {$total = "`nTotal Storage (in MB) =" + ("{0:n0}" -f ($db/1024/1024))}
$each = Out-String -InputObject $each
$total = Out-String -InputObject $total

$emailBody = "SharePoint DB - Size in MB" + "`n" + "`n" + $each + $total

Send-MailMessage -SmtpServer $SMTPServer -From $emailFrom -To $emailTo -Subject $subject -Body $emailBody


Resources:
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=193