Skip to content
- Excel Bar Graph: Sort Values Largest to SmallestTo sort an Excel bar graph from largest to smallest, sort the chart’s source data by its value column: select a cell…Charts & pivot tables
- Excel Bar Graph Not Showing All Data? Fix ItIf an Excel bar graph is missing bars or categories, first check its source range in Chart Design > Select Data, then…Charts & pivot tables
- Excel Bar Graph Grouping: Create Clustered BarsTo group bars in Excel, arrange each group as a separate data series, select the category labels and values, then choose Insert…Charts & pivot tables
- Excel Bar Graph Creation: Steps, Tips, and FixesTo create a bar graph in Excel for Microsoft 365 on Windows, select a labeled data range, then choose Insert > Insert…Charts & pivot tables
- Excel Bar Graph: Count Occurrences and Chart ResultsTo count how often each category appears in Excel and show the totals in a bar graph, make a list of categories,…Charts & pivot tables
- Excel Bar Graph Conditional Formatting: Color by RulesExcel does not apply worksheet conditional formatting rules directly to the bars in a chart. To make bar colors change automatically with…Charts & pivot tables
- Excel Day Value: Serial Dates and the DAY FunctionAn Excel day value can mean either the serial number Excel uses to store a date or the day of the month…Formulas & functions
- Excel Day Trading Journal: Build a Useful Trade LogYes—Excel can track day trades, calculate profit and loss, and help you review whether your strategies and rules are working. Start with…How-to basics
- Excel Day Tracker: Build a Daily Log for Work and HabitsAn Excel day tracker is a spreadsheet for recording what happens or what needs doing each day. The simplest version uses columns…How-to basics
- Excel Not Tabbing to Next Cell? Fixes That WorkIn Excel for Microsoft 365 on Windows, pressing Tab while a worksheet cell is selected normally commits any entry and moves the…How-to basics
- Excel Not Selecting Cells Properly? Find the Right FixIf Excel is not selecting cells properly, press Esc and check whether a selection mode such as Extend Selection or Add to…Errors & fixes
- Excel Not Responding on Windows 11? Fix It SafelyIf Excel says “Not responding” on Windows 11, first give it a moment—large calculations or files can temporarily occupy the app—then check…Errors & fixes
- Excel Not Responding? Fix It Without Losing Your SaveIf Excel says “Not Responding,” don’t force-quit it straight away: wait briefly, avoid clicking repeatedly, and try saving with Ctrl+S if the…Errors & fixes
- Media Excel Shortcuts for Images, Links, and ObjectsExcel has no single keyboard shortcut for all media. In Microsoft 365 for Windows, use Ctrl+V to paste a copied image, Alt+F10…How-to basics
- Excel Pivot Table Median Instead of AverageYes—but a standard Excel PivotTable cannot choose Median in its usual Value Field Settings list. In Excel for Microsoft 365 on Windows,…Charts & pivot tables
- Average in Excel Without Zeros: Formula and ExamplesTo average numbers in Excel while ignoring zeros, use =AVERAGEIF(A2:A8,"<>0"). Replace A2:A8 with your data range; Excel averages the nonzero numbers and…Formulas & functions
- Average Excel File Size: What to Expect and Why It VariesThere is no single meaningful average Excel file size: a simple workbook may be only a few dozen kilobytes, while a workbook…How-to basics
- Excel Cell Range Average: Formula and ExamplesTo average a range in Excel, use AVERAGE: if A2:A5 contain 10, 20, a blank cell, and 0, =AVERAGE(A2:A5) returns 10, because…Formulas & functions
- SUMPRODUCT Excel Not Working? Fix Common ErrorsIf SUMPRODUCT is not working, first check that every range has the same number of rows and columns, then look for errors,…Errors & fixes
- SUMPRODUCT Excel #DIV/0! Error: Causes and FixesYes—SUMPRODUCT returns #DIV/0! when its calculation divides a value by zero, or when an input cell already contains that error. Check the…Errors & fixes
- Excel SUMPRODUCT Shortcut: Formula, Uses, and ExamplesExcel has no dedicated keyboard shortcut for SUMPRODUCT: enter the formula in a cell and press Enter. For example, with quantities in…Formulas & functions
- Excel SUM Without Hidden Cells: Which Formula to UseTo sum only visible rows in Excel, use SUBTOTAL with function number 109. With amounts in B2:B6 and rows 3 and 5…Formulas & functions
- Excel Sum Shortcut Keys: AutoSum, Examples, and TipsIn Excel for Microsoft 365 on Windows, press Alt+= to insert an AutoSum formula; check the highlighted range, then press Enter to…How-to basics
- Excel Sum Same Cell Across Tabs: The 3-D Formula GuideIf the sheets you want to total are next to one another in the workbook, use a 3-D SUM formula. With monthly…Formulas & functions
- Excel Sum Rows Based on Cell Value: Formulas That WorkTo total values in rows where a cell matches a condition, use Excel’s SUMIF function. With categories in A2:A6 and amounts in…Formulas & functions
- Excel Sum Range Based on Cell Value: SUMIF and MoreWith the values to test in A2:A7, amounts to add in B2:B7, and the requested category in D2, use =SUMIF(A2:A7,D2,B2:B7) to sum…Formulas & functions
- Excel Sum Keyboard Shortcut: Use AutoSum in SecondsIn Excel for Microsoft 365 on Windows, press Alt+= to insert AutoSum, which creates a SUM formula for a nearby range; press…How-to basics
- Excel Sum If Cell Is Yellow: Practical Ways to Do ItExcel cannot directly sum cells by fill color with SUMIF or another built-in worksheet formula. To total yellow cells, use a helper…Formulas & functions
- Excel Sum Hours: Formulas, Time Formats, and FixesTo sum elapsed hours in Excel, add the duration cells with =SUM(B2:B5), then format the total as [h]:mm so hours keep accumulating…Formulas & functions
- Excel Sum Filtered List: SUBTOTAL and SUMTo sum only the rows currently visible after filtering in Excel, use =SUBTOTAL(109,B2:B6), assuming the values are in B2:B6. SUBTOTAL recalculates as…How-to basics