Data in spreadsheets
Answer-first guides for Data in Excel and Google Sheets, each with a tool you can run. 1640 topics across 170 sub-topics.
guides
How to Remove Duplicates in ExcelHow to Create a Drop Down List in ExcelExcel Drop Down ListHow to Find Duplicates in ExcelHow to Highlight Duplicates in ExcelHow to Add Drop Down List in ExcelCreate Dropdown in ExcelHow to Identify Duplicates in ExcelHow to Add Drop Down in ExcelHow to Delete Duplicates in ExcelHow to Remove Blank Rows in ExcelHow to Check Duplicates in Excel
Sub-topics
Main sub-topics (10+ guides)
30
Drop-down Lists144
How to Create a Drop Down List in ExcelExcel Drop Down ListHow to Add Drop Down List in ExcelCreate Dropdown in ExcelHow to Add Drop Down in ExcelHow to Insert Drop Down in ExcelHow to Create a Drop Down in ExcelHow to Create a Drop Down Menu in ExcelHow to Edit Drop Down List in ExcelHow to Change Drop Down List in ExcelHow to Insert Drop Down List in ExcelHow to Remove Drop Down List in Excel
BrowseCells496
Excel Find DoublesExcel Documentation PDFHow to Use Sort in ExcelConvert Text to ExcelHow to Find the Intersection of Two Datasets in ExcelHow to Find MODE in ExcelHow Can I Sort Alphabetically in ExcelChuyển PDF Sang ExcelHow to Find an Excel File That Was DeletedHow to Find Z Value in ExcelHow to Remove Grid in ExcelHow to Sort Numbers in Excel
BrowseRemove Duplicates62
How to Remove Duplicates in ExcelHow to Delete Duplicates in ExcelHow to Remove the Duplicate Values in ExcelHow to Delete Repeats in ExcelDuplicates in ExcelHow to Remove Duplicate Rows in ExcelHow to Remove Duplicate Records in ExcelDelete Duplicate Rows in ExcelDeleting Duplicates in ExcelHow to Get Rid of Duplicates in ExcelHow to Search for Duplicates in ExcelSelect Duplicates in Excel
BrowseFind Duplicates32
How to Find Duplicates in ExcelHow to Identify Duplicates in ExcelHow to Check Duplicates in ExcelShow Duplicates in ExcelExcel Find Duplicates in ColumnIdentifying Duplicates in ExcelHow to Find Duplicate Cells in ExcelHow to Find Duplicate Values in ExcelHow to Find Duplicate Entries in ExcelHow to Look for Duplicates in ExcelLook for Duplicates in Excel ColumnHow to Find Duplicates in Excel Entire Workbook
BrowseRemove Blank Rows19
How to Remove Blank Rows in ExcelHow to Remove Empty Rows in ExcelHow to Delete Blank Rows in ExcelHow to Delete Empty Rows in ExcelRemove Blanks ExcelHow to Delete Blank Lines in ExcelExcel Delete Empty LinesHow to Delete All Blank Rows in ExcelHow to Remove All Blank Rows in ExcelHow to Delete All Empty Rows in ExcelRemove Leading Blanks in ExcelHow to Remove All Empty Rows in Excel
BrowseRecover Unsaved File52
How to Recover Unsaved Excel FileRecover Excel FileHow to Recover Deleted Excel FilesHow to Recover Corrupted Excel FileHow to Recover Overwritten Excel File on MacHow to Restore Excel FileHow Do I Recover an Excel File I DeletedHow to Find Unsaved Excel FileHow to Recover Excel File Not SavedHow to Recover Excel File That Is CorruptedHow to Restore Deleted Excel FileHow to Recover a Deleted Excel Sheet
BrowsePivot Table66
Excel Pivot a Pivot TableCalculated Fields in Pivot Table from Pivot Fields ExcelHow to Refresh Pivot Table in ExcelHow to Update a Pivot Table in ExcelHow to Make a Pivot Table ExcelHow to Delete a Pivot Table in ExcelHow to Edit Pivot Table in ExcelHow to Remove Pivot Table in ExcelHow to Modify a Pivot Table in ExcelExcel Pivot Table Format All RowsExcel Pivot Table Show Total at BottomExcel Pivot Table Calculated Field
BrowseFn VLOOKUP37
VLOOKUP Multiple CriteriaVLOOKUP Two SheetsVLOOKUP Multiple ColumnsINDEX MATCH vs VLOOKUPReverse VLOOKUPVLOOKUP Another WorkbookExcel VLOOKUP from Another SheetHow to Do VLOOKUP in Excel with Two SpreadsheetsVLOOKUP with IF StatementVLOOKUP Return Multiple ValuesHLOOKUP vs VLOOKUPNested VLOOKUP
BrowseSort Data30
How to Sort by Date in ExcelHow to Sort Columns in ExcelHow to Sort by a Column in ExcelHow to Sort Data in ExcelHow to Sort the Dates in ExcelHow to Sort Data in Excel by DateExcel Sortable ColumnsSorting by Date in ExcelHow to Sort by Last Name in ExcelHow to Sort Multiple Columns in ExcelHow to Sort Two Columns in ExcelExcel Sort Multiple Columns That Have Formulas
BrowseCOUNT Duplicates15
COUNT UNIQUE Values ExcelExcel COUNT UNIQUECounting UNIQUE Values in ExcelCOUNT Duplicates in ExcelCOUNT Per UNIQUE Value ExcelExcel Formula COUNT UNIQUE Values in Range FREQUENCYExcel COUNT UNIQUE Values in ColumnCOUNT Number of UNIQUE Values in ExcelExcel COUNT UNIQUE Text ValuesCOUNT Duplicate Values in ExcelCounting Duplicates in ExcelCOUNT UNIQUE Cells Excel
BrowseRemove Spaces19
How to Remove Spaces in ExcelDelete Spaces in ExcelExcel Remove Leading SpacesExcel Remove Trailing SpacesExcel Remove Spaces Before TextDelete Extra Spaces in ExcelHow to Remove Spaces in Excel After TextHow to Remove Blank Spaces in ExcelHow to Remove Space from ExcelExcel Remove WhitespaceDelete Blank Spaces ExcelExcel Delete Leading Spaces
BrowsePDF to Excel20
How to Save PDF as ExcelPDF to Excel SpreadsheetImport PDF to ExcelCan You Convert a PDF to ExcelHow to Add a PDF to ExcelCan You Change a PDF to ExcelCopy Table from PDF to ExcelWhy Can't I Add a Pdfx to Excel SpreadsheetImport Data from PDF to ExcelBank Statement PDF to ExcelHow to Copy and Paste from PDF to ExcelBest Way to Convert PDF to Excel
BrowseCombine Workbooks18
Merge Excel FilesHow to Merge Multiple Excel FilesMerge Multiple Excel Files Into One SheetHow to Join Excel FilesHow to Merge Several Excel FilesHow to Consolidate Excel Files Into OneMerge Multiple Excel Files Into One FileMerge Several Excel Files Into OneExcel Merge Files Into One WorkbookHow to Merge Two Excel FilesMerge Multiple Excel Files to OneHow Do I Merge 2 Excel Files
BrowseColumns23
How to FILTER a Column in ExcelExcel Convert Rows Into ColumnsExcel Comparing Two Columns for MatchesExcel Matching 2 ColumnsExcel Move Values to Column and Sort Alphabetically FunctionExcel Move Values to Column and Sort AlphabeticallyMatching Two Columns of Data in ExcelPower Automate Excel Select FILTER for ColumnsHow to Convert Column Data to Row in ExcelHow to MATCH Data in Two Columns in ExcelExcel FILTER Multiple ColumnsExcel Convert Column to Number
BrowseDelete Rows10
How to Delete Rows in ExcelHow to Remove a Row in ExcelHow to Delete Lines in ExcelHow to Delete Multiple Rows in ExcelExcel Delete Row KeyboardDeleting Lines in ExcelHow to Delete a Row from ExcelKeystroke to Delete Row in ExcelHow to Delete Extra Lines in ExcelExcel Delete Rows with Specific Text
BrowseRepair File14
Excel Crashing When Open Files from Mapped DriveRepair Excel File OnlineHow to Open Corrupted Excel FileRepair Corrupted Excel FileRepair Damaged Excel File OnlineHow to Fix Corrupted Excel FileExcel Cannot Open the FileCorrupt Excel FileRepair Corrupt Excel FileExcel Cannot Open the File Because the File FormatHow to Open a Corrupt Excel FileExcel Cannot Open Because the File Format Is Not Valid
BrowseFilters13
How to Add a FILTER in ExcelHow to Remove FILTER in ExcelHow to Add Filtering in ExcelHow to Create a FILTER in ExcelHow to Insert FILTER in ExcelHow to Add Drop Down FILTER in ExcelHow to Use Advanced FILTER in ExcelHow to Delete FILTER in ExcelHow to Add a FILTER to a Column in ExcelHow to Remove Autofilter in ExcelHow to Create a Drop Down FILTER in ExcelHow to Create an Advanced FILTER in Excel
BrowseCSV to Excel21
How to Convert CSV to ExcelCSV File Format to ExcelHow to Change CSV to ExcelHow to Change CSV Format to ExcelHow to Open CSV File in ExcelExcel Function to Import Data from a CSV LinkFormat CSV ExcelInsert CSV ExcelHow to Change a CSV File to ExcelExcel CSV FileHow to Import a CSV File Into ExcelHow to Save a CSV File to Excel
BrowseFn UNIQUE12
Excel UNIQUE FunctionExcel UNIQUE Values in ColumnUNIQUE Formula in ExcelUNIQUE Values from Multiple ColumnsExcel UNIQUE ValuesExcel SUM by UNIQUE ValueExcel List UNIQUE ValuesFILTER UNIQUE Values ExcelGet UNIQUE Values in Column ExcelSUM UNIQUE Values ExcelExcel List UNIQUEExcel UNIQUE Rows
BrowseCompare Sheets10
Compare Two Excel FilesCompare Excel FilesHow to Compare 2 Excel FilesCompare Excel Files for DifferencesCompare Two Excel Files for DifferencesCompare 2 Excel Files for DifferencesHow to Compare Two Excel Sheets for MatchesHow to Compare Two Excel Sheets for DuplicatesCompare Two Excel Files for MatchesHow to Compare Two Excel Worksheets to Find the Differences
BrowseRows19
Remove Identical Rows in ExcelHow to Sort Alphabetically in Excel and Keep Rows TogetherHow to Delete Hidden Rows in ExcelDeleting Excel RowsRemove Redundant Rows in ExcelHow to Sort Rows in ExcelShow All Row Groups in Excel FILTER Morethan 1000000How to Delete Extra Rows in ExcelDelete Filtered Rows in ExcelExcel FILTER RowsHow to Delete Excess Rows in ExcelHow to Delete Unused Rows in Excel
BrowseExcel to PDF11
How to Change Excel to PDFHow Do You Save an Excel File as a PDFHow Do You Save a Excel File to PDFHow Can I Convert Excel to PDFHow to Save Excel Sheet as PDFExport to PDF ExcelHow to Turn Excel Into PDFHow to Turn an Excel Sheet Into a PDFSaving Excel to PDFExcel Print as PDFExcel Print to PDF
BrowseTxt to Excel10
Convert Text File to ExcelText File to ExcelHow to Open Text File in ExcelHow to Import Text File Into ExcelHow to Open a Txt File in ExcelHow to Import Text File to ExcelTxt File to ExcelConvert Text File in ExcelImport a Txt File Into ExcelHow to Insert a Text File Into Excel
BrowseDuplicates22
Excel Erase DuplicatesDeleting Duplicate Lines in ExcelHow to Duplicate an Excel FileExcel Duplicate RowsExcel Exclude DuplicatesDuplicate Lines in ExcelDuplicate Values in ExcelHow to Duplicate a Cell in ExcelClear Duplicates ExcelExcel Getting Rid of DuplicatesDuplicate Column ExcelExcel Function Duplicates
BrowseFormulas14
Sort Function Excel FormulaFunction Find in ExcelExcel Formulas Cheat Sheet PDFExcel Formula Find All WildcardMs Excel Formula to FILTER Values Within Time RangeExcel Function Similar to Importdata for Google SheetsExcel Query FunctionHow Do I Find the Absolute Delta with Excel FormulaExcel Formula Converter OnlineBody Mass INDEX Formula ExcelAdvanced Excel Functions PDFDelete Function in Excel
BrowseFiltering23
Excel FILTER Multiple ConditionsExcel When FILTER Is on How to Copy and PasteHow to FILTER by Date in ExcelHow to FILTER Dates in ExcelHow to Remove FILTER from ExcelMultiple Filters in ExcelHow to Remove Filtering in ExcelHow to Remove All Filters in ExcelHow to Remove Auto Filters in ExcelHow to FILTER Multiple Values in ExcelHow to FILTER Excel SheetFiltering Shortcuts Excel
BrowseWord to Excel11
Convert Word to ExcelHow to Convert Excel to WordExport Word Doc to ExcelExport Word Document to ExcelImport Word Doc Into ExcelImport Word Document Into ExcelExport Word File to ExcelHow to Export from Word to ExcelExporting Word to ExcelImport Word File Into ExcelImport Word to Excel
BrowseFn MATCH18
How to Use MATCH Function in ExcelExcel MATCH Multiple CriteriaExcel Formula Find Any MATCH in TableWhivch Number Is Exact MATCH ExcelHow to Use MATCH Formula in ExcelExcel Check IF Two Cells MATCHExcel Formula to See IF Two Cells MATCHHow to MATCH Data in ExcelExcel Fuzzy MATCH FormulaExcel Partial Text MATCHExcel MATCH TextMATCH Words in Excel
BrowseSheets & Workbooks16
How to Convert Google Spreadsheet to ExcelHow to Open an Excel File in Google SheetsMake Spreadsheet Form File Names in ExcelHow to Delete Sheets from ExcelHow to Delete Multiple Sheets in ExcelHow to Find in Excel SheetDeleting a Worksheet in ExcelHow to Make an Excel Spreadsheet Into a PDFGoogle Spreadsheet to Excel ExportHow to Save Excel Workbook as PDFDeleting a Sheet in ExcelFind Links in Excel Workbook
BrowseExcel to Google Sheets10
How to Convert Excel to Google SheetsHow to Convert Google Sheets to ExcelExport Google Sheet to ExcelImport Excel Into Google SheetsHow to Export Google Sheets to ExcelHow to Export from Google Sheets to ExcelHow to Upload an Excel File to Google SheetsHow to Upload Excel File to Google DocsHow to Import an Excel File Into Google SheetsHow to Import Excel to Google Sheets
BrowseSmaller sub-topics (2–9 guides)
70
Highlight Duplicates9
How to Highlight Duplicates in ExcelMark Duplicates in ExcelExcel Highlight Duplicates in ColumnHighlighting Duplicates in ExcelMarking Duplicates in ExcelHighlight Duplicate Values in ExcelHighlight Duplicate Cells in ExcelHighlight Duplicate Rows in ExcelHighlight Duplicate Entries in Excel
BrowseErr Circular3
How to Find Circular References in ExcelExcel Find Circular ReferenceHow to Remove Circular References in Excel
BrowseFn INDEX MATCH7
Excel INDEX MATCH Multiple CriteriaHow to Use INDEX MATCH in ExcelINDEX MATCH Two CriteriaHow to Use INDEX and MATCH in ExcelINDEX MATCH Multiple ColumnsMATCH and INDEX Function in ExcelExcel INDEX and MATCH Multiple Criteria
BrowsePower Query7
Power Query TutorialCan Ms Excel Online Use Power QueryUnpivot Data Power QueryMerge Queries Power QueryCan I Save an Excel Power Query to IdeHow to Unpivot Data in ExcelUnpivot Excel Table
BrowseFn XLOOKUP9
XLOOKUP vs VLOOKUPXLOOKUP Multiple CriteriaXLOOKUP Two ColumnsXLOOKUP Return Multiple ValuesXLOOKUP Multiple SheetsHow to Use XLOOKUP Function in ExcelXLOOKUP with IFXLOOKUP HorizontalHow to Use XLOOKUP Excel
BrowseDependent Dropdown6
Dependent Drop Down ListConditional Drop Down List ExcelDependent Drop Down Menu ExcelDependent Drop Down in ExcelDependent Dropdown Lists in ExcelLinked Drop Down List Excel
BrowseMulti Select Dropdown9
Multi Select DropdownExcel Drop Down List Multiple SelectionDrop Down Menu Excel Multiple SelectionExcel Multi Select Drop DownSelect Multiple Dropdown ExcelExcel Multiple Selection Drop DownExcel Multiple Selection DropdownExcel Drop Down Select MultipleExcel Data Validation Multiple Selections
BrowseInsert PDF9
Insert PDF Into ExcelImport PDF Into ExcelHow to Insert PDF in ExcelHow to Attach PDF in ExcelHow to Embed a PDF in ExcelEmbed a PDF Into ExcelHow to Put PDF in ExcelCan You Insert a PDF Into ExcelHow to Add a PDF to an Excel Sheet
BrowseText to Number7
How to Convert Text to Number in ExcelConvert to Number ExcelConverting Text to Number ExcelConvert from Text to Number in ExcelConvert Numbers Stored as Text Into Numerals ExcelExcel Convert Text to Number FunctionExcel Mass Convert to Number
BrowseDuplicate Sheet4
How to Duplicate a Sheet in ExcelDuplicating Sheets in ExcelHow to Duplicate Excel WorksheetHow to Duplicate a Tab in Excel
BrowseCompare Columns9
Compare 2 Columns in Excel for MatchesHow to MATCH Two Columns in ExcelCompare Columns in Excel for MatchesHow to Compare Two Columns in Excel for MatchesHow to MATCH 2 Columns in ExcelCompare Two Columns in Excel for MATCHExcel Compare Two Columns for Matches and HighlightHow to Compare Two Columns in Excel for DuplicatesMATCH Columns in Excel
BrowseRemove Table4
Excel Remove TableHow to Delete a Table in ExcelDelete Table Format ExcelHow to Remove a Table from Excel
BrowseRemove HYPERLINK8
How to Remove HYPERLINK in ExcelRemoving Hyperlinks from ExcelDelete HYPERLINK in ExcelRemove a Link in ExcelHow to Delete Links in ExcelHow to Remove Links from ExcelHow to Remove Linking in ExcelRemove All Hyperlinks Excel
BrowseReduce File Size8
How to Reduce Excel File SizeCompress Excel FileHow to Decrease Excel File SizeHow to Shrink Excel File SizeHow to Minimize Excel File SizeExcel Reducing File SizeMAX File Size for ExcelCompress Excel File Size
BrowsePivot Distinct COUNT6
Excel Pivot Table COUNT DistinctExcel Pivot Table COUNT UNIQUEDistinct COUNT in Excel PivotCOUNT UNIQUE in Excel PivotExcel Pivot Table COUNT UNIQUE ValuesCOUNT UNIQUE Values Excel Pivot
BrowseFn FILTER4
FILTER Excel FormulaFILTER Function Multiple CriteriaHow to Use FILTER Function in ExcelExcel FILTER Function Not Working
BrowseEmbed File Object6
How to Embed a File in ExcelInsert File in ExcelInsert File Into ExcelAttach File in ExcelHow to Embed a File Into ExcelHow to Attach File Into Excel
BrowseTranspose Data4
Excel Convert Row to ColumnHow to Convert from Rows to Columns in ExcelConverting Excel Columns to RowsExcel Pivot Columns to Rows
BrowsePage Breaks7
How to Delete a Page in ExcelHow to Delete a Page from ExcelHow to Remove Page 1 Watermark in ExcelHow to Remove a Page in ExcelHow to Remove a Page from ExcelHow to Remove Page 1 Watermark from ExcelHow to Remove Page 1 from Excel
BrowseSlicers5
How to Add a Slicer in ExcelInsert Slicer ExcelSlicer for TableHow to Use Slicer in ExcelHow to Create a Slicer in Excel
BrowseShare Workbook4
How to Share an Excel FileHow to Share an Excel File for EditingHow to Share an Excel File for Multiple UsersHow to Unshare an Excel File
BrowseExcel to CSV8
How to Convert Excel to CSVPower Automate Excel to CSV Keep Dates in OrderHow to Create a CSV File in ExcelHow to Save Excel as CSV FileHow to Save Excel File to CSV FormatHow Do I Create a CSV File from ExcelHow to Export a CSV File from ExcelSaving an Excel File as a CSV
BrowseSUM8
How to Find SUM in ExcelAdding Drop Down List in ExcelExcel SUM Only Filtered CellsExcel SUM Filtered DataHow to SUM Filtered Cells in ExcelExcel SUM of Filtered ColumnAdding Drop Down Box in ExcelAdding Drop Down Options in Excel
BrowseTime to Decimal5
Convert Time to Decimal ExcelConvert Hours to Decimal in ExcelConverting Hours to Decimals in ExcelConverting Time to Decimal ExcelConvert Excel Time to Decimal Hours
BrowseRead Only5
How to Make an Excel File Read OnlyHow to Remove Read Only from ExcelExcel Read Only RemoveHow to Open Excel File Read OnlyHow to Open an Excel File as Read Only
BrowseAVERAGE3
How to Find the Mean in ExcelCalculate Running AVERAGE in Power Query ExcelHow to Find Mean MEDIAN and MODE in Excel
BrowseExcel to JSON5
Convert JSON to ExcelConvert Excel to JSONHow to Open JSON File in ExcelExcel Convert JSONJSON File to Excel
BrowsePassword Protect File6
How to Encrypt Excel FileExcel File EncryptionHow to Remove Encryption from ExcelHow to Unencrypt Excel FileExcel Encrypted FileRemove Excel Encryption
BrowseRemove Formula4
How Do I Delete a Formula in ExcelExcel Convert Formula to ValueDeleting Formulas in ExcelConverting Formulas to Values in Excel
BrowseXML to Excel4
Convert XML to ExcelHow to Open XML File in ExcelConvert Excel to XMLHow to Import a XML File Into Excel
BrowseFn Slope INTERCEPT5
How to Find Slope on ExcelHow to Find Y INTERCEPT in ExcelHow to Find INTERCEPT in ExcelHow to Find Slope of a Line in ExcelHow to Find Slope and INTERCEPT in Excel
BrowseLists5
Anylist Export Lists to ExcelHow to Export Contact List from Outlook 2021 to ExcelExcel Compare Two Lists for MatchesExport SharePoint List to ExcelExport List from SharePoint to Excel
BrowseComments Notes7
How to Delete Comment in ExcelHow to Remove Comments in ExcelDelete All Comments in ExcelDeleting Comments in ExcelExcel Remove All CommentsHow to Remove Comments from ExcelHow to Delete Notes in Excel
BrowseCalculate Age4
Excel Formula to Find AgeConvert Date of Birth to Age in ExcelConvert Date to Age in ExcelHow to Convert a Birthdate to Age in Excel
BrowseFREQUENCY Table3
How to Find FREQUENCY in ExcelHow to Find Relative FREQUENCY in ExcelHow to Find Cumulative FREQUENCY in Excel
BrowseExternal Links4
Find External Links in ExcelHow to Remove External Links in ExcelHow to Find Links to Other Workbooks in ExcelExcel Find Broken Links
BrowseDate Serial4
Convert 45443 Excel Date to Mm/dd/yyyyExcel Convert Number to DateExcel Converting Number to DateConvert Date Into Number in Excel
BrowseFile Extensions3
Extensions for Excel FilesExcel File Format or File Extension Not ValidExcel File Format or Extension Is Not Valid
BrowseFn Date Parts4
Convert Date to Month and Year in ExcelExcel Convert Month Name to NumberConvert Date Into Month and Year in ExcelConvert Mm/dd/yyyy to Month and Year in Excel
BrowseBlank Cells4
How to Remove Blank Pages in ExcelHow to Delete Multiple Blank Rows in ExcelExcel Find BlanksHow to Delete a Blank Page in Excel
BrowsePage Setup5
How to Delete Extra Pages in ExcelConvert Webpage to ExcelExcel Remove Extra PagesWebpage to Excel ConverterDeleting a Page in Excel
BrowseTrendline4
How to Find Regression Line in ExcelHow to Find Line of Best Fit on ExcelHow to Find Least Squares Regression Line in ExcelHow to Find Equation of Line in Excel
BrowseTabs4
How to Delete Multiple Tabs in ExcelFile Tab ExcelWhere Is the File Tab in Excel on MacDeleting Tabs in Excel
BrowseSub-topics with one guide
70
New guides and tools, once a month
DE + EN · double opt-in · no spam