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 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.
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:
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.
In essence, all spreadsheets are the same in that they help organize and analyze data. The main difference between Microsoft Excel and other spreadsheets is the interface.
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.
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.
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.
You can control the order in which Excel prints pages.
There are times when it is beneficial, or even mandatory, to spell numbers out.
You may have an occasion when you have two data lists that we want to “line up.”
Linda asked if there is a formula that will convert a date shown in the European fashion of day/month/year to the US version of month/date/year. Truth be told, this may not be necessary.
Normally, Excel saves your worksheets in the workbook format that is appropriate for the version of the software you are using.
David asked how he could return a date associated with the maximum value in a particular column. In David’s application, he had two columns containing dates and weights associated with those dates. He could figure out how to determine the maximum weight, but not how to pull the date on which that weight occurred.