---
title: "Ungroup rows or columns: Alt+Shift+Left in Excel (Mac Cmd+Shift+J) | PracticeExcel"
description: "Ungroup rows or columns in Excel with Alt+Shift+Left on Windows or Cmd+Shift+J on Mac. Practice it in a live grid."
canonical_url: "https://practiceexcelonline.com/shortcuts/ungroup-rows"
locale: en
meta:
  "og:description": "Ungroup rows or columns in Excel with Alt+Shift+Left on Windows or Cmd+Shift+J on Mac. Practice it in a live grid."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnM6IEFsdCtTaGlmdCtMZWZ0IGluIEV4Y2VsIChNYWMgQ21kK1NoaWZ0K0op%2Cdescription_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnMgaW4gRXhjZWwgd2l0aCBBbHQrU2hpZnQrTGVmdCBvbiBXaW5kb3dzIG9yIENtZCtTaGlmdCtKIG9uIE1hYy4gUHJhY3RpY2UgaXQgaW4gYSBsaXZlIGdyaWQu%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvdW5ncm91cC1yb3dzIg%2Cs_8q4okD0sDBGPaKcM.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Ungroup rows or columns: Alt+Shift+Left in Excel (Mac Cmd+Shift+J) | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnM6IEFsdCtTaGlmdCtMZWZ0IGluIEV4Y2VsIChNYWMgQ21kK1NoaWZ0K0op%2Cdescription_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnMgaW4gRXhjZWwgd2l0aCBBbHQrU2hpZnQrTGVmdCBvbiBXaW5kb3dzIG9yIENtZCtTaGlmdCtKIG9uIE1hYy4gUHJhY3RpY2UgaXQgaW4gYSBsaXZlIGdyaWQu%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvdW5ncm91cC1yb3dzIg%2Cs_8q4okD0sDBGPaKcM.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **Ungroup rows or columns**

<dl><dt>**Windows**</dt>
<dd>`Alt+Shift+Left`</dd>
<dt>**Mac**</dt>
<dd>`Cmd+Shift+J`</dd>
</dl>

Alt+Shift+Left

Removes the grouping from the selected rows or columns, and the plus and minus buttons in the margin go away. With only some cells selected, Excel asks whether to ungroup rows or columns.

## **More Format shortcuts**

- [**Apply the Currency format**`Ctrl+Shift+4`](https://practiceexcelonline.com/shortcuts/currency-format)
- [**Apply the Date format**`Ctrl+Shift+3`](https://practiceexcelonline.com/shortcuts/date-format)
- [**Open Format Cells**`Ctrl+1`](https://practiceexcelonline.com/shortcuts/format-cells)
- [**Group rows or columns**`Alt+Shift+Right`](https://practiceexcelonline.com/shortcuts/group-rows)
- [**Hide the selected columns**`Ctrl+0`](https://practiceexcelonline.com/shortcuts/hide-column)
- [**Hide the selected rows**`Ctrl+9`](https://practiceexcelonline.com/shortcuts/hide-row)
- [**Apply the Number format**`Ctrl+Shift+1`](https://practiceexcelonline.com/shortcuts/number-format)
- [**Add an outline border**`Ctrl+Shift+7`](https://practiceexcelonline.com/shortcuts/outline-border)
- [**Apply the percent format**`Ctrl+Shift+5`](https://practiceexcelonline.com/shortcuts/percent-format)
- [**Apply the Scientific format**`Ctrl+Shift+6`](https://practiceexcelonline.com/shortcuts/scientific-format)
- [**Apply strikethrough**`Ctrl+5`](https://practiceexcelonline.com/shortcuts/strikethrough)
- [**Apply the Time format**`Ctrl+Shift+2`](https://practiceexcelonline.com/shortcuts/time-format)
- [**Unhide rows**`Ctrl+Shift+9`](https://practiceexcelonline.com/shortcuts/unhide-rows)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#webpage","@type":"WebPage","description":"Ungroup rows or columns in Excel with Alt+Shift+Left on Windows or Cmd+Shift+J on Mac. Practice it in a live grid.","name":"Ungroup rows or columns: Alt+Shift+Left in Excel (Mac Cmd+Shift+J)","url":"https://practiceexcelonline.com/shortcuts/ungroup-rows","breadcrumb":{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/shortcuts/ungroup-rows"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel keyboard shortcuts","item":"https://practiceexcelonline.com/shortcuts","position":2},{"@type":"ListItem","name":"Ungroup rows or columns: Alt+Shift+Left in Excel (Mac Cmd+Shift+J)","position":3}]},{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#article","description":"Ungroup rows or columns in Excel with Alt+Shift+Left on Windows or Cmd+Shift+J on Mac. Practice it in a live grid.","headline":"Ungroup rows or columns: Alt+Shift+Left in Excel (Mac Cmd+Shift+J)","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnM6IEFsdCtTaGlmdCtMZWZ0IGluIEV4Y2VsIChNYWMgQ21kK1NoaWZ0K0op%2Cdescription_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnMgaW4gRXhjZWwgd2l0aCBBbHQrU2hpZnQrTGVmdCBvbiBXaW5kb3dzIG9yIENtZCtTaGlmdCtKIG9uIE1hYy4gUHJhY3RpY2UgaXQgaW4gYSBsaXZlIGdyaWQu%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvdW5ncm91cC1yb3dzIg%2Cs_8q4okD0sDBGPaKcM.png","@type":["Article","TechArticle"],"author":{"@id":"https://practiceexcelonline.com/#identity"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/shortcuts/ungroup-rows#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnM6IEFsdCtTaGlmdCtMZWZ0IGluIEV4Y2VsIChNYWMgQ21kK1NoaWZ0K0op%2Cdescription_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnMgaW4gRXhjZWwgd2l0aCBBbHQrU2hpZnQrTGVmdCBvbiBXaW5kb3dzIG9yIENtZCtTaGlmdCtKIG9uIE1hYy4gUHJhY3RpY2UgaXQgaW4gYSBsaXZlIGdyaWQu%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvdW5ncm91cC1yb3dzIg%2Cs_8q4okD0sDBGPaKcM.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnM6IEFsdCtTaGlmdCtMZWZ0IGluIEV4Y2VsIChNYWMgQ21kK1NoaWZ0K0op%2Cdescription_~VW5ncm91cCByb3dzIG9yIGNvbHVtbnMgaW4gRXhjZWwgd2l0aCBBbHQrU2hpZnQrTGVmdCBvbiBXaW5kb3dzIG9yIENtZCtTaGlmdCtKIG9uIE1hYy4gUHJhY3RpY2UgaXQgaW4gYSBsaXZlIGdyaWQu%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvdW5ncm91cC1yb3dzIg%2Cs_8q4okD0sDBGPaKcM.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.