How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Sum by Cell Color: Methods That Actually WorkExcel does not have a built-in SUMIF function that adds cells based on fill color. To total one color, filter the range…
- Excel Max Cell Height: The 409-Point Row Height LimitIn Excel for Microsoft 365 on Windows, the maximum row height is 409 points, or about 5.68 inches (14.4 cm). A cell…
- Excel Modify Drop-Down Lists: Steps, Tips and FixesTo modify an Excel drop-down list, select a cell that uses it, open Data > Data Validation, and edit the entries in…
- Large Excel File Won’t Open? Causes and Practical FixesIf a large Excel file won’t open, first copy it to a local drive, close other programs, and try opening Excel in…
- Excel Mode With Text: Find the Most Frequent Text ValueExcel’s MODE.SNGL and MODE.MULT functions work with numbers, not words. To find the most frequent text value, count each entry with COUNTIF,…
- Roundup Excel Without Decimals: 10 Reliable MethodsTo round a value in Excel to the nearest whole number, use =ROUND(A2,0); to make every positive value round upward, use =ROUNDUP(A2,0).…
- Excel MODE.MULT: Find Multiple Modes in a Data SetYes. In Microsoft 365 Excel for Windows, use MODE.MULT to return every value tied for the highest frequency in a data set.…
- Excel Days, Hours, and Minutes: Format DurationsTo show an elapsed time in Excel as days, hours, and minutes, keep the duration as a number and either format it…
- Excel Day School? Meaning and How to Identify One“Excel day school” does not identify one universally recognized school: it may refer to a particular school named Excel, or to a…
- Excel Day Number: Serial Dates, Day of Month and YearIf A2 contains a valid Excel date such as June 15, 2024, and you want its day of the month, enter =DAY(A2);…
- Excel Day Month Year Format: Dates That Display ClearlyTo display Excel dates as day, month, year, select the date cells, press Ctrl+1, choose Custom, and enter dd/mm/yyyy for a numeric…
- Excel Not Moving From Cell to Cell? Fixes That WorkIf Excel is not moving from cell to cell when you press the arrow keys, turn off Scroll Lock first: it makes…
- Excel Day Hour Minute Second Format: Display DurationsTo display an elapsed time in Excel as hours, minutes, and seconds, apply the custom number format [h]:mm:ss. The square brackets keep…
- Excel Day of Year: Find the Day Number for Any DateTo find the day of the year in Excel, put a real Excel date in A2 and enter =INT(A2)-DATE(YEAR(A2),1,0) in another cell.…
- Excel Day Counter: Count Days Between DatesWith a start date in A2 and an end date in B2, enter =B2-A2 to count the days between them. For example,…
- Excel Date Difference: Days, Workdays, and Inclusive CountsTo find the number of days between two dates in Excel, subtract the earlier date from the later one. With the start…
- Excel Day Based on Date: Find the WeekdayTo show the weekday for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a valid Excel date; for…
- Excel Day Care in Clementi: Location and Enrolment GuideIf you are looking for Excel Day Care in Clementi, confirm the centre’s current address and operating status with Singapore’s Early Childhood…
- Excel Day Care in Jurong East: Location, Fees and ChecksIf you’re looking for Excel Day Care in Jurong East, confirm that the specific centre is currently licensed and operating before making…
- Excel Day and Date Formats: Codes, Examples, and FixesIn Excel for Microsoft 365 on Windows, a date’s day and date format controls how its value appears, not the underlying date…
- Excel Day and Month Reversed? Fixing Date FormatsExcel usually does not swap the day and month in a date that is already stored correctly; a different date format can…
- Excel WEEKDAY: Get the Day of the Week from a DateIn Excel, use WEEKDAY to return a number for the day of the week represented by a date. If A2 contains March…
- Excel Weekday Name: Show the Day from Any Date in ExcelTo show the weekday name for a date in Excel, put the date in A2 and enter =TEXT(A2,"dddd") in another cell. If…
- Excel New Sheet Shortcut: Add a Worksheet in SecondsIn Excel for Microsoft 365 on Windows, press Shift+F11 to insert a new worksheet. The new sheet is placed immediately before the…
- Excel NOW Shortcut: Insert the Current Date and TimeExcel has no dedicated keyboard shortcut that inserts the NOW() formula. To enter a fixed date and time, press Ctrl+;, then Space,…
- Excel New Paragraph in Cell: Line Breaks ExplainedTo start a new paragraph inside an Excel cell in Microsoft 365 for Windows, edit the cell, place the cursor where the…
- Excel New Sheet: How to Add and Open OneTo add a new worksheet in Excel for Microsoft 365 on Windows, click the plus sign beside the sheet tabs, or press…
- Excel New Row Shortcut: Insert Rows Above or BelowIn Excel for Microsoft 365 on Windows, select the row where you want the new one, then press Ctrl+Shift+= (the plus-sign shortcut)…
- Excel New Note Shortcut: Add and Edit Notes QuicklyIn Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to create a new note; if the cell already…
- Excel New Blank Workbook: Create, Save, and Set It UpTo create a new blank workbook in Excel for Microsoft 365 on Windows, press Ctrl+N, or select File > New > Blank…