How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Time Format Over 24 Hours: Display Elapsed Time CorrectlyTo display a duration longer than 24 hours in Excel, select the cells, open Format Cells, choose Custom, and enter [h]:mm or…
- Excel Time Format Without Seconds: How to Set ItTo show an Excel time without seconds, select the cells, press Ctrl+1 on Windows, choose Number > Custom, and enter h:mm as…
- Excel Time Format: Show Hours and Minutes Only CorrectlyTo show hours and minutes in Excel, select the cells, press Ctrl+1, choose Custom, and enter h:mm (or hh:mm for a leading…
- Excel Time Difference in Seconds: How to CalculateWith a start time in A2 and an end time in B2, enter =(B2-A2)*86400 to calculate the difference in seconds. For example,…
- Excel Date Without Year: Display a Date Without Its YearTo show an Excel date without its year, select the date cells, press Ctrl+1 on Windows, choose Number > Custom, and enter…
- Excel Time Difference Between Two Dates and Times ExplainedTo find the elapsed time between two date-and-time values in Excel, subtract the earlier value from the later one: with the start…
- Excel Date Origin: 1900 vs. 1904 SystemsExcel’s default date origin on Windows is the 1900 date system: January 1, 1900 is serial number 1, and each later day…
- Excel Date Box: Enter Dates and Add a Calendar PickerIn Excel for Microsoft 365 on Windows, a “date box” usually means a cell where you enter a date; Excel does not…
- Excel Date Calendar Drop-Down: What Works and What Doesn’tIn Excel for Microsoft 365 on Windows, an ordinary worksheet cell does not have a built-in calendar drop-down. Use Data Validation to…
- Excel Date as Number: Excel Serial Dates ExplainedYes. Excel stores dates as serial numbers: the whole-number part counts days, and any decimal part represents a time within the day.…
- Excel Table With Headers on the Side: What Actually WorksNo—an Excel Table has a header row across the top; it cannot use a column on the left as its formal header…
- Excel Table Row Number: Get the Position or Sheet RowIn Excel, a table row can mean either its position within the table or its actual worksheet row number. To number table…
- Excel Table: Print Headers on Every PageYes. In Excel for Microsoft 365 on Windows, open Page Layout > Print Titles and set the table’s worksheet row in Rows…
- Excel Table Shortcut Keys: Create, Navigate, and EditIn Excel for Microsoft 365 for Windows, press Ctrl+T or Ctrl+L to turn a selected range of data into a table; review…
- Excel Table Not Pasting Into Outlook? Fixes That WorkIf an Excel table is not pasting into Outlook, copy the cells again, click in the message body, and press Ctrl+V; then…
- Excel Table List: Find and Manage Your TablesTo see the tables in an Excel workbook, select a table and open the Table Design tab to view its name; Excel…
- Excel Table Not Adding New Rows? Causes and SolutionsExcel tables usually add rows when you type directly in the first row beneath them, or press Tab from the table’s last…
- Excel Table in Word: Insert, Link, or Embed an Excel FileTo put Excel data in a Word document, select and copy the cells in Excel, then paste them in Word; choose a…
- Excel Table Image: How to Insert and Manage PicturesTo put a picture in an Excel table, select a cell and choose Insert > Pictures > Place in Cell, then select…
- Excel Table Headers on Each Printed Page: How to Repeat ThemTo print the same column headings on every page in Excel for Microsoft 365 on Windows, open Page Layout > Print Titles,…
- Excel Table Colors: How to Change and Customize ThemExcel table colors are controlled mainly by table styles: select a cell in the table, open the Table Design tab, and choose…
- Excel Table Headers: Keep Them Visible While ScrollingYes—Excel tables can keep their column headings visible as you scroll down through the table: when the table header row moves off-screen,…
- Excel Table Color Not Changing? Common Causes and FixesIf an Excel table’s color is not changing, select a cell inside the table, open Table Design, and choose a different option…
- Excel Table Color Schemes: How to Choose and ChangeTo change an Excel table’s color scheme, click inside the table, open Table Design, and choose a style from Table Styles. For…
- Excel Table Color Combinations: Choose and CustomizeExcel table color combinations come from built-in table styles or a custom style you create: select a table, open Table Design >…
- Excel Rows Keep Hiding? How to Find and Unhide ThemExcel rows that seem to keep hiding are usually filtered, grouped, set to zero height, or hidden manually. First, select the affected…
- Excel Tables: Do They Automatically Add New Rows in Excel?Yes. In Microsoft Excel for Microsoft 365 on Windows, a table will usually expand automatically when you type or paste data directly…
- Excel Row Size: Row Limits, Height, and AutoFit ExplainedIn Excel for Microsoft 365, a worksheet can contain up to 1,048,576 rows, and an individual row can be up to 409…
- Excel Row Freeze Shortcut and How to Use Freeze PanesIn Excel for Microsoft 365 on Windows, press Alt, then W, F, and R to freeze the top row. Press the keys…
- Excel Row Height Limit: The 409-Point MaximumThe maximum row height in Excel for Microsoft 365 on Windows is 409 points. To set a row’s height, select it and…