How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Cell Background Image: What Works and What Doesn’tExcel does not provide a picture fill for an individual cell. For a decorative image across a worksheet, use Page Layout >…
- Excel Workbook vs Spreadsheet: What’s the Difference?An Excel workbook is the complete Excel file; a spreadsheet is the broader term for a grid-based document or the software used…
- Excel Cell Adjustment Shortcut: Resize Rows and ColumnsIn Excel for Microsoft 365 on Windows, use Alt, H, O, I to AutoFit a column to its contents, or Alt, H,…
- Excel Cell Auto Adjust: How to Fit Width and Row HeightTo auto-adjust cells in Excel for Microsoft 365 on Windows, select the column or row, then double-click the boundary on its header;…
- Excel Workbook Size Limit: Memory, File Size, and LimitsFor Excel for Microsoft 365 on Windows, there is no single fixed maximum file size for a modern .xlsx workbook: practical size…
- Excel Workbook vs Excel Binary Workbook: Key DifferencesAn Excel workbook is the general name for a spreadsheet file; an Excel Binary Workbook is one specific kind, saved with the…
- Excel Workbook Sheet Limit: What Sets the Maximum?Modern Microsoft Excel for Microsoft 365 on Windows has no fixed maximum number of sheets in a workbook: the practical limit is…
- Excel Workbook Shortcut Keys for Everyday TasksFor Excel for Microsoft 365 on Windows, the most useful workbook shortcuts are Ctrl+N to create a workbook, Ctrl+O to open one,…
- Excel Workbook Open: Opening Files and Fixing IssuesTo open an existing Excel workbook in Microsoft Excel for Microsoft 365 on Windows, start Excel and choose File > Open >…
- Excel Workbook Not Opening? Causes and Fixes for WindowsIf an Excel workbook will not open, first try opening Excel in Safe Mode, then use File > Open > Browse >…
- Excel Workbook Frozen? Causes, Checks, and FixesIf Excel seems frozen, first wait briefly and avoid clicking repeatedly; if it responds, save with Ctrl+S and check whether a long…
- Excel Workbook History: View, Compare, and Restore VersionsTo view Excel workbook history, open a workbook saved in OneDrive or SharePoint and choose File > Info > Version History in…
- Excel Workbook Image: Insert, Copy, or Export PicturesAn Excel workbook is not itself an image: it is a file that can contain worksheets, data, charts, and pictures. In Microsoft…
- Excel Workbook Comparison Tool: How to Compare FilesFor Microsoft Excel for Microsoft 365 on Windows, the dedicated workbook comparison tool is Spreadsheet Compare, available with certain Office editions and…
- Excel Workbook in Google Sheets: How to Open and EditYes. You can open and edit an Excel workbook in Google Sheets by uploading the Excel file to Google Drive and opening…
- Excel File Won’t Open in Protected View? FixesIf an Excel file will not open in Protected View, first confirm that the file came from a source you trust, then…
- Excel Files List: Common Formats, Extensions, and UsesThe main Excel file types are .xlsx, .xlsm, .xlsb, and the older .xls format; Excel also uses templates such as .xltx and…
- Excel File Opening Blank? Causes, Checks, and FixesIf an Excel file opens to a blank screen, first check whether the workbook or its sheets are hidden: in Excel for…
- Excel File Opens to a Blank Gray Screen? FixesIf an Excel file opens to a blank gray screen, first check whether the workbook is hidden or open in another Excel…
- Excel File Row Limit: Maximum Rows and Your OptionsAn Excel worksheet can contain a maximum of 1,048,576 rows, numbered 1 through 1,048,576. That limit applies to each worksheet in modern…
- Excel Freezing? Causes, Fixes, and PreventionIf an Excel file keeps freezing, first wait briefly to see whether Excel is calculating or loading; if it becomes responsive, save…
- Excel File Name Length Limit: What Counts?For Excel for Microsoft 365 on Windows, the practical documented limit is 218 characters for the full path and file name together—not…
- Excel File Cannot Open Because the File Format Is InvalidExcel’s “file format or file extension is not valid” message usually means Excel cannot reconcile the filename’s extension with the file’s actual…
- Excel File Freezing: Causes and FixesIf an Excel file freezes, first wait briefly and try Ctrl+S; if Excel remains unresponsive, reopen Excel in Windows Safe Mode, then…
- Excel Mac Shortcut Keys: Essential Commands and TipsExcel for Mac shortcut keys combine the Command (⌘), Option (⌥), Control (⌃), and Shift (⇧) keys with letters, arrows, or function…
- Excel Mac Shortcuts: Essential Keys and How They WorkExcel for Mac uses the Command key (⌘) for many everyday shortcuts: press ⌘+C to copy, ⌘+V to paste, ⌘+Z to undo,…
- Excel Mac Keyboard Shortcuts: Essential Keys and TipsIn Excel for Mac, use Command+C, Command+V, and Command+Z to copy, paste, and undo; use Command+Arrow to move to the edge of…
- Excel vs CSV: Key Differences and When to Use EachExcel is spreadsheet software and a workbook format; CSV is a plain-text format for rows and columns. Choose an Excel workbook when…
- Excel vs CSV: Key Differences and Which Format to ChooseExcel is a spreadsheet application and workbook format that can store multiple sheets, formulas, formatting, and other features; CSV is a plain-text…
- Excel vs SharePoint Lists: Which Should You Use?Use Excel when you need flexible calculations, analysis, or charts; use a SharePoint list when people need to enter, manage, and track…