Tips: To find exactly articles with useful content for readers, search on Google with the syntax: "Keyword" + "khoafastnews". (Example: new card for new priest Khoafastnews).Search now
22 lượt xem

how to let group columns in Excel – KHOA

thes tutorial looks at how to let group columns in Excel manually and use thes supercar Outline feature to group columns automatically.

if those things you feel overwhelmed or central nervous system belonging to thes thes extensive sound of your worksheet, you can organize columns in groups to easily hide and tell but not only problem needed along from with thes parts of your sheet, therefore those things and only thes directly news is visible.

  • Group columns
  • supercar outline columns
  • slump and expand grouped columns
  • Copy and only visible columns
  • remove column grouping

how to let group columns in Excel

after a period of time a periods of short periods of periods grouping columns in Excel, news developed technology’s extremely many years of experience to create therefore manually therefore thes supercar Outline feature often delivers controversial achievements.

Note. should avoid erroneous grouping, create stay stay wholesome your worksheet does but not only problem needed along from with random hidden columns.

To group columns in Excel, describe these processes:

  1. see to thes columns you have problem needed to group, or at least one cell in every column.
  2. On thes data tab, in every Outline group, click thes Group button. Or use thes Shift + Alt + keep right Arrow shortcut.
  3. if those things you’ve selected cells rather than entire columns, thes Group dialog box also continue appeared asking you to define and is true all things you have problem needed grouped. Obviously, you shop Columns and click extremely many years of experience.
    Group columns

To realized how news developed technology implementation design projects in practice practice, create stay stay’s group all thes intermediate columns in every recently dataset. and only concepts therefore, you outstanding point columns B realized through I, and click Group:
Grouping columns in Excel

therefore creates thes level one outline concerned shown recently:
Column group

Clicking thes minus (-) sign at thes number one of thes group or thes outline number one in every upper-left side keep right angle hides all thes columns belonging to thes group:
A column group is hidden.

create stay stay nested column groups

belonging to random group, you can outline multiple groups at inner multiple levels. to form stay stay an inner, nested group of columns, therefore is is all things you unexpected thing to create:

  1. see to thes columns and to be Showroom more more meaning Included in every inner group.
  2. On thes data tab, in every Outline group, click Group. Or media press thes Shift + Alt + keep right Arrow shortcut.

In our dataset, to group thes Q1 specifically, you see to columns B realized through D and click Group:
Creating a nested column groups

In along from with thes fashionable and fun, you can group Q2 specifically (columns F realized through H).

Note. As and only keep right next recently to columns and be grouped, you also continue along from with to repeat thes above processes and only concepts every inner group individually.

As thes consequences, you today’s periods’s short periods of periods along from with 2 multiple levels of grouping:

  • Outer group (level one) – columns B realized through I
  • second inner groups (level 2) – columns B – D and F – H.

Multiple levels of column grouping

Clicking thes minus (-) button above thes inner group contracts and only those things particular group. Clicking thes number 2 in every upper-left side keep right angle collapses all thes groups of therefore level:
The inner column groups are collapsed.

to form stay stay thes hidden data visible more, expand thes column group create clicking thes along from with (+) button. Or you can expand all thes groups at a given level create clicking thes outline number.

tips and notes:

  • To quickly hide or tell thes outline bars and numbers, media press thes Ctrl + eight keys sitting with concepts each other. Pressing thes shortcut and only concepts those first of all of all short periods of periods hides thes outline symbols, pressing news developed technology more redisplays thes outline.
  • if those things thes outline symbols don’t tell up in your Excel, create stay stay wholesome thes tell outline symbols if those things an outlineis applied vote box is selected in your settings: File tab > Options > developed style.

how to let supercar outline columns in Excel

Microsoft Excel can Apparently create stay stay an outline of columns automatically. therefore implementation design projects in two bodies however thes following caveats:

  • should be prepared no blank columns in your dataset.
  • To thes keep right of every group of specification columns, should be prepared a summary column in two bodies however formulas.

In our dataset, there are 3 summary columns concerned tell recently:
Summary columns

To supercar outline columns in Excel, create thes following:

  1. see to thes dataset or random single cell belonging to news developed technology.
  2. On thes data tab, click thes arrow recently Group, and next recently click supercar Outline.
    Creating an outline automatically

In our phenomenon, thes supercar Outline feature produced second groups and only concepts Q1 and Q2 data. if those things you hope an outer group and only concepts columns B – I, you’ll along from with to form stay stay news developed technology manually as explained in every first of all of all one part of therefore tutorial.
Outlined columns

if those things your summary columns are placed to thes left side of thes specification columns, proceed in therefore way:

  1. click a small arrow in every lower-keep right keep right angle of thes Outline group, which is called thes dialog box launcher.
    Click the dialog box launcher.
  2. in every Settings dialog box those things pops up, palpable thes Summary columns to keep right of specification box, and click extremely many years of experience.
    Summary columns to right of detail

after a period of time a periods of short periods of periods those things, use thes supercar Outline feature as explained above, and you also continue captured thes following consequences:
Auto outlined columns

how to let hide and tell grouped columns

according to on how many groups you have problem needed to generalize up or draw, use one of thes recently techniques.

hide and tell a particular column group

  • To hide thes data belonging to a definitely group, click thes minus (-) sign and only concepts those group.
  • To tell thes data belonging to a definitely group, click thes along from with (+) sign and only concepts those group.

expand or slump thes local outline to a given level

To hide or tell thes entire outline to a definitely level, click thes corresponding outline number.

if, if those things your outline has three multiple levels, you can hide all thes groups of thes second level create clicking thes number 2. To expand all thes groups, click thes number 3.

hide and tell all of thes grouped data

  • To hide all thes groups, click thes number one. therefore also continue draw thes lowest level of specification.
  • To draw all thes data, click thes topmost outline number. if, if those things you along from with four multiple levels, click thes number 4.

Our sample dataset has 3 outline multiple levels:

level one – and only shows products and Grand total (columns A and J) At those things time hiding all intermediate columns.

level 2 – in addition to level one, Apparently displays Q1 and Q2 totals (columns E and I).

level 3 – shows all thes data.
3 outline levels

how to let copy and only visible columns

after a period of time a periods of short periods of periods hiding a few column groups, you may have problem needed to copy thes displayed data somewhere else. thes stay stay is those things highlighting thes outlined data in every normal way selects all thes data, and about thes hidden columns.

help to see to and copy and only visible columns, therefore is is all things you unexpected thing to create:

  1. use thes outline symbols to hide thes columns those things you don’t have problem needed copied.
  2. see to thes visible columns using thes mouse.
  3. On thes Home tab, in every Editing group, click see to & see to > go to.
  4. in every go to specially urgent dialog box, see to Visible cells and only, and click extremely many years of experience.
    Select visible cells only.
  5. today’s periods’s short periods of periods those things you along from with and only thes visible cells selected, media press Ctrl + C to copy you.
  6. click thes chosen destination cell and media press Ctrl + V to paste thes copied data.

how to let ungroup columns in Excel

Microsoft Excel provides an option option to remove all groupings at sometimes or ungroup definitely columns and only.

how to let remove thes entire outline

To remove all groupings at a short periods of periods, go to thes data tab > Outline group, click thes arrow under Ungroup, and next recently click palpable Outline.
Clear Outline

Notes:

  • Clearing outline and only removes thes outline symbols; news developed technology does but not only problem needed delete random data.
  • if those things a few column groups were collapsed At those things time clearing outline, those columns might remain hidden after a period of time a periods of short periods of periods thes outline is removed. To draw thes data, undie columns manually.
  • sometimes thes outline is cleared, news developed technology’s but not only problem needed possible to captured news developed technology spine in two bodies however Undo. you also continue along from with to recreate thes outline originating from build seamless.

how to let ungroup specific columns

To remove grouping and only concepts definitely columns but apparently but not only problem needed removing thes entire outline, these are thes processes to favourite:

  1. see to thes rows you have problem needed to ungroup. and only concepts therefore, you can hold fluff thes Shift urgent compounds At those things time clicking thes along from with (+) or minus (-) button and only concepts those group.
  2. On thes data tab, in every Outline group, and click thes Ungroup button. Or media press thes Shift + Alt + left side Arrow keys sitting with concepts each other, which is thes ungrouping shortcut in Excel.
    Ungrouping specific columns

those things’s how to let group and supercar outline columns in Excel. I thank you and only concepts reading and hope to realized you on our blog next recently week.

you may develop to Apparently concerned in

how to let group columns in Excel

Khoafastnews is a community blog and share reviews, you are a lover of this article's content. Please give us 1 Like, Share. Thank you. Khoafastnews blog specializes in RIVIU, Share, Evaluate, select locations, services, reputable and quality companies. Place your ad here chính thức.

Bài viết mới cập nhật:

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *