Wacky World of Worksheets
Highlight all the cells in a row, if one cell is above or below a specific value.
To do this, use Excel conditional formatting, as described in this short Excel video tutorial.
For detailed instructions, please visit the page Excel Conditional Formatting Based on another cell
____________________
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting.
This short video shows you the steps.
For detailed instructions see Excel Conditional Formatting Basics.
________________
You can create a user form in Excel, to control how users are able to enter data.
These 3 short Excel video tutorials show you the steps.
For detailed instructions please visit the web page Create an Excel UserForm.
_________________
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference.
To turn this feature off, follow the instructions in this short video.
For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables.
________________
If you find Excel VBA code on a website or a sample file, you can copy it to your own Excel file.
Follow the steps in this short Excel video tutorial to copy the code.
For detailed instructions please read the article Excel VBA – Adding Code to a Workbook
______________
You can quickly change values in Excel, without using formulas.
Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage.
For detailed instructions, please visit Excel data entry tips.
______________
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect.
This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers
______________________
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data.
For written instructions please read the article Fill Blank Cells in Excel to Complete a Table
________________
When you open a file in Excel, you might see an "Enable or Disable a Macro” message, but you know that there are no macros in the file.
Follow the steps in this video, to prevent this message from appearing.
For written instructions see: Remove Excel macro warning
______________
