- Open new excel sheet.
- Select desired paper size (A4 or A3... of course), orientation and set margins.
- Open View tab.
- Click Page Layout under Workbook Views.
- Press Ctrl+A.
- Open Home tab.
- Click Format under Cells.
- Select Row height and enter desired size with mm suffix (or "in" for rednecks)
- Click Format under Cells
- Select Column width and enter desired size.
- Open View tab.
- Click Normal under Workbook Views.
- Done.
Monday, July 28, 2014
Set Excel 2013 cell size in millimeters (or inches for those relics living in US)
Saturday, July 19, 2014
SID HISTORY: Fixing SQL
SQL server logins may have old SIDs. This doesn't fix them (because we didn't have this particular problem at work) but shows if there's any that need to be fixed.
SID HISTORY: Fixing Exchange
Dumping my notes about fixing SID history at work. Use at your own risk. These worked for me but won't work for you without some adjustments.
Adding aufs support to Ubuntu LTS 14.04 with 3.16-rc5 kernel
Adding aufs support to 3.16-rc5 is little different than what is was for older kernels. Below works for Ubuntu LTS 14.04.
Wednesday, July 16, 2014
Ubuntu Server 14.04 LTS with encrypted md mirrored rootfs and remote ssh unlock
This post is just to let everyone know old process described here in my earlier post still works and also survives upgrade from older Ubuntu version to 14.04 LTS.
Export Bitlocker recovery keys from AD using PowerShell
This exports list of BitLocker recovery keys from AD. Found it somewhere from web.
Wednesday, July 09, 2014
Export out-of-office (OOF) autoreplies from Exchange 2010 with Powershell
Quick and very dirty export out-of-office (OOF) autoreplies from Exchange 2010 with Powershell.
get-mailbox -resultsize unlimited | get-mailboxautoreplyconfiguration | where {$_.autoreplystate -ne "disabled"} | select identity,autoreplystate,starttime,endtime,@{NAME='InternalMessage';Expression={$_.InternalMessage -replace ("`n") -replace("</p","/<") -replace("<.*?>") -replace(" ","") }},@{NAME='ExternalMessage';Expression={$_.InternalMessage -replace ("`n") -replace("</p","/<") -replace("<.*?>") -replace(" ","") }} | Export-Csv -Encoding unicode -NoTypeInformation outofoffice.csv
Collaboration Data Objects (CDO) 1.2.1 with Outlook 2010 and 2013
Many vbscripts use old Outlook / Exchange CDO components for MAPI access. Without CDO you'll get "ERROR: ActiveX component can't create object (MAPI.Session)" error message. Unfortunately CDO works only with 32-bit Outlook 2007. If you're running 32-bit Outlook 2010 or 2013 in either 32-bit or 64-bit OS following might come handy.
Subscribe to:
Posts (Atom)