View Articles by Category
There are no sub categoriesCategory » Excel
Various Microsoft Excel hints and tips
There were 8 articles found in this category:
H&S External Risk Assessments - Overview and Macro Code
The document gives an overview of how the template is designed to work and documents the macro code. If you require a user-guide, please see the other article, entitled "H&S External Risk Assessments - Crib Sheet"- Pivot Tables
Click the link below to download instructions for creating, modifying and copying pivot tables.
- Excel - multiply by a percentage
To multiply a range of number by a percentage, add the number to Excel e.g. 0.40 and then copy and 'paste special' over the number range affected.
- Split contents of an Excel cell
1. Select the cells or the entire column that contains the information you want to divide. You must have a least one or more blank columns to the right of the selecteed column. 2. On DATA menu, click Text to Columns. 3. Follow the Wizard to specify how you want to divide the text into columns.
- H&S External Risk Assessments - Crib sheet
This article has the user-guide as an attachment. For a general overview and code documentation, please see the other article entitled "H&S External Risk Assessments - Overview and Macro code"
- Basic printing from Excel
Please click on the attachment at the bottom of the page for instructions on 'Basic printing from Excel'.
- Inserting the current Excel file name in a cell
Inserting the current Excel file name in a cell Applies to Microsoft Excel 2002 Note The parameter "filename" referred to in the CELL function in this article is literally the word "filename", in quotation marks. ---------------------------------------- Insert the current file name, its full p ...
- Delete duplicate rows from a list in Excel
Delete duplicate rows from a list in Excel Applies to: Microsoft Office Excel 2002 and 2003 A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delete duplicate rows, you filter a list for unique rows, delet ...