Have a lot of data in an Excel worksheet, and consider some of the rows to be duplicates? Here is how to determine whether a row is a duplicate.
Excel.Tips.Net: Checking for Duplicate Rows in Microsoft Excel Read More »
When editing Excel workbooks, one of the most common actions to take is to clear or delete cells…although the difference between the two actions is clear as mud.
Excel.Tips.Net: Clearing and Deleting Cells Read More »
It is not unusual to acquire or develop Microsoft Excel data tables that have duplicate values in a column. If you want to see only the unique values…
Excel.Tips.Net: Filtering Columns for Unique Values Read More »
If you are using Excel to chart very large amounts of data, the charts you create can end up being very large.
Excel.Tips.Net: How to Print Excel Chart Across Multiple Pages Read More »
The VBA programming language included with Excel allows you to create very powerful macros. It is not uncommon to record a couple of macros for a workbook, each designed to accomplish a quick little task. When you create the macros, Excel adds what is called a module to your workbook. This module is used to store the macros that you record or create.
Excel.Tips.Net: Getting Rid of the “Enable Macros” Notice Read More »
When working with data retrieved from another source—such as another user or from an external program—you may have a need to remove certain rows from the data. It is not unusual, for instance, to have the need to remove every third row or every fifth row. The following general steps allow you to delete every X rows without using a macro.
Excel.Tips.Net: Deleting Every X Rows without a Macro Read More »
If you have a large worksheet, you may want to print it out in “parts” and automatically vary the information contained in the header or footer of each part.
Excel.Tips.Net: Dynamic Headers and Footers Read More »
Peter asked if it was possible in Excel to create a custom number format that will deal with imperial linear distances, such as inches, feet, miles, etc.
Excel.Tips.Net: Working with Imperial Linear Distances Read More »
David has a footer with the page number—which is helpful—but it would be great if he could have, in the header of each page, the first name on the page and the last name on the page.
Excel.Tips.Net: First and Last Names in a Page Header Read More »
You can control the order in which Excel prints pages.
Excel.Tips.Net: Specifying an Order for Page Printing Read More »