How to Make a Dot Plot in Excel
A dot plot in Excel shows how often each value occurs, with one dot for every observation. Repeated values form stacks, so you can count them without reading every row. …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
Rows to Repeat at Top Greyed Out in Excel? How to Fix It
When Rows to repeat at top is greyed out in Excel, you cannot choose the header rows that should appear on every printed page. The fix depends on what is …
How to Turn Off Sheet View in Excel
To turn off an active Sheet View in Excel, go to View > Sheet View > Exit. Excel returns you to Default, the worksheet’s main view. Sheet View lets you …
How to Graph an Equation in Excel
To graph an equation in Excel, calculate its y values for a set of x values, then plot those pairs on an XY Scatter chart. You can start with only …
Why Is Show Changes Greyed Out in Excel?
If Show Changes is greyed out in Excel, start by checking where the workbook is saved. Then check your Excel edition and file format. An empty Changes pane needs a …
Excel Not Highlighting Selected Cells? How to Fix It
When Excel doesn’t highlight selected cells, it’s hard to tell where your next entry or formatting change will go. First, check whether the selection is missing or simply looks different. …
How to Find and Replace Tab Characters in Excel
Tab characters inside Excel cells can be hard to spot. They may look like spaces, but Excel treats them as different characters. Pressing Tab moves your selection to another cell. …
How to Create a Step Chart in Excel
A step chart in Excel shows a value staying constant until a particular date, then changing immediately, such as a hire fee or subscription price. Joining the original dates and …
Filter by Color Not Working in Excel? How to Fix It
Filter by Color in Excel is the quickest way to pull out the rows you’ve highlighted, like urgent requests or overdue items. So it’s frustrating when the option is greyed …
How to Trace Precedents and Dependents in Excel
When a number looks wrong or you’re about to change a cell, it helps to see how that cell connects to your formulas. Precedents are the cells a formula uses. …
How to Create Custom Keyboard Shortcuts in Excel
Custom keyboard shortcuts in Excel let you run a command you use often without finding it on the ribbon each time. Windows Excel has no screen for picking a command …
How to Calculate MAPE in Excel
MAPE (mean absolute percentage error) in Excel shows you how far your forecasts missed actual results, as an average percentage. Over- and under-forecasts don’t cancel each other out. Months with …