Skip to main content

Spreadsheets General

Spreadsheets General Articles

Spreadsheets are programs that organize information in rows and columns, making it straightforward to store data, perform calculations, and spot patterns. People use them for everything from household budgets to small business inventory to tracking personal projects. You might land here because you're wondering whether a spreadsheet is the right tool for what you're trying to do, or because you want to understand what spreadsheets can actually handle.

These articles explain what spreadsheets do well and where they fall short compared to other tools. You'll learn when a spreadsheet makes sense for your situation, when a different program would work better, and how to recognize the limits before you've invested time building something that won't work the way you need it to.

Spreadsheets General

100 articles

Spreadsheets GeneralChanging Date Format in Excel to MM/DD/YYYYRead more →Spreadsheets GeneralHow to Use the Fill Handle in Excel to Copy Formulas and DataRead more →Spreadsheets GeneralHow to Use Advanced Filter in Excel to Find Exactly What You NeedRead more →Spreadsheets GeneralHow to Break Text Into Multiple Lines Within a Single Excel CellRead more →Spreadsheets GeneralHow to Create a Drop-Down Menu in ExcelRead more →Spreadsheets GeneralHow to Create Charts in ExcelRead more →Spreadsheets GeneralHow to Spell Check in ExcelRead more →Spreadsheets GeneralHow to Delete a Column in ExcelRead more →Spreadsheets GeneralHow to Add a Line in ExcelRead more →Spreadsheets GeneralHow to Use the "Does Not Equal" Sign in ExcelRead more →Spreadsheets GeneralHow to Add Borders to Cells in ExcelRead more →Spreadsheets GeneralHow to Add a Checkbox in ExcelRead more →Spreadsheets GeneralHow to Add a Column in ExcelRead more →Spreadsheets GeneralHow to Create a Dropdown List in ExcelRead more →Spreadsheets GeneralHow to Add and Use Filters in Excel to Sort Your DataRead more →Spreadsheets GeneralHow to Add a Header Row in ExcelRead more →Spreadsheets GeneralHow to Add a Leading Zero in ExcelRead more →Spreadsheets GeneralHow to Insert a New Row or Column in ExcelRead more →Spreadsheets GeneralHow to Add a New Column in ExcelRead more →Spreadsheets GeneralHow to Password-Protect an Excel FileRead more →Spreadsheets GeneralHow to Add a Percentage to a Number in a SpreadsheetRead more →Spreadsheets GeneralHow to Add a Row in ExcelRead more →Spreadsheets GeneralHow to Add a Watermark to an Excel SpreadsheetRead more →Spreadsheets GeneralHow to Add Cells and Rows in ExcelRead more →Spreadsheets GeneralHow to Add Columns in Excel and Organize Your DataRead more →Spreadsheets GeneralHow to Add Columns in Google SheetsRead more →Spreadsheets GeneralHow to Add and Format Dates in ExcelRead more →Spreadsheets GeneralHow to Add Different Cells Together in ExcelRead more →Spreadsheets GeneralHow to Create Drop-Down Lists in ExcelRead more →Spreadsheets GeneralHow to Add Filters in Excel So You Can Sort and Find Data FasterRead more →Spreadsheets GeneralHow to Add Numbers in ExcelRead more →Spreadsheets GeneralHow to Add a Column in ExcelRead more →Spreadsheets GeneralHow to Add Numbers in Google SheetsRead more →Spreadsheets GeneralHow to Add Lines and Borders in ExcelRead more →Spreadsheets GeneralHow to Add Rows and Columns to an Excel SpreadsheetRead more →Spreadsheets GeneralHow to Add Multiple Cells Together in ExcelRead more →Spreadsheets GeneralHow to Add Multiple Rows in ExcelRead more →Spreadsheets GeneralHow to Add Page Numbers to Your Excel SpreadsheetRead more →Spreadsheets GeneralHow to Calculate Percentage Increase in ExcelRead more →Spreadsheets GeneralHow to Calculate Percentages in ExcelRead more →Spreadsheets GeneralHow to Change Text Case in ExcelRead more →Spreadsheets GeneralHow to Make Columns Wider or Narrower in ExcelRead more →Spreadsheets GeneralHow to Change Date Format in ExcelRead more →Spreadsheets GeneralConverting Text Between Uppercase and Lowercase in ExcelRead more →Spreadsheets GeneralFinding and Removing Duplicate Entries in ExcelRead more →Spreadsheets GeneralHow to Convert Text That Looks Like Numbers Into Actual Numbers in ExcelRead more →Spreadsheets GeneralHow to Copy a Formula in ExcelRead more →Spreadsheets GeneralHow to Create a Drop-Down List in ExcelRead more →Spreadsheets GeneralHow to Copy and Paste a Formula in Excel Without Breaking Your DataRead more →Spreadsheets GeneralHow to Copy and Paste in ExcelRead more →Spreadsheets GeneralHow to Create a Dropdown List in ExcelRead more →Spreadsheets GeneralHow to Create a Graph in Excel From Your DataRead more →Spreadsheets GeneralHow to Create a Hyperlink in ExcelRead more →Spreadsheets GeneralHow to Write Your First Excel FormulaRead more →Spreadsheets GeneralHow to Create a Pivot Table in Excel or Google SheetsRead more →Spreadsheets GeneralHow to Create a Pivot Table in ExcelRead more →Spreadsheets GeneralHow to Create a Schedule in ExcelRead more →Spreadsheets GeneralHow to Create a Title in ExcelRead more →Spreadsheets GeneralHow to Delete a Formula in Excel Without Losing Your DataRead more →Spreadsheets GeneralHow to Delete an Excel File on Your ComputerRead more →Spreadsheets GeneralHow to Remove a Sheet from Your Excel SpreadsheetRead more →Spreadsheets GeneralHow to Delete a Pivot Table in Excel and Google SheetsRead more →Spreadsheets GeneralHow to Delete a Row in ExcelRead more →Spreadsheets GeneralHow to Delete a Sheet in Excel Without Losing Your DataRead more →Spreadsheets GeneralHow to Remove Blank Rows in ExcelRead more →Spreadsheets GeneralHow to Delete Cells in Excel Without Losing Your DataRead more →Spreadsheets GeneralHow to Delete Columns in ExcelRead more →Spreadsheets GeneralHow to Find and Remove Duplicate Rows in ExcelRead more →Spreadsheets GeneralHow to Delete Rows and Columns in ExcelRead more →Spreadsheets GeneralHow to Delete Sheets in Excel Without Losing Your DataRead more →Spreadsheets GeneralHow to Filter a Column in ExcelRead more →Spreadsheets GeneralHow to Filter Data in Excel So You See Only What You NeedRead more →Spreadsheets GeneralHow to Find and Fix Circular References in ExcelRead more →Spreadsheets GeneralHow to Add Up a Column in ExcelRead more →Spreadsheets GeneralHow to Group and Ungroup Cells in ExcelRead more →Spreadsheets GeneralHow to Group and Hide Columns in Excel to Organize Your DataRead more →Spreadsheets GeneralHow to Group Rows and Columns in ExcelRead more →Spreadsheets GeneralHow to Group Worksheets Together in ExcelRead more →Spreadsheets GeneralHow to Merge Cells in Excel and When It Actually HelpsRead more →Spreadsheets GeneralHow to Merge Cells in Excel and When It Actually HelpsRead more →Spreadsheets GeneralHow to Combine Text From Multiple Columns in ExcelRead more →Spreadsheets GeneralHow to Combine Data from Multiple Excel Sheets Into OneRead more →Spreadsheets GeneralHow to Move a Column in ExcelRead more →Spreadsheets GeneralHow to Add a Column of Numbers in ExcelRead more →Spreadsheets GeneralHow to Create a Drop-Down List in ExcelRead more →Spreadsheets GeneralHow to Add a New Line in ExcelRead more →Spreadsheets GeneralHow to Add a Total Row to an Excel SpreadsheetRead more →Spreadsheets GeneralHow to Add Bullet Points and Lists in ExcelRead more →Spreadsheets GeneralHow to Add Bullet Points in ExcelRead more →Spreadsheets GeneralHow to Add Cells Together in ExcelRead more →Spreadsheets GeneralHow to Enter and Format Dates in ExcelRead more →Spreadsheets GeneralHow to Create Drop-Down Lists in ExcelRead more →Spreadsheets GeneralHow to Create a Drop-Down Menu in ExcelRead more →Spreadsheets GeneralHow to Add Rows and Columns in ExcelRead more →Spreadsheets GeneralHow to Add Lines and Borders in Excel SpreadsheetsRead more →Spreadsheets GeneralHow to Add Numbers in Excel ColumnsRead more →Spreadsheets GeneralHow to Add Numbers in ExcelRead more →Spreadsheets GeneralAdding a Secondary Axis to Your Excel ChartRead more →Spreadsheets GeneralHow to Add Solver to Excel and Use It to Find AnswersRead more →Spreadsheets GeneralHow to Add Error Bars Showing Standard Deviation in ExcelRead more →