How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- 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 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 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…
- Date Excel Shortcut: Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (semicolon) to insert today’s date as a fixed value in the selected cell.…
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date in A2 and the…
- VALUE Excel Cell Reference: Convert Text to NumbersIf A1 contains number-like text such as 42, enter =VALUE(A1) to convert it into the numeric value 42. A cell reference by…
- Excel Date Conversion Methods for Text and Serial ValuesTo convert dates in Excel, first determine whether the cells contain real date serial numbers or text: format real dates with Home…
- Text in Excel: Translate It Into EnglishYes—Excel for Microsoft 365 can translate text into English with the TRANSLATE function or the Translate command on the Review tab. If…
- Find Excel Workbook Links in Microsoft ExcelTo find links to other Excel workbooks in Microsoft 365 for Windows, open Data > Workbook Links if that command is available,…
- Find an Excel Password in a Protected File? Safe OptionsYou usually cannot find or reveal a password from inside a protected Excel file: Excel does not display a forgotten password. If…
- Find Excel Spreadsheet Not Saved? Recovery Steps That WorkIf you closed an Excel workbook without saving, open Excel and select File > Info > Manage Workbook > Recover Unsaved Workbooks,…
- How to Find Excel Spreadsheets on Your ComputerOn Windows, open File Explorer with Windows key + E, select This PC, and search for *.xlsx to find Excel workbooks across…
- Excel Replace Shortcut: Use Ctrl+H and Find & ReplaceIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace on the Replace tab. Enter the text to…
- Excel Middle Align Shortcut: Center Text VerticallyIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, then M to apply Middle…
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the later one: with the…
- Excel Not Letting You Copy and Paste? Fixes That WorkIf Excel will not copy and paste, first press Esc, select one ordinary cell, copy it with Ctrl+C, then select a blank…
- Excel Not Clicking the Correct Cell? Causes and FixesIf Excel is not clicking the correct cell, first press Esc, set the worksheet zoom to 100%, and click a clearly visible…
- Excel Copy and Paste Rows Into Columns: 3 Easy MethodsTo copy a row into a column in Excel for Microsoft 365 on Windows, select the row cells, press Ctrl+C, click a…
- Excel Not Responding: Should You Wait or Close It?Usually, wait briefly before closing Excel: the Not Responding message means Windows is not receiving a response from the app, but Excel…