Skip to content
- Pull Data Dumps With No Blank Rows in ExcelIf your data dump is in A2:D1000 and column A contains a required record ID, enter =FILTER(A2:D1000,A2:A1000<>""," ") in an empty cell…How-to basics
- Excel VBA to List File Names in All Subfolders AutomaticallyTo list file names from a folder and all its subfolders in Excel for Microsoft 365 on Windows, run a VBA macro…VBA & macros
- Set Image Height in Excel VBA Using InchesTo set an image to a height measured in inches, assign its VBA Height property the result of Application.InchesToPoints. For example, pic.Height…VBA & macros
- Excel VBA Data Entry Form With a Picture Box: How It WorksYes. In Excel for Microsoft 365 on Windows, make a VBA UserForm, add an Image control to act as the picture box,…VBA & macros
- VBA Outlook Create Contact Group from ExcelYes. In classic Outlook for Windows, an Excel VBA macro can read email addresses from a worksheet, create an Outlook contact group…VBA & macros
- How to Put a Photo in a VBA UserFormTo put a photo in an Excel VBA UserForm, add an Image control, then either set its Picture property in the form…VBA & macros
- Excel UserForm Combo Box: Add, Populate, and Use ItAn Excel UserForm combo box is a VBA control that lets someone choose an item from a drop-down list, and in some…VBA & macros
- 3D Pie Chart in Excel: Create, Format, and Improve ItTo make a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column range containing category names and positive…Charts & pivot tables
- Excel VBA: Save a Sheet as a Web Page with FormattingYes. In desktop Excel for Microsoft 365 on Windows, VBA can publish one worksheet as a static HTML web page while retaining…VBA & macros
- How to Delete Subtotal Rows in Excel Without Losing DataTo remove subtotals created with Excel’s Subtotal command, click a cell in the list, choose Data > Subtotal, then select Remove All.…How-to basics
- Excel Subtotal Rows in Color: How to Highlight ThemTo color subtotal rows in Excel, use conditional formatting with a rule that recognizes each subtotal row, then choose a fill color.…How-to basics
- Percentage Half Moon Chart in Excel: How to Create OneTo create a percentage half moon in Excel, build a doughnut chart from three values: the completed percentage, the amount remaining, and…Charts & pivot tables
- Excel: Copy Subtotal Rows Only Without Detail RowsYes. In Excel for Microsoft 365 on Windows, collapse the outline to level 2, select the range you want, choose Home >…How-to basics
- Group Rows in Excel by the Same NameTo group rows that share a name, first sort the entire data range by the Name column so identical names sit together.…How-to basics
- How to Group Rows in Excel Under a Heading: Step-by-StepTo group rows under a heading in Excel, leave the heading row outside the selection, select the detail rows beneath it, then…How-to basics
- Group Rows in Excel: Keyboard Shortcut and StepsTo group rows in Excel for Microsoft 365 on Windows, select the row headers you want to group and press Alt+Shift+Right Arrow.…How-to basics
- How to Group Rows in Excel and Hide ThemTo group rows in Excel and hide them, select the detail rows, choose Data > Outline > Group, then click the minus…How-to basics
- How to Hyperlink to Another Cell in ExcelTo hyperlink to another cell in the same Excel workbook, select the cell where the link should appear, press Ctrl+K on Windows,…How-to basics
- Excel Hyperlink Shortcut: How to Add a LinkTo add a hyperlink in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+K. Choose the destination, enter its…How-to basics
- Show Formulas in Excel on iPad: View Cell FormulasIn Excel on iPad, tap a cell to see its formula in the formula bar. To display formulas inside every worksheet cell,…Formulas & functions
- Show Formulas in Excel: Keyboard Shortcut GuideTo show formulas in Excel for Microsoft 365 on Windows, press Ctrl+` (Ctrl plus the grave accent key, usually just below Esc).…Formulas & functions
- Copy Formulas in Excel Without Creating External LinksTo copy a formula without linking it to another workbook, copy the formula text from the formula bar and enter it in…Formulas & functions
- Copy Formulas in Excel Without Changing ReferencesTo copy a formula without letting Excel adjust its cell references, lock the references with dollar signs before copying. For example, change…Formulas & functions
- How to Copy Formulas in Excel to Other Rows: Step by StepTo copy a formula into rows below it in Excel, select the cell that contains the formula and drag its fill handle…Formulas & functions
- How to Copy Formulas in Excel to a New Workbook SafelyTo copy formulas into a new Excel workbook, open both workbooks, copy the formula cells in the source, then paste them into…Formulas & functions
- Copy Formulas in Excel to a New Sheet Without ErrorsTo copy formulas to a new sheet in Excel, select the formula cells, press Ctrl+C, open the destination sheet, select the first…Formulas & functions
- How to Copy Formulas in Excel on a MacBook Without ErrorsTo copy a formula in Excel on a MacBook, select the cell containing it, press Command+C, select the destination cell or range,…Formulas & functions
- Copy Formulas in Excel Exactly: Keep References FixedTo copy a formula in Excel, select its cell, press Ctrl+C, select the destination, and press Ctrl+V. Excel normally adjusts relative cell…Formulas & functions
- How to Copy Formulas in Excel by Dragging the Fill HandleTo copy a formula in Excel by dragging, select the cell with the formula, point to the small square at its lower-right…Formulas & functions
- Copy Formulas in Excel Across Rows: A Simple GuideTo copy a formula horizontally, select its cell and drag the small fill handle at the lower-right corner across the destination cells;…Formulas & functions