How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Cash Flow Forecast Excel Template: Build One That WorksA cash flow forecast Excel template lists expected cash receipts and payments by week or month, then calculates the cash balance left…
- How to Ungroup in Excel: Sheets, Rows, and ColumnsTo ungroup worksheets in Excel for Microsoft 365 on Windows, right-click one of the selected sheet tabs and choose Ungroup Sheets. To…
- Cash Flow Budget Template in Excel: Build One That WorksYes—a cash flow budget template in Excel can be a simple monthly worksheet with cash receipts, payments, and opening and ending balances.…
- Superscript in Excel: How to Format Text and NumbersTo add superscript in Excel for Microsoft 365 on Windows, edit the cell, select the character or characters you want raised, press…
- Share an Excel Link: Steps, Access, and SafetyTo share an Excel link, save the workbook to OneDrive or SharePoint, select Share in Excel, set who can open the link…
- Subscript in Excel: Format Text, Symbols, and LabelsTo add subscript in Excel for Microsoft 365 on Windows, select the cell or the characters you want to lower, press Ctrl+1,…
- How to Share Excel Files for Real-Time CollaborationTo share an Excel file, save it to OneDrive or SharePoint, select Share in the upper-right corner of Excel, and invite people…
- How to Share Excel Files in Google Sheets or ExcelTo share an Excel workbook in Google Sheets, upload the .xlsx file to Google Drive, open it with Google Sheets, and use…
- Link Excel to Excel: How to Connect Workbooks and CellsTo link cells in Excel, enter a reference such as =Sheet2!A1 in the destination cell; to link to another workbook, open both…
- Redo in Excel: Shortcuts, Limits, and FixesTo redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after undoing it with Ctrl+Z. You can also click…
- How to Link Excel to Another Sheet in Microsoft 365To link a cell to another worksheet in the same Excel workbook, enter an equals sign, select the source sheet and cell,…
- How to Insert a Checkbox in ExcelIn Excel for Microsoft 365 on Windows, select the cell or range where you want checkboxes, then choose Insert > Checkbox. Click…
- Capitalize Button in Excel: What Works and What Doesn’tExcel does not have a built-in Capitalize button like Word’s Change Case command. To change text case, use a formula such as…
- Cannot Save As in Excel? Causes and FixesIf you cannot use Save As in Excel, open File > Save As and choose Browse to save a copy in a…
- Can You Unmerge Cells in Excel? Here’s What HappensYes. In Excel for Microsoft 365 on Windows, select the merged cell or cells, then choose Home > Merge & Center >…
- Can You Zoom Out in Excel? Methods and View TipsYes. In Excel for Microsoft 365 on Windows, use the zoom slider at the bottom-right of the window and drag it left,…
- Can You Transpose Cells in Excel? Methods and TipsYes. In Excel for Microsoft 365 on Windows, copy the cells, select an empty destination, then choose Home > Paste > Transpose.…
- Can You Type Subscript in Excel? Methods and LimitsYes, you can type subscript in Excel. In the Microsoft 365 desktop app for Windows, select the characters in a text cell,…
- Can You Strikethrough Text in Excel? Shortcuts & StepsYes. In Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5 to apply strikethrough; press the same…
- Can You Track Changes in Excel? How Each Option WorksYes. In Excel for Microsoft 365, use Review > Show Changes to see recent cell edits, or use Version History to compare…
- Can You Shuffle Rows in Excel? Safe Ways to RandomizeYes. In Excel for Microsoft 365 on Windows, you can shuffle rows by adding a column of random numbers and sorting the…
- Excel Spreadsheet Sharing: How to Send or CollaborateYes—an Excel spreadsheet can be shared as a OneDrive or SharePoint link, or sent as a file attachment. I can help prepare…
- Can You Rotate an Excel Spreadsheet? What Excel AllowsYes, but Excel does not rotate an entire worksheet like a page or canvas. In Excel for Microsoft 365 on Windows, you…
- Can You Rotate an Excel Sheet? What Actually WorksYou cannot rotate an entire Excel worksheet or its grid 90 degrees inside the workbook. You can rotate text in cells, change…
- Can You Rotate Text in Excel? How to Change Its AngleYes. In Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment > Orientation and pick…
- Remove Duplicates in Excel: Safe Methods and ChecksYes. In Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates, select the columns that define a…
- Can You Rename Columns in Excel? ExplainedYes, you can rename column headers in an Excel table, but you cannot replace the worksheet’s built-in column letters, such as A,…
- Replace Words in Excel: Find and Replace GuideYes. In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, enter the existing word in Find what…
- Randomize Numbers in Excel: Methods That WorkYes. In Excel for Microsoft 365 on Windows, use =RAND() for a random decimal between 0 and 1, or =RANDBETWEEN(1,100) for a…
- Print Excel Sheets With Gridlines: Steps and TipsYes. In Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Sheet Options > Gridlines, and check…