| AutoFill | yes |
| AutoFill Custom and Alphabetic Lists | |
| AutoFill Dates or Months | |
| AutoFill Numbers | |
| AutoFill Numbers Without Dragging | |
| Auto-Number Rows in a Column | |
| Fill Column With the Same Value | |
| Make a List of Numbers | |
| Turn Off AutoFill | |
| 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 | |
| Calculation | yes |
| Add Values to Cells and Columns | |
| Anchor a Cell | |
| Change the Signs of Values | |
| Divide Cells and Columns | |
| Imaginary Numbers | |
| Keep Variable Cell Constant | |
| Lock 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 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 Cell Value | |
| Conditional Formatting Based on Date | |
| Conditional Formatting Based on Formula | |
| 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 Not Equal | |
| Conditional Formatting Tips | |
| Conditional Formatting With Multiple Conditions | |
| Copy Conditional Formatting | |
| Edit Conditional Formatting | |
| Formatting If Cell Contains Specific Text | |
| Highlight a Cell if Specific Value Exists in Another Column | |
| Highlight Blank Cells | |
| Highlight Cells If | |
| Highlight Cells That Begin or End With | |
| Highlight Duplicate Rows | |
| Highlight Duplicate Values | |
| Highlight Entire Row | |
| Highlight Every Other Line In Excel | |
| Highlight Rows If | |
| Highlight Rows That Contain | |
| Highlight the Highest Value | |
| If Formula to Set Cell Color | |
| Insert Harvey Balls | |
| Remove Conditional Formatting | |
| Use Comparison Icon Sets | |
| Use Conditional Formatting With Checkbox | |
| Use Custom Icon Sets | |
| Copy & Paste | yes |
| Copy a Cell From Another Sheet | |
| Copy a Page | |
| 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 Columns | |
| Copy and Paste Formulas Between Excel and Google Sheets | |
| Copy and Paste Hyperlinks | |
| Copy and Paste Merged Cells | |
| Copy and Paste With Skip Blanks | |
| Copy and Paste Without Borders | |
| Copy and Paste Without Changing the Format | |
| Copy Cell Formatting | |
| Copy Data From One Cell to Another Automatically | |
| Copy Every Other Row | |
| Copy Formula Down to Entire Column | |
| Copy Number Not Formula | |
| Copy Value to Another Cell With Formula | |
| Drag and Drop | |
| Duplicate Rows | |
| Freeze Random Numbers | |
| Paste and Match Destination Formatting | |
| Paste Horizontal Data Vertically | |
| Paste Into Filtered Cells | |
| Rearrange Columns | |
| Replace Formula With Value | |
| Swap Cells | |
| Swap or Move Columns | |
| Transpose Rows to Columns | |
| Data Validation | yes |
| 10 Data Validation Rules and Techniques | |
| Add a ToolTip | |
| Change Data Validation | |
| Clear Data Validation | |
| Copy Data Validation | |
| Create an Input Message | |
| Data Validation Based on Another Cell | |
| Date and Time Data Validation Formats | |
| Enable Error Alert | |
| Find Restricted Values | |
| Ignore Blanks in Data Validation | |
| 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 Drop-Down List With Color Formatting | |
| Alphabetize a Drop-Down List | |
| AutoComplete With Data Validation | |
| Change 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 or No Drop Down | |
| |
| Create Dynamic Drop Down From Table | |
| Data Validation Unique Values | |
| Drop Down Populates Another Cell | |
| 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 | |
| Count Duplicate Values Only Once | |
| Distinct (Unique) Values | |
| Duplicates | |
| Find Duplicate Values | |
| Merge Lists Without Duplicates | |
| Paste Unique Values | |
| Prevent Duplicate Entries | |
| Remove Both Duplicates | |
| Remove Duplicate Rows | |
| Remove Unique Values | |
| Show Only Duplicates | |
| Email | yes |
| Copy Email Addresses to Outlook | |
| Email a Spreadsheet | |
| Email Address Format Validation | |
| Embed a File | |
| Send Email With Formula | |
| Send Mass Email From a List | |
| Filters | yes |
| Advanced Filter | |
| Apply Multiple Filters | |
| Clear All Filters | |
| Copy Filtered Data | |
| Delete Filtered Rows | |
| Filter by Color | |
| Filter by Date | |
| Filter Duplicate Values | |
| Filter Merged Cells | |
| Filter Rows | |
| Filter Unique Values | |
| Hide Blank Rows | |
| Hide Rows Based on Cell Value | |
| Horizontal Filter | |
| Remove Filters | |
| Save Filtered Data | |
| Show or Hide AutoFilter Arrows | |
| Show Rows With Specific Text | |
| Use Custom AutoFilters | |
| Find & Select | yes |
| Deselect Cells | |
| Fill Blank Cells With Value Above | |
| Find and Delete Words | |
| Find and Highlight | |
| Find and Replace Multiple Values | |
| Find and Replace With Wildcards | |
| Find and Select Specific Cells | |
| Find Blank Cells | |
| Find Errors | |
| Find Merged Cells | |
| Find Unique Values | |
| Highlight Blank Cells | |
| 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 Analysis | |
| Enable Solver Add-In | |
| Insert Line and Column Sparklines | |
| Install the Data Analysis Toolpak for PC and Mac | |
| Quick Analysis Tool | |
| Remove Solver | |
| Solve for a Variable | |
| Format Cells | yes |
| Add Border Lines | |
| Alternate Row Color | |
| Apply and Change Themes | |
| Apply Cell Styles | |
| Apply the Calculation Style | |
| AutoFit Columns | |
| 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 | |
| Highlight Columns | |
| Highlight Rows | |
| Make All Rows and Columns the Same Height and Width | |
| Make Merged Cells the Same Size | |
| Merge and Center Cells | |
| Merge Multiple Cells | |
| Outline Cells | |
| Remove Fill Color | |
| 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 | |
| Line Spacing | |
| 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 | |
| Word Wrap | |
| Write Paragraphs | |
| Write Text Vertically | |
| X Out a Cell | |
| Formula Auditing | yes |
| Allow Circular References | |
| Camera Tool | |
| Find a Circular Reference Error | |
| Formula View Mode | |
| 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 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 Highlighted Cells | |
| 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 After Every Other Row | |
| Insert Cells and Shift Cells Down | |
| Insert Cells and Shift Cells Right | |
| Insert Multiple Rows and Columns | |
| 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 Versus 64-Bit Office | |
| Change Author Property | |
| Change Cell Size in Pixels or Inches | |
| Change Document Properties | |
| Clear the Cache | |
| Customize the Ribbon | |
| Delete a File | |
| Find the Last Saved Date | |
| Find What Version of Excel You Have | |
| Generate All Permutations | |
| Insert Timestamp | |
| Make a File Smaller | |
| 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 | |
| Dynamic Named Range Based on Cell | |
| Edit Named Ranges | |
| Find the Location of 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 Zeros | |
| Insert Dates | |
| Limit Decimal Places | |
| Make Negative Numbers Red | |
| Mask Data Input | |
| Move Decimal Places | |
| Number Format in Millions | |
| Number Format in Thousands | |
| Pad Numbers With 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 Buttons | |
| Add Gradient Fill to Shapes or Cells | |
| 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 | |
| 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 | |
| Insert Toggle Button | |
| Link a Text Box | |
| Make a Combo Box | |
| Make a Number Line | |
| Select Objects | |
| 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 Multiple Workbooks Into One | |
| Merge Two Spreadsheets Into One | |
| Move Sheets | |
| Pull Data From Multiple Sheets and Consolidate | |
| Rename a Worksheet | |
| Select Multiple Sheets | |
| Separate Sheets | |
| View a List of Worksheet Tabs | |
| 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 | |
| Create Cover Page | |
| Define Print Titles on Every Page | |
| |
| |
| |
| Make a Sheet Fit on One Page | |
| Scale to Fit Page Size | |
| Set Custom Page Size | |
| What is the Page Setup Function? | |
| 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 | |
| Pivot Table | yes |
| Add Calculated Field to Pivot Table | |
| Advanced Pivot Table Techniques | |
| Change Pivot Table Data Source | |
| Count Unique Values With Pivot Table | |
| Create Pivot Table | |
| Delete Pivot Table | |
| Filter Pivot Table Values | |
| Get a Count in Pivot Table | |
| Group Pivot Table by Date | |
| Keep Pivot Table Formatting | |
| Make a Pivot Table Chart | |
| Pivot Table Slicers | |
| Pivot Table Sorting Guide | |
| Refresh a Pivot Table | |
| Remove Field From Pivot Table | |
| Power Query | yes |
| Export Folder and Subfolder Structure | |
| Import an HTML Table | |
| Import XML Files | |
| Set Up Automatic Currency Conversion | |
| Print | yes |
| Add a Page Border | |
| Add a Watermark | |
| Center Worksheets Horizontally and Vertically | |
| Change Print Area | |
| Clear Print Area | |
| Delete Unwanted or Blank Pages | |
| Display and Print Formulas | |
| Hide Page Breaks | |
| Insert a Page Number | |
| Insert and Remove Page Breaks | |
| Make Graph Paper | |
| Print | |
| Print a Background Image | |
| Print a Chart or Graph | |
| Print All Tabs in a Workbook | |
| |
| Print Gridlines on a Blank Sheet | |
| Print Multiple Sheets | |
| Print Only Selected Cells | |
| Print Preview | |
| 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 | |
| Show 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 | |
| Protect Workbook Structure | |
| Protected View: Turn Off and Enable Editing | |
| Remove a Password From a File | |
| Unlock Cells | |
| Unprotect 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 File | |
| Open Old XLS Files | |
| Recover Deleted Sheet | |
| Rename a File | |
| Save a File as CSV | |
| Save a File as CSV With UTF-8 Encoding | |
| Save a File to the Old Format | |
| 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? | |
| Share Files | yes |
| Make a Shared Spreadsheet for Multiple Users | |
| Track Changes | |
| Unshare a Workbook | |
| Use Document Inspector | |
| Shortcuts | yes |
| Go To Cell, Row, or Column Shortcuts | |
| Sort Data | yes |
| Advanced Sorting | |
| Keep Rows Together During Sort | |
| Put Things in Alphabetical Order | |
| Random Sort | |
| Reverse the Order of Data | |
| Sort and Ignore Blanks | |
| Sort by Last Name | |
| Sort By Month | |
| Sort By Number | |
| Sort Data | |
| Sort Dates in Chronological Order | |
| Sort Highlighted Cells by Color | |
| 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 | |
| Escape Double Quotes | |
| Find and Replace Question Marks and Asterisks | |
| Insert a Check Mark | |
| 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 Mean in Formulas? | |
| Tables | yes |
| Add a Column and Extend a Table | |
| Add a Total or Subtotal Row to a Table | |
| Add Rows to Table | |
| Center Table | |
| Change Table Style | |
| Compare Two Tables | |
| Convert a Table to a Normal Range | |
| Convert Data to Table | |
| Copy and Paste Table | |
| Copy Table From Word | |
| Copy to Word and Fit Page | |
| Create Floating Table | |
| Create Lookup Table | |
| Create Table | |
| Display Data With Banded Rows | |
| Flip a Table | |
| Link Tables | |
| Make Columns Sortable | |
| Move Table | |
| Paste Excel Table Into Gmail | |
| Remove a Table or Table Formatting | |
| Rename a Table | |
| Rotate Data Tables | |
| Table Tools | |
| Types of Tables | |
| Text to Columns | yes |
| Convert String to Date | |
| Paste CSV Data Into Columns | |
| Separate Numbers | |
| 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 | |
| Troubleshooting | yes |
| #REF Error | |
| Advance Filter Not Working | |
| All the Merged Cells Need to Be the Same Size | |
| Command Cannot be Used on Multiple Selections | |
| Data Validation Not Working | |
| Excel Borders Not Printing | |
| Excel Cannot Open or Save Any More Documents | |
| Excel Cannot Paste the Data Error | |
| Excel Not Sorting Numbers Correctly | |
| Fill Series Not Working | |
| Find Broken Links | |
| Fix Excel Find Not Working | |
| Fix the #NAME? Error | |
| Formula Won't Calculate | |
| Get Rid of Green Triangle | |
| Get Rid of the Red Triangle in Google Sheets | |
| Loading Solver Not Working | |
| Printing Problems | |
| Printing Too Small | |
| Resolve a Name Conflict for a Named Range | |
| Solver Encountered Error Value | |
| The Pivot Table Field Name Is Not Valid | |
| There Isn't Enough Memory to Complete This Action | |
| Unlock a File Locked for Editing by Me | |
| Waiting for OLE Action Error | |
| What to Do When Excel Keeps Crashing or Freezing | |
| Why is AutoSave Not Working or Grayed Out? | |
| View | yes |
| |
| Dark Mode | |
| Enable and Disable Smart Tags | |
| Freeze and Unfreeze Panes | |
| 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 | |
| |
| View Two Sheets at Once | |
| Zoom In or Out | |
