User Passwords in Excel – Multiple Passwords
Posted on December 12th, 2008 by Joseph Harris
Simple multiple user password protection in Excel.
Archive for the ‘Excel Hints’ Category
Duplicates – Finding and Removing in Excel
Posted on December 2nd, 2008 by Joseph Harris
There are many occasions when you may need to remove rows that contain duplicate information. There are two quick and easy methods to accomplish this. Methods for Removing Duplicates: Autofilter The & operator To use method 1: Select the list of data where you would like to delete duplicate rows (including headers). In the [...]
How to Create a Pareto Chart in Excel
Posted on November 20th, 2008 by Joseph Harris
Creating Pareto Charts
Removing Macros from a Workbook
Posted on November 12th, 2008 by Joseph Harris
Q: How do I remove all the macros from my workbook? I don’t want the “this workbook contains macros prompt” to appear anymore? Thanks, Rodge A: Rodge, There are three things you can do to get rid of the macros message when you open the workbook. Set the macro security setting to low. Move all [...]
Excel Data Validation
Posted on November 11th, 2008 by Joseph Harris
Data validation gives the Excel developer a way of dictating the type of information that can be entered in a worksheet. It is a versatile tool that can be used in many situations. With data validation you can: Provide users a list of options to choose from Dictate the type or size of input Create custom settings I often [...]
Excel Add-ins – Installing and Using
Posted on November 1st, 2008 by Joseph Harris
Quick guide to installing and using Excel add-ins.