Excel Topics: Question & Answer
We've added this category to include some of our general questions from viewers.
Hyperlinks:
Extract hyperlink address (web addresses ONLY) in Excel 2003/XP/2000/97
Extract hyperlink address (files and web addresses) in Excel 2003/XP/2000/97
Filter final series of numbers in hyperlink address in Excel 2003/XP/2000/97
Delete a hyperlink from a cell in Excel 2007 | Excel 2003/XP/2000/97
Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97
Update cell based on hyperlink selected in Excel 2003/XP/2000/97
View hyperlink result at top of viewing area in Excel 2007 | Excel 2003/XP/2000/97
Checkboxes:
Update a cell when a checkbox is clicked (Forms toolbar) in Excel 2003/XP/2000/97
Update a cell when a checkbox is clicked (Control Toolbox toolbar) in Excel 2003/XP/2000/97
Radio buttons:
Set up groups of radio buttons on a form to function independently in Excel 2003/XP/2000/97
Combo Boxes:
Creating a combo box in Excel 2003/XP/2000/97
Link data to a combo box and update underlying data in Excel 2003/XP/2000/97
Use two combo boxes to retrieve values from a table in Excel 2003/XP/2000/97
Conditional Formatting:
Change the font color based on the value in the cell in Excel 2003/XP/2000/97
Automatically alternate row colors (one shaded, one white) in Excel 2003/XP/2000/97
Automatically alternate row colors (two shaded, two white) in Excel 2003/XP/2000/97
Automatically alternate row colors (three shaded, three white) in Excel 2003/XP/2000/97
Automatically highlight highest and lowest values in a range of cells in Excel 2003/XP/2000/97
Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2003/XP/2000/97
Highlight 1st, 2nd, 3rd highest scores in Excel 2003/XP/2000/97
Test for duplicates:
Test for duplicates in a column in Excel 2003/XP/2000/97
Test for duplicates on partial cell contents in a column in Excel 2003/XP/2000/97
Test for duplicates in two columns, combined in Excel 2003/XP/2000/97
Test for duplicates in eight columns, combined (and delete duplicates) in Excel 2003/XP/2000/97
Test for duplicates in eight columns, combined (and delete duplicates and originals that were duplicated) in Excel 2003/XP/2000/97
Test for duplicates in eight columns, combined (and clear the values in the 8 columns when a duplicate is found) in Excel 2003/XP/2000/97
Create a column in Excel that must contain unique values in Excel 2003/XP/2000/97
Validation:
Set up cell to only allow a certain number of characters in Excel 2007 | Excel 2003/XP/2000/97
Set up a cell to only allow numbers in Excel 2007 | Excel 2003/XP/2000/97
Filters:
Filter a single column based on 3 or more criteria in Excel 2003/XP/2000/97
Filter 2 columns based on 3 or more criteria in Excel 2003/XP/2000/97
Apply a filter to an existing filter in Excel 2003/XP/2000/97
Copy filtered data to a new worksheet in Excel 2003/XP/2000/97
Sorting:
Sort data in alphabetical order in Excel 2003/XP/2000/97
Freeze/Unfreeze Panes:
Freeze panes in Excel 2003/XP/2000/97
Freeze panes to see first row and first column in Excel 2003/XP/2000/97
Unfreeze panes in Excel 2003/XP/2000/97
Integration with Access:
Open an Access Form from Excel 2003/XP/2000/97
Time Calculations:
Perform time calculations (Example #1) in Excel 2003/XP/2000/97
Perform time calculations (Example #2) in Excel 2003/XP/2000/97
Perform negative time calculations in Excel 2003/XP/2000/97
Array Formulas:
Sum values in Column A when value in Column B and Column C match criteria in Excel 2003/XP/2000/97
Sum values in Column AB when value in Column E and Column AB match criteria in Excel 2003/XP/2000/97
Use an array formula to count ranges of times in Excel in Excel 2003/XP/2000/97
Use an array formula to count the number of children who will attend lunch in Excel 2003/XP/2000/97
Use an array formula to perform a two criteria lookup in Excel 2003/XP/2000/97
Use an array formula to count the number of rows that match 2 criteria in Excel 2003/XP/2000/97
Use an array formula to count the number of occurrences when the value in column A is greater than or equal to the value in column D in Excel 2003/XP/2000/97
Use an array formula to average values when 2 criteria are met in Excel 2003/XP/2000/97
Use an array formula to calculate monthly attendance in Excel 2003/XP/2000/97
Miscellaneous:
Test range of cells for formulas (or missing formulas) in Excel 2003/XP/2000/97
Delimit values with Ascii 29 character in Excel 2003/XP/2000/97
Remove carriage returns (displayed as tiny boxes) and <br> tags from data in Excel 2003/XP/2000/97
Automatically refresh pivot table when data in a sheet changes in Excel 2003/XP/2000/97
Automatically refresh pivot table when user switches between sheets in Excel 2003/XP/2000/97
Link one cell to another cell (control the recalculation) in Excel 2003/XP/2000/97
Change the background color of a row based on a cell value in Excel 2003/XP/2000/97
Macro to warn when a record will expire within 31 days in Excel 2003/XP/2000/97
Overwrite column B value when column A value is higher in Excel 2003/XP/2000/97
Relative vs Absolute referencing in Excel 2003/XP/2000/97
Function to calculate total cost based on a tiered fee structure in Excel 2003/XP/2000/97
Autonumber a cell each time the spreadsheet is opened in Excel 2003/XP/2000/97
Open a new instance of Excel whenever you launch the application in Excel 2003/XP/2000/97
Share a spreadsheet between multiple users in Excel 2003/XP/2000/97
Sum each month's data applying an exchange rate in Excel 2003/XP/2000/97
Generate a random number in Excel 2003/XP/2000/97
Get contents of first cell in a range that has data in Excel 2003/XP/2000/97
Get contents of last cell in a range that has data in Excel 2003/XP/2000/97
Counting matched pairs in Excel 2003/XP/2000/97
Convert date/time value to a date value (remove time portion) in Excel 2003/XP/2000/97
Copy and paste only nonblank cells (condensing paste range) in Excel 2007 | Excel 2003/XP/2000/97
Display a large number without scientific format in Excel 2003/XP/2000/97
Formula based on whether a cell has a value in Excel 2003/XP/2000/97
Format the display of a date value in concatenated text in Excel 2003/XP/2000/97
Set the print area in Excel 2003/XP/2000/97
Calculate the incremental difference in a running total column even when blank values are found in the series in Excel 2003/XP/2000/97
Link to a cell in a Lotus file in Excel 2003/XP/2000/97
Count the number of cells with a particular font color in Excel 2003/XP/2000/97