| AutoFill | yes |
| AutoFill Custom and Alphabetic Character Lists | |
| AutoFill Dates or Months | |
| AutoFill Numbers | |
| AutoFill Numbers Without Dragging | |
| Auto-Number Rows in a Column | |
| Disable AutoFill | |
| Make a List of Numbers | |
| Turn On AutoFill | |
| Use Fill Handle | |
| Use Flash Fill to Fill a Range | |
| AutoSave | yes |
| Recover a Deleted File | |
| Recover a File That Was Not Saved | |
| Set Up AutoSave Location and Time | |
| Turn On or Off AutoSave and AutoRecover | |
| Why is AutoSave Not Working or Grayed Out? | |
| Calculation | yes |
| Add Values to Cells and Columns | |
| Anchor a Cell | |
| Change the Signs of Values | |
| Divide Cells and Columns | |
| Keep Variable Cell Constant | |
| Lock / Freeze Cell in Formula | |
| Multiply Cells and Columns | |
| Stop Auto Calculation | |
| Subtract Cells and Columns | |
| Comments | yes |
| |
| |
| |
| |
| |
| Compare | yes |
| Compare Two Columns and Highlight Differences | |
| Compare Two Columns for Matches | |
| Compare Two Files for Differences | |
| Compare Two Rows | |
| Compare Two Sheets for Differences | |
| Conditional Formatting | yes |
| Apply Conditional Formatting Based on an Adjacent Cell | |
| Apply Conditional Formatting Multiple Sheets | |
| Apply Conditional Formatting to Dates | |
| Apply Conditional Formatting to Entire Column | |
| Apply Conditional Formatting to Multiple Rows | |
| Conditional Format Greater Than Or Less Than | |
| Conditional Formatting Based on Another Cell | |
| Conditional Formatting Based on Date in Another Cell | |
| Conditional Formatting Dates Overdue | |
| Conditional Formatting Formulas Not Working | |
| Conditional Formatting Grayed Out | |
| Conditional Formatting If Between Two Numbers | |
| Conditional Formatting If Cell Contains Any Text | |
| Conditional Formatting If Cell Contains Specific Text | |
| Conditional Formatting Not Equal | |
| Conditional Formatting Tips for 2022 | |
| Conditional Formatting with Multiple Conditions (And) | |
| Copy Conditional Formatting | |
| Highlight a Cell if a Specific Value Exists in Another Column | |
| Highlight Blank Cells (Conditional Formatting) | |
| Highlight Cells If (Conditional Formatting) | |
| Highlight Cells That Begin (Or End) With | |
| Highlight Duplicate Rows | |
| Highlight Duplicate Values | |
| Highlight Every Other Line In Excel | |
| Highlight Rows If (Conditional Formatting) | |
| Highlight Rows That Contain | |
| Highlight the Highest Value | |
| If Formula to Set Cell Color w/ Conditional Formatting | |
| Insert Harvey Balls | |
| Remove Conditional Formatting | |
| Use Comparison Icon Sets | |
| Use Conditional Formatting With a Checkbox | |
| Use Custom Icon Sets | |
| Copy & Paste | yes |
| Apply Formula to Entire Column (Copy Down) | |
| Copy a Cell From Another Sheet | |
| Copy and Paste a Range or Object as a Picture | |
| Copy and Paste an Exact Formula | |
| Copy and Paste as Text or Value | |
| Copy and Paste Cells | |
| Copy and Paste With Skip Blanks | |
| Copy and Paste Without Borders | |
| Copy and Paste Without Changing the Format | |
| Copy Data From One Cell to Another Automatically | |
| Copy Every Other Row | |
| Copy Number Not Formula | |
| Duplicate Rows | |
| Freeze Random Numbers | |
| Paste & Match Destination Formatting | |
| Paste Excel Table into Gmail | |
| Paste Horizontal Data Vertically | |
| Rearrange Columns | |
| Swap Cells | |
| Swap or Move Columns | |
| Transpose Rows to Columns | |
| Data Validation | yes |
| Add a ToolTip | |
| Create an Input Message | |
| Data Validation Based on Another Cell | |
| Enable Error Alert | |
| Find Restricted Values | |
| Restrict Cell Values | |
| Set a Character Limit | |
| Validate Phone Number Format | |
| Database | yes |
| Clean Up Data | |
| Create a Searchable Database | |
| Drop-Down List | yes |
| Add a Drop-Down List With Color Formatting | |
| Alphabetize a Drop Down List | |
| Create a Cascading Drop-Down List | |
| Create a Default Value for a Drop-Down List | |
| Create a Drop-Down List | |
| Create a Drop-Down List Filter | |
| Create a Yes / No Drop Down | |
| Drop-Down List With If Statement | |
| Make Drop Down Categories and Subcategories | |
| Remove a Drop-Down List | |
| Update a Drop-Down List | |
| Duplicates | yes |
| Clear Duplicate Cells | |
| Combine Duplicate Rows | |
| Merge Lists Without Duplicates | |
| Prevent Duplicate Entries | |
| Remove Both Duplicates | |
| Remove Duplicate Rows | |
| Remove Unique Values | |
| Show Only Duplicates | |
| Email | yes |
| Email a Spreadsheet | |
| Email Address Format Validation | |
| Send Email With Formula (No Macros!) | |
| Send Mass Email From a List | |
| Filters | yes |
| Apply Multiple Filters | |
| Clear All Filters | |
| Copy Filtered (Visible) Data | |
| Delete Filtered Rows | |
| Filter by Color | |
| Filter Duplicate Values | |
| Filter Merged Cells | |
| Filter Rows | |
| Hide Blank Rows | |
| Hide Rows Based on Cell Value | |
| Horizontal Filter | |
| Remove Filters | |
| Show or Hide AutoFilter Arrows | |
| Show Rows With Specific Text | |
| Use Custom AutoFilters | |
| Find & Select | yes |
| Deselect Cells | |
| Find and Delete Words | |
| Find and Highlight | |
| Find and Replace Multiple Values | |
| Find and Select Specific Cells | |
| Find Blank Cells | |
| Find Errors | |
| Find Merged Cells | |
| Find Unique Values | |
| Fix Excel Find Not Working | |
| Highlight Blank Cells | |
| Highlight Multiple Rows | |
| Jump to a Row With Go To | |
| Remove Asterisks (*) | |
| Replace Blank Cells With Zeros | |
| Replace Space with Underscore | |
| Search All Sheets | |
| Select All Cells With Values | |
| Select Every Other Row | |
| Select Multiple Cells | |
| Select Non-Adjacent Cells or Columns | |
| Use Go To Special | |
| Use the Go To Command to Jump to a Cell | |
| Forecast | yes |
| Add Goal Seek to Google Sheets | |
| Automatically Vary the Contents of a Cell | |
| Calculate the Break-Even Analysis Point | |
| Calculate Total Revenue | |
| Do a Sensitivity / What-If Analysis | |
| Enable Solver Add-In | |
| Insert Line and Column Sparklines | |
| Install the Data Analysis Toolpak for PC & Mac | |
| Quick Analysis Tool | |
| Format Cells | yes |
| Add Lines (Borders) | |
| Alternate Row Color | |
| Apply and Change Themes | |
| Apply Cell Styles | |
| Automatic Formatting | |
| Cell Margins | |
| Change Gridline or Cell Border Color | |
| Change the Cell Background Color | |
| Clear All Formatting | |
| Copy Cell Color | |
| Copy Column Widths | |
| Copy Row Height | |
| Make All Rows and Columns the Same Height and Width | |
| Merge and Center Cells | |
| Merge Multiple Cells | |
| Outline Cells (Apply All Borders) | |
| Resize Cells to Default Row Height | |
| Resize Multiple Rows or Columns at Once | |
| Split a Cell Diagonally | |
| Unmerge Cells | |
| Use Format Painter for Multiple Cells | |
| Format Text | yes |
| Add and Remove Strikethrough | |
| Bold Lines | |
| Center Across Selection | |
| Change Alignment | |
| Create a Bulleted List | |
| Create Barcodes | |
| Go Down to the Next Line | |
| Hide Overflow Text in a Cell | |
| Increase Indent | |
| Make Cells Bigger to Fit Text | |
| Make Subscripts and Superscripts | |
| Rotate Text in a Cell | |
| Shrink to Make Text Fit | |
| Two Lines in One Cell | |
| Underline Text | |
| Use Line Spacing | |
| Use Word Wrap | |
| Write Paragraphs | |
| Write Text Vertically | |
| X Out a Cell | |
| Formula Auditing | yes |
| #REF Error | |
| Allow Circular References | |
| Camera Tool | |
| Find a Circular Reference Error | |
| Fix the #NAME? Error | |
| Formula View Mode | |
| Get Rid of Green Triangle | |
| Get Rid of the Red Triangle in Google Sheets | |
| Hide All Dependency Tracer Arrows at Once | |
| Hide Precedent Tracer Arrows | |
| Ignore All Errors | |
| Insert Functions With Dialog Box | |
| Show Dependent Tracer Arrows | |
| Show Precedent Tracer Arrows | |
| Use Formula AutoComplete | |
| Use the Error Checking Command | |
| Watch Window | |
| Insert & Delete | yes |
| Clear Cell Contents | |
| Delete a File | |
| Delete Blank Columns | |
| Delete Blank Rows | |
| Delete Cells and Shift Cells Left | |
| Delete Cells and Shift Cells Up | |
| Delete Every Other Column | |
| Delete Every Other Row | |
| Delete Hidden Rows and Columns | |
| Delete Infinite Rows or Columns | |
| Delete Multiple Cells | |
| Delete Multiple Rows or Columns | |
| Delete Rows if Cell Contains Specific Text | |
| Delete Rows with Blank Cells | |
| Insert Blank Row | |
| Insert Blank Row | |
| Insert Cells and Shift Cells Down | |
| Insert Cells and Shift Cells Right | |
| Insert Timestamp | |
| Reset the Last Cell | |
| Links | yes |
| Break All Links | |
| Create a Hyperlink | |
| Cross-Reference | |
| Find External Links | |
| Hyperlink to Another Sheet or Workbook | |
| Link Files | |
| Mirror Cells by Linking | |
| Update Links Automatically | |
| Miscellaneous | yes |
| 32-bit vs. 64-bit Office - Which do I have? What's the Difference? | |
| Change Author Property | |
| Change Cell Size in Pixels or Inches | |
| Change Document Properties | |
| Clear the Cache | |
| Customize the Ribbon | |
| Excel Cannot Open or Save Any More Documents | |
| Find the Last Saved Date | |
| Generate All Permutations | |
| Make a File Smaller | |
| Merge Multiple Workbooks into One | |
| Open Files in New Windows | |
| Show the Formula Bar | |
| Show the Toolbar | |
| Take a Screenshot | |
| What is the Formula Bar? | |
| Name Manager | yes |
| Create Range Names From Selection | |
| Delete Named Range(s) | |
| Edit Named Ranges | |
| Find the Location of a Named Range | |
| Paste Range Names | |
| Resolve a Name Conflict for a Named Range | |
| Use the Name Box | |
| What are Name Manager and Name Box? | |
| Number Formats | yes |
| Add a Plus Sign for Positive | |
| Add More Decimal Places | |
| Add Percentage Style to a Number | |
| Add Units to Numbers | |
| Apply Accounting Number Format | |
| Convert Date to Month and Year | |
| Convert Decimal to Fraction | |
| Display Fraction Without Reducing | |
| Format Phone Numbers With Dashes | |
| Format Time to Milliseconds | |
| Get Rid of the Dollar Sign | |
| Hide / Suppress Zeros | |
| Limit Decimal Places | |
| Make Negative Numbers Red | |
| Mask Data Input | |
| Move Decimal Places | |
| Number Format in Millions | |
| Number Format in Thousands (000s) | |
| Pad Numbers (Add Leading Zeros) | |
| Prevent Rounding | |
| Remove Decimals | |
| Remove Scientific Notation | |
| Round Numbers Without a Formula | |
| Stop Changing Numbers to Dates | |
| Use Scientific Notation | |
| Objects | yes |
| Add and Group Radio (Option) Buttons | |
| Change the Color of an ActiveX Control Button | |
| Circle Something | |
| Create a Shape With Drawing Tools | |
| Create a Slider Bar | |
| Delete a Checkbox | |
| Draw Lines | |
| Embed a File | |
| Insert a Digital Signature | |
| Insert a Drop-Down Calendar With Date Picker Control | |
| Insert a Logo | |
| Insert a Shape | |
| Insert a SmartArt Graphic | |
| Insert a Text Box | |
| Insert an Arrow | |
| Insert Multiple Checkboxes | |
| Insert Multiple Hyperlinks in One Cell | |
| Link a Text Box | |
| Make a Combo Box | |
| Organize Sheets | yes |
| Add Multiple Worksheets | |
| Copy a Spreadsheet | |
| Copy Multiple Sheets to a New Workbook | |
| Count Number of Worksheets | |
| Delete Multiple Tabs | |
| Delete Worksheets | |
| Group and Ungroup Worksheets | |
| Hide and Unhide Worksheets | |
| Insert a New Tab | |
| Merge Two Spreadsheets into One | |
| Pull Data From Multiple Sheets and Consolidate | |
| Rename a Worksheet | |
| Select Multiple Sheets | |
| Separate (Split) Sheets | |
| View a List of Worksheet Tabs | |
| View Two Sheets at Once | |
| Outline | yes |
| Collapse an Outline to Show Just the Subtotals | |
| Create an Outline | |
| Create Auto Outline | |
| Expand or Collapse Rows or Columns | |
| Group Cells | |
| Page Layout | yes |
| |
| Change Orientation to Landscape | |
| Define Print Titles on Every Page | |
| |
| |
| |
| Make a Sheet Fit on One Page | |
| What is the Page Setup Function? | |
| How to Create a Cover Page in Excel & Google Sheets | |
| Pictures | yes |
| Drag and Drop Pictures | |
| Insert a Background Image | |
| Insert a Picture into a Cell | |
| Insert a Picture into a Cell Automatically | |
| |
| Insert Pictures | |
| Make a Picture Transparent | |
| Remove All Pictures From a Workbook | |
| Show a MouseOver Picture | |
| Power Query | yes |
| How to Export Folder and Subfolder Structure | |
| Import an HTML Table | |
| Set Up Automatic Currency Conversion | |
| Print | yes |
| Add a Page Border | |
| Add a Watermark | |
| Center Worksheets Horizontally and Vertically | |
| Delete Unwanted or Blank Pages | |
| Display & Print Formulas | |
| Hide Page Breaks | |
| Insert a Page Number | |
| Insert and Remove Page Breaks | |
| Make Graph Paper | |
| Print a Background Image | |
| Print All Tabs in a Workbook | |
| |
| Print Gridlines on a Blank Sheet | |
| Print Only Selected Cells | |
| Print Row Numbers and Column Headings | |
| Print Selected Worksheets on One Page | |
| Print Selected Worksheets Without Print Preview | |
| Print Two Sheets on One Page | |
| Remove Watermarks | |
| Set the Print Area | |
| Proofing | yes |
| Check Spelling | |
| Disable Automatic Hyperlinks | |
| Remove Hyperlinks | |
| Stop AutoCorrect | |
| Turn On or Change AutoCorrect | |
| Protect | yes |
| Change a Read Only File | |
| Hide Formulas | |
| Lock a Sheet for Viewing | |
| Lock Cells | |
| Lock Column Width and Row Height | |
| Lock Formatting | |
| Mark a Workbook as Final | |
| Password Protect a File | |
| Protected View: Turn Off and Enable Editing | |
| Remove a Password From a File | |
| Unlock / Unprotect Cells | |
| Unprotect a Workbook | |
| Save As | yes |
| Change the Default Directory | |
| Convert a CSV File to XLSX | |
| Convert a Spreadsheet to a Delimited Text File | |
| Convert an Excel File to Google Sheets | |
| Convert to a Pipe Delimited Text File | |
| Copy Entire Workbook | |
| Create a Word Document | |
| Embed Tables into HTML | |
| Export a File to PDF | |
| Import a Word Document | |
| Open a Text (.txt) File | |
| Open Old XLS Files | |
| Rename a File | |
| Save a File as CSV | |
| Save a File as CSV With UTF-8 Encoding | |
| Save a File to the Old Format (.xls) | |
| Save a Macro-Enabled Workbook | |
| Save a Table as an Image | |
| Save File as Read-Only | |
| Save Just One Sheet | |
| Save Multiple Sheets as a PDF | |
| Save Workbook as PDF | |
| What is the Difference Between CSV Files and Excel Files? | |
| How to Recover a Deleted Sheet in Excel & Google Sheets | |
| Share Files | yes |
| Make a Shared Spreadsheet for Multiple Users | |
| Track Changes | |
| Unshare a Workbook | |
| Use Document Inspector | |
| Sort Data | yes |
| Advanced Sorting | |
| Keep Rows Together During Sort | |
| Put Things in Alphabetical Order | |
| Random Sort | |
| Reverse the Order of Data | |
| Sort a Column Alphabetically | |
| Sort and Ignore Blanks | |
| Sort by Color (Highlighted Cells) | |
| Sort by Last Name | |
| Sort By Month | |
| Sort By Number | |
| Sort Dates in Chronological Order | |
| Sort IP Addresses | |
| Sort Multiple Columns | |
| Sort Multiple Rows Horizontally | |
| Sort Subtotals | |
| Sort With a Custom List | |
| Sort Without Duplicates | |
| Undo a Sort | |
| Symbols | yes |
| Add Bullet Points | |
| Division Sign | |
| Find and Replace Question Marks and Asterisks | |
| Insert a Check Mark (Tick) | |
| Insert Bitcoin Symbol | |
| Insert Cent Symbol | |
| Insert Cross Text Symbol | |
| Insert Delta Symbol | |
| Insert Euro Symbol | |
| Insert Plus or Minus Symbol | |
| Insert Pound Symbol | |
| Insert Rupee Symbol | |
| Insert Signs and Symbols | |
| Insert Sum Symbol | |
| Insert Yen Symbol | |
| Star Symbol | |
| What Do the Symbols (@,$,{, etc.) Mean in Formulas? | |
| Tables | yes |
| Add a Column and Extend a Table | |
| Add a Total or Subtotal Row to a Table | |
| Compare Two Tables | |
| Convert a Table to a Normal Range | |
| Display Data With Banded Rows | |
| Remove a Table or Table Formatting | |
| Rename a Table | |
| Rotate Data Tables (Row to Column) | |
| Text to Columns | yes |
| Convert a String to a Date | |
| Paste CSV Data into Columns | |
| Separate Numbers / Values | |
| Split a Cell into Two or More Columns | |
| Split a Text Cell to Two or More Rows | |
| Use a Line Break in Text to Columns | |
| Use Text to Columns to Parse Data | |
| View | yes |
| |
| Dark Mode | |
| Enable and Disable Smart Tags | |
| Get Rid of Dashed Print Area Lines | |
| Hide and Unhide Rows and Columns | |
| Hide and Unhide Workbooks | |
| Hide Column and Row Headings | |
| Hide Unused Cells | |
| Hide Vertical and Horizontal Scroll Bars | |
| Lock Columns | |
| Lock the Top Row When Scrolling | |
| Remove Page Number in Preview Mode | |
| Return to Normal View | |
| Show and Hide Gridlines | |
| Show or Hide ScreenTips | |
| Show the Ruler | |
| Use Split Screen | |
| View Full Screen | |
| Zoom In or Out | |
| Excel Built-in Charts | yes |
| Column Charts: Stacked, Clustered | |
| Bar Charts: Stacked, Clustered | |
| Area Charts | |
| Line Charts | |
| Candlestick Charts | |
| Pareto Chart | |
| Waterfall Chart | |
| Sales Funnel Chart | |
| |
| Advanced Custom Charts | yes |
| Gauge / Dial Chart | |
| Tornado Chart | |
| Burndown Chart | |
| Step Chart | |
| Thermometer Chart | |
| Quadrant Chart | |
| Bullet Chart | |
| Ogive Chart | |
| Bell Curve / Normal Distribution Plot | |
| Stem & Leaf Chart | |
| Mekko Chart | |
| Venn Diagram | |
| Polar Plot | |
| Venn Diagram | |
| Panel Chart | |
| Timeline Chart | |
| Progress Charts | |
| Sales Funnel Chart | |
| Floating Bar Chart | |
| Forest Plot | |
| Frequency Polygon | |
| Arrow Chart | |
| Percentage Graph | |
| Time Series Graph | |
| Percentage Change Chart | |
| Show Percentage in Pie Chart | |
| Dot Plot | |
| Q-Q Plot | |
| Log-Log Plot | |
| Normal Probability Plot | |
| Charts Tips & Tricks | yes |
| Add or Move Data Labels | |
| Add Data Series | |
| Add Average Line | |
| Add Data Points | |
| Add Error Bars | |
| Add Gridlines | |
| Add Line of Best Fit | |
| Add Title | |
| Break Chart Axis | |
| Calculate Area Under Curve | |
| Plot Residuals | |
| Change Bar Chart Width | |
| Change Chart Colors | |
| Chart Axis Text Instead of Numbers | |
| Copy Chart Format | |
| Create Chart with Date or Time | |
| Curve Fitting | |
| Export Chart as PDF | |
| Add Axis Labels | |
| Add Secondary Axis | |
| Change Chart Series Name | |
| Change Horizontal Axis Values | |
| Create Chart in a Cell | |
| Graph an Equation or Function | |
| Overlay Two Graphs | |
| Plot Multiple Lines | |
| Rotate Pie Chart | |
| Switch X and Y Axis | |
| Insert Textbox | |
| Move Chart to New Sheet | |
| Move Horizontal Axis to Bottom | |
| Move Vertical Axis to Left | |
| Remove Gridlines | |
| Reverse a Chart | |
| Rotate a Chart | |
| Rounded Corners or Shadows | |
| Create, Save, & Use Excel Chart Templates | |
| Dynamic Chart Titles | |
| Chart Conditional Formatting | |
| Dynamic Chart Range | |
| Animated Charts | |
| Interactive / Dynamic Charts | |
