Learn to specify a different default file format for your Excel files.
2 simple steps to add an Excel chart to a worksheet.
A quick, easy way to remove hyperlinks without a macro.
How to take advantage of Excel autofill variations with a right click.
How to use different formatting to differentiate the odd numbers from the even numbers.
David would like to create a chart that could be dynamically changed to show the sales for a single company from the worksheet.
This simple key combination will delete rows and/or columns in Microsoft Excel.
Step by step instructions to delete conditional formatting in a Microsoft Excel worksheet.
Did you know? Excel allows you to sort graphics along with the regular data in your tables. Here is how to do it…
Excel normally sets the height of rows within your worksheet to reflect the size of the largest font used on the row. You can, however, adjust the height of the row to any size desired.
Excel users are always looking for ways to speed up large worksheets. If you are using a large worksheet that has lots of static formulas in it, this tip may be of help to you.
Excel has a handy scaling feature that allows you to specify how many pages you want your printed output to occupy.
Learn to configure how information should be oriented within a Microsoft Excel cell.
How to make Excel jump to the end of the real data.
Excel allows multiple people to access a workbook at the same time, if desired. This can be very handy when a workbook is in active use or development, and there are multiple people in your department who all have a hand in the process. You can share a workbook in this way:
How to include a bitmap image on a Microsoft Excel form that changes according to a variable.
As you use the spell-checking capabilities of Excel, you undoubtedly have added words to your custom dictionary.
Excel includes a spelling checker that you can use to proof the text in your worksheets.
Learn how to replace the regular bars (in an Excel bar chart) with your own graphics.
If you are an Excel worksheet that contains address information, you may want to convert nine-digit ZIP Codes to their five-digit equivalent.
Anything you do in Excel that is of a repetitive nature is a good candidate for a macro.
You may want to print multiple pages of your Excel worksheet on a single piece of paper.
To ensure that only certain data can be entered in the cell, follow these steps:
Step by step instructions for how to create CSV files that are often used for transferring simple data from one program to another.
This list allows users to select the cell and then select from a list of pre-defined values for that cell. Once the user makes a selection and moves to a different cell, the arrow for the drop-down list disappears.
The sorting capabilities of Excel are quite handy, and quite powerful…but sometimes subject to corruption.
Give your Microsoft Excel graphs a more professional look by simply smoothing out the curves Excel uses at each data point.
Excel includes a control that allows you to specify how you want it to interpret what percentage you enter.
There is a very cool way, apparently not well known, of adding ‘active’ or ‘live’ titles and other text to charts.
Many times in early childhood education, a child’s age in Years.Months format is needed for reporting, admitting, and evaluation. Basically, this format shows the number of elapsed years and months since birth, separated by a period.
Let’s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.
One of the neat Microsoft Excel features — control how the files are sorted in the dialog box.
Want a really quick way to clear the cells in a range you’ve selected?
How to use the feature built into Excel that provides the ability to automatically capitalize days of the week if you enter them in a cell.
A number of different ways to round to the nearest quarter hour in Microsoft Excel.
How one of Microsoft Excel’s most obscure functions can make your life easier.
Learn how Excel can catch mistakes caused by Cap Lock being left on.
Excel provides a pair of nifty shortcut keys that can be used to copy cells down and to the right.
When you are designing the header and footer for a worksheet, Excel allows you to add various special elements to your header or footer.
How to sort Microsoft Excel data containing merged cells.
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.
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.
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…
If you are using Excel to chart very large amounts of data, the charts you create can end up being very large.
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.
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.
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.
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.
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.
You can control the order in which Excel prints pages.