Use a Relative Macro to Speed up Formatting in Excel

Use a Relative Macro to Speed up Formatting in Excel

Make Formatting Super Quick - Record Relative Macros In a recent blog post we learnt how to create custom formats in Excel and how useful and time saving they can be. You can save a custom format in the default workbook to make it available globally but a lot of...
Make Changes to Excel’s Default Workbook

Make Changes to Excel’s Default Workbook

Make Changes to the Default Excel Blank Workbook Last week we looked at how to create custom formats in Excel and how useful and time saving they can be. However, sometimes in Excel, there are certain things that aren't saved globally such as custom formats or styles...
Excel Custom Number Formats

Excel Custom Number Formats

Use Excel’s Custom Number Formats to Display Numbers with their Units of Measurement Alongside… e.g 50 Kg If you have a column of data that you want to show as a measurement unit such as Km, Kg, LbsĀ and so on, you can set up a custom format so that you...