Workflow in spreadsheets
Answer-first guides for Workflow in Excel and Google Sheets, each with a tool you can run. 1876 topics across 425 sub-topics.
guides
Excel Row Insert Shortcut KeyKeyboard Shortcut for Inserting Rows in ExcelMultiple IF Statements in ExcelHow Can We Merge Two Columns in ExcelExcel Shortcuts Cheat SheetRemove Table Formatting ExcelHow to Use IF Function in ExcelStrikethrough Shortcut ExcelExcel Remove Format as TableHow to Change Date Format in ExcelNested IF FormulaHow to Copy a Formula in Excel
Sub-topics
Main sub-topics (10+ guides)
18
Cells903
How to Change Collum Names in ExcelHow Do You Change Excel to Not Quto FilUpload Excel Refresh Copy Path ColabMap Table Excel DataExcel Inventory TemplateHow to Organize Excel by DateMeeting Minutes Template in Excel with Project Schedule TemplateHow to Change Date Settings in ExcelExcel Date DifferentExcel Itinerary TemplateNumber of Months Between Two Dates ExcelTracked Changes Excel
BrowseFn IF59
How to Use IF Function in ExcelMultiple IF Then Statements in ExcelExcel IF Cell Contains TextIF Function Excel - Multiple ConditionsIF Cell Is BlankIF Then ElseExcel IF Cell BlankExcel Formula IF Cell Contains Specific TextIF Cell Empty ExcelExcel IF Cell Is EmptyExcel IF Statement with Multiple ConditionsCOUNT IF Formula in Excel
BrowseSheets & Workbooks46
How to Copy an Excel WorkbookSample Balance Sheet Format ExcelBalance Sheet Format in ExcelGet Excel Sheet Dynamically Power AutomateGet Excel Sheet Programatically Power AutomateGet Excel Sheet Programmatically Power AutomateHow to Change Look of Excel SpreadsheetHow to Compare Data in Two Excel SheetsFree Debt Snowball Spreadsheet Excel Free DownloadHow Can I Separate My Excell Workbook from SharePoint UpdatesHow to Make a Copy of an Excel WorkbookOpen Source Option Tracker Excel Spreadsheet Free Download
BrowseSubtract18
Date Subtract in ExcelHow to Subtract Two Dates in ExcelSubtract Time in ExcelExcel Date Minus DateSubtracting Dates in ExcelDate Subtraction ExcelHow to Subtract Date from Date in ExcelSubtracting Time in ExcelExcel Difference Between Two TimesExcel Subtract Days from DateHow to Subtract Time from Time in ExcelHow to Minus Time in Excel
BrowseFn TODAY NOW23
Excel Today's DateHow to Insert Dates in Excel AutomaticallyCurrent Date in ExcelInsert Current Date in ExcelHow to Insert Date in ExcelInsert Today's Date in ExcelHow to Put Date in ExcelExcel Enter Today's DateHow to Put Today's Date in ExcelHow to Put Dates Into ExcelHow to Input Date in ExcelDate Stamp in Excel
BrowseDuplicate Sheet16
How to Make a Copy of an Excel SheetHow to Copy a Sheet in ExcelHow to Copy a Worksheet in ExcelHow to Make a Copy of an Excel SpreadsheetHow to Copy and Paste Excel SheetHow to Copy Sheet in Excel to Another WorkbookHow to Copy Paste Excel SheetHow to Copy a Tab in ExcelHow to Copy Spreadsheets in ExcelHow to Copy Data from One Excel Sheet to AnotherHow to Copy from One Excel Sheet to AnotherHow to Copy One Excel Sheet to Another
BrowseTranspose Data13
Change Rows to Columns in ExcelHow to Transpose Excel DataHow to Transpose Columns to Rows in ExcelHow to Transpose a Table in ExcelHow to Switch Rows and Columns in ExcelExcel Transpose FunctionChange from Row to Column in ExcelWhy Can't I Transpose Paste in ExcelHow to Transpose Columns and Rows in ExcelHow to Switch Rows to Columns in ExcelExcel Transpose Rows Into ColumnsExcel Transpose Formula
BrowseChange Date Format17
How to Change Date Format in ExcelShort Date Format ExcelExcel Format DateExcel Changing Date FormatStop Excel from Auto Formatting DatesHow to Change Date Format in Excel to Mm/dd/yyyyHow to Reformat a Date in ExcelHow to Apply Short Date Format in ExcelLong Date Format ExcelDate Format Not Changing in ExcelCustom Date Format in ExcelExcel Date Format Won't Change
BrowseCopy Formula10
How to Copy a Formula in ExcelHow to Copy and Paste Formulas in ExcelHow to Copy Formula Down in ExcelExcel Copy Values NOT FormulaCopying a Formula in ExcelHow to Copy Numbers in Excel Without FormulaHow to Copy Exact Formula in ExcelExcel Formulas Not Copying DownCopy Formula in Excel Without Changing ReferencesHow to Copy Values in Excel Without Formula
BrowseCase Converter12
Change Case in ExcelLetter Case Change in ExcelExcel Change Text CaseChange to Title Case ExcelChange Font Case in ExcelIn Excel How to Change All Caps to Camel CaseChange to All Caps in ExcelHow to Change Text to All Caps in ExcelChange Caps in ExcelChanging Case in ExcelTest Case Template ExcelHow to Change Font to All Caps in Excel
BrowseFormulas28
Excel Formula IF ContainsExcel Date Formula TODAYExcel Formula Date to MonthExcel Formulas to Change All Large Cap to StandardExcel to Table Function Power AutomateFormula for Change in ExcelChange the Font in a Concantonate Formula in ExcelExcel Copy Function DownIF Excel Function with TextHow Do I Format Fonts with a Formula in ExcelExcel Formula with IF Across an ArrayExcel Formula to Change Font
BrowseCOUNT12
Excel COUNT IF Not BlankHow to Do COUNT IF on ExcelExcel COUNT IF Multiple CriteriaExcel COUNT IF Greater Than 0How Many Tabs Can You Have in ExcelExcel COUNT IF ContainsCOUNT IF Greater Than ExcelCOUNT IF Less Than ExcelCOUNT IF Contains Partial Text ExcelExcel COUNT IF ColorDo Accountants Use ExcelExcel Templates for Accountants
BrowseWhat If Analysis13
What If AnalysisOne Variable Data Table ExcelTwo Variable Data Table Excel2 Variable Data Table ExcelHow to Use Data Table in ExcelExcel Single Variable Data TableExcel What If Analysis Data TableHow to Do a Data Table in Excel2 Way Data Table ExcelHow to Delete a Data Table in ExcelExcel What If Data TableHow to Use Data Table Function in Excel
BrowseFn Date Parts17
Excel Get Month from DateExtract Month from Date in ExcelExcel Formula for Month from DateExcel Return Month from DateExcel Get Year from DateExtract Year from Date in ExcelExcel Month Name from DateExtract Month and Year from Date in ExcelExcel Get Month Name from DateHow to Remove Year from Date in ExcelChange Date to Month and Year in ExcelGet Month and Year from Date in Excel
BrowseLists15
Wedding Guest List Template ExcelUpload Excel to SharePoint List That Already Has DataGrocery Shopping List Template ExcelGrocery List Template ExcelExcel IF in ListInventory List Template ExcelPunch List Template ExcelShopping List Template ExcelGuest List Template ExcelVendor List Template ExcelPrice List Format ExcelChore List Template Excel
BrowseColumns10
How to Switch Columns in ExcelHow to Change Row Data to Column in ExcelGet Excel File Column Names from Excel Power AutomateHow to Change Column Name in ExcelChanging Width of Columns in ExcelHow to Switch Two Columns in ExcelChange Column and Row in ExcelHow to Automatically Size Columns in ExcelChange Excel Columns to LettersHow to Change Order of Columns in Excel
BrowseSUM12
Adding Time in ExcelIF Command Excel with SUM FunctionAdding Months to Date in ExcelAdding Years to Date in ExcelHow to SUM Using ExcelFree Total Return Analysis ExcelExcel Formula for Adding Days to a DateAdding One Month to a Date in ExcelSUM Date Range ExcelExcel Shortcuts for SUMExcel Adding Times TogetherSUM by Date Excel
BrowseSmaller sub-topics (2–9 guides)
88
Remove Table Formatting5
Remove Table Formatting ExcelExcel Remove Format as TableHow to Remove Table Format in ExcelRemove Table Format from ExcelHow to Clear Table Format in Excel
BrowseIF Function5
Multiple IF Statements in ExcelMultiple IF ConditionsTwo IF Statements in ExcelHow to Do Multiple IF Statements in ExcelMultiple IF Statements in Excel with Text
BrowseINDIRECT Function6
INDIRECT Function ExcelINDIRECT Formula ExcelCalculate INDIRECT Cost Rate ExcelWhat Does the INDIRECT Function Do in ExcelExcel INDIRECT Another SheetExcel INDIRECT Table
BrowseFn DATEDIF8
Number of Days Between Two Dates ExcelDate Difference ExcelDifference Between Dates in ExcelExcel Difference Between Two DatesNo of Days Between Two Dates in ExcelFind Date Difference in ExcelHow to Compute Date Difference in ExcelExcel Date Difference in Months
BrowseClear Formatting6
How to Clear Formatting in ExcelHow to Clear Format in ExcelRemove Formatting ExcelRemove Format ExcelExcel Remove Formatting as TableClear Formating in Excel
BrowseCell Size Fit6
How to Change Row Height in ExcelHow to Change Column Width in ExcelExcel Automatically Adjust Row HeightExcel Automatic Row HeightExcel Automatic Column WidthAutomatically Adjust Column Width Excel
BrowseSc Fill Color4
Shortcut Key for Fill Colour in ExcelExcel Fill Color ShortcutExcel Highlight ShortcutShortcut for Highlighting in Excel
BrowseFn WEEKDAY6
Excel Day of Week from DateDate to Day of Week ExcelWrite Day of Week Based on Date in ExcelExcel Get Day of Week from DateFind Day of Week from Date in ExcelExcel Formula for Day of Week Based on Date
BrowseDate Picker5
Excel Date PickerDate Chooser in ExcelInsert Date Picker in ExcelDate Selector in ExcelInserting Date Picker in Excel
BrowseMac Shortcuts5
Mac Excel ShortcutsMacBook Excel ShortcutsExcel Shortcuts for MacBook AirExcel MacBook Keyboard ShortcutsKeyboard Shortcuts in Excel for Mac
BrowseSc Merge Cells Shortcut4
Merge and Center Shortcut ExcelExcel Merge Cells ShortcutExcel Merge Center Shortcut KeyShortcut for Merge in Excel
BrowseFormat Painter4
Format Painter ExcelHow to Copy Formatting in ExcelWhere Is Format Painter in ExcelWhat Is Format Painter in Excel
BrowseDrag Fill Autofill5
How to Use Autofill in ExcelHow to Use Fill Handle in ExcelHow to Autofill Dates in ExcelExcel Auto Fill DateHow to Use Auto Fill in Excel
BrowseAnalysis Toolpak7
Excel Data Analysis ToolpakHow to Install Data Analysis in ExcelHow Do I Get Data Analysis on ExcelHow to Enable Data Analysis in ExcelHow to Turn on Data Analysis in ExcelHow to Use Analysis Toolpak in ExcelActivate Data Analysis in Excel
BrowseNamed Range8
Named Range FormulaHow to Create a Named Range in ExcelExcel Delete Named RangeExcel Edit Named RangeExcel Dynamic Named RangeHow to Find a Named Range in ExcelWhat Is Named Ranges in ExcelExcel Manage Named Ranges
BrowseVBA Open VBA Editor8
How to Open VBA in ExcelHow to Open VBA Editor in ExcelHow to Open VBA from ExcelStart VBA ExcelDisplay VBA Code in ExcelHow to Get VBA on ExcelHow to See the VBA Code in ExcelHow to Show VBA Code in Excel
BrowseCalculate Age5
Excel Determine Age from Date of BirthExcel Get Age from Date of BirthHow to Find Age from Date of Birth in ExcelAge from Date of Birth ExcelAge Between Two Dates Excel
BrowseTime Difference5
Difference in Time ExcelHow to Get Time Difference in ExcelCompute Time Difference in ExcelExcel Hours Between Two TimesDate and Time Difference in Excel
BrowseRows9
Select Rows in Excel Until Value ChangesHow to Date Your Rows in Excel Easy WayHow to Copy a Row in ExcelHow to Switch Rows in ExcelChange Row Size in ExcelHow to Copy and Paste a Row in ExcelHow to Change Height of All Rows in ExcelHow to Switch Two Rows in ExcelExcel Merge Rows Without Losing Data
BrowseSc Switch Sheets9
Shortcut to Move Between Tabs in ExcelExcel Shortcut Switch SheetsExcel Tab Change ShortcutSwitch Sheet Excel ShortcutExcel Next Tab ShortcutExcel Next Sheet ShortcutExcel Switch Tabs ShortcutExcel Shortcut to Switch Between SheetsShortcut Excel Move Between Sheets
BrowseVBA Loops8
Excel VBA for LoopExcel VBA While LoopExcel VBA Do WhileExcel VBA WhileExcel VBA IF LoopExcel for Each VBAExcel VBA for Each LoopExcel VBA Break Loop
BrowseTabs8
Can You Use Arrow Keys to Swap Tabs in ExcelHow to Change Tab Color in ExcelData Tab ExcelData Analysis Tab in ExcelHow to Change Sheet Tab Color in ExcelHow to Change the Worksheet Tab Color in ExcelHow to Change Tabs in Excel Using KeyboardCan't See Tabs in Excel
BrowseRecover Unsaved File6
How Can I Recover Excel Corrupt FileExcel Data Recovery ToolExcel Data RecoveryExcel Data Recovery SoftwareHow Can I Recover Unsaved Excel DocumentCan You Recover a Deleted Excel File
BrowseAbsolute Reference3
How to Use Absolute Reference in ExcelHow to Make an Absolute Reference in ExcelHow to Make a Cell an Absolute Reference in Excel
BrowseRead Only5
How to Change Excel from Read OnlyHow to Change Excel File from Read OnlyHow Do I Change an Excel Document from Read OnlyHow to Change Read Only Excel FileExcel Read Only Change
BrowseVBA Run Macro5
How to Use Macros in ExcelHow to Run VBA Code in ExcelUses for Macros in ExcelUse VBA Code in ExcelHow to Execute VBA Code in Excel
BrowseImages4
Can You Get Date from a Picture in ExcelCopy Image with Tables for ExcelExcel Copy as ImageCopy as Picture Excel
BrowseData from Another Sheet3
How to Pull Data from Another Sheet in ExcelHow to Get Data from Another Sheet in ExcelHow to Use Data from Another Sheet in Excel
BrowseVBA Enable Macros4
How Can I Enable Macros in ExcelMacro Enabled Excel File TypeEnable Macros in Excel FileEnabling VBA in Excel
BrowseVLOOKUP3
Excel to Lookup Table Function Power AutomateCustomer Lookup Database Free ExcelHow Do I Use Lookup in Excel
BrowseCreate Calendar4
2024 Biweekly Payroll Calendar Template ExcelMarketing Calendar Template ExcelSocial Media Calendar Template ExcelChoose Date from Calendar Excel
BrowseDate Serial4
45443 Excel Date to Mm/dd/yyyyExcel Keeps Changing Number to DateExcel Date Number ConversionExcel Date to Number
BrowseVBA Macro Button5
How to Create a Macro Button in ExcelHow to Make a Macro Button in ExcelHow to Insert Macro Button in ExcelExcel Add Macro ButtonAdd Button in Excel to Run Macro
BrowseRegression Analysis4
Can You Do a Regression in ExcelExcel Data Analysis RegressionHow to Use Regression Analysis in ExcelHow to Use Regression in Excel
BrowseNumber Rows4
How to Automatically Number in ExcelHow to Automatically Number Rows in ExcelHow to Automatically Number Cells in ExcelHow to Automatically Number Columns in Excel
BrowseVBA IF Statement7
Excel VBA Else IFElseif Excel VBAExcel VBA IFExcel VBA IF AndVBA Excel IF StatementExcel VBA IF Then ElseExcel VBA IF Then
BrowseSc Copy4
Shortcut for Copy Format in ExcelCopy Formatting Excel ShortcutCopy and Paste Shortcut in ExcelCopy Paste Shortcut Excel
BrowseVBA What Is a Macro4
What Can Excel Macros DoWhat Is the Use of Macros in Excel with ExamplesExcel VBA MeaningWhat Is a Macro in Excel Used For
BrowseSub-topics with one guide
319
New guides and tools, once a month
DE + EN · double opt-in · no spam