Export an R data frame into a formatted Excel sheet
Posted 22nd March 2024
No comments
A straightforward method for exporting an R data frame to a formatted Excel workbook.
Remove sensitivity labels from Office files
Posted 14th October 2022
No comments
If your organisation utilises Microsoft Azure or Purview to apply “security labels” to your Office documents, you may be compelled to have unsightly headers and footers in your documents. There is a way around this, but it’s clunky.
Easily create QR Codes in Word
Posted 16th May 2018
18 comments
Did you know that it is possible to generate fully-functional QR codes in Microsoft Word using mail merge without the need for third-party plugins?
Add comments to Excel formulae
Posted 29th September 2016
2 comments
Are your Excel formulas getting out of control? Here’s an easy method to insert comments, so that you can keep track of what’s what.
Duplicate Excel cells multiple times
Posted 13th April 2016
No comments
Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.
RGB to HEX in Excel
Posted 24th March 2016
17 comments
Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.
Rearrange Excel columns via Visual Basic
Posted 16th March 2016
22 comments
A simple VBA script for rearranging the order of columns in an Excel spreadsheet.
VBA: Convert text to columns for all worksheets in Excel
Posted 26th November 2015
7 comments
A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.
Combine multiple CSVs into one XLSX via PowerShell
Posted 25th November 2015
19 comments
A convenient PowerShell script that will detect all of the CSV files in a directory and merge them into a single XLSX file. Each CSV becomes a worksheet in the XLSX.
VBA: Delete all Excel columns except those named
Posted 16th September 2015
2 comments
Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.