Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Roinn sonraí go tapa i mbileoga oibre iomadúla bunaithe ar cholún roghnaithe in Excel

Má ghlactar leis go bhfuil bileog oibre agat a bhfuil sonraí i gcolúin A go G, tá ainm an díoltóra i gcolún A agus ní mór duit na sonraí seo a roinnt go huathoibríoch i mbileoga oibre iolracha bunaithe ar an ainm i gcolún A. Roinnfear gach díoltóir i mbileog oibre nua. Kutools le haghaidh Excel'S Dáta Scoilt is féidir le fóntais sonraí a roinnt go tapa i mbileoga oibre iomadúla bunaithe ar cholún roghnaithe in Excel.

Roinn sonraí i mbileoga oibre iolracha bunaithe ar cholún roghnaithe

Roinn sonraí i mbileoga oibre iomadúla bunaithe ar uimhir na sraitheanna


cliceáil Kutools Plus > Bileog Oibre > Sonraí Scoilt (nó Kutools Plus> Scoilt Sonraí). Féach screenshots:

kutools-arrow-dheis

Roinn sonraí i mbileoga oibre iolracha bunaithe ar cholún roghnaithe

Má cheaptar go bhfuil raon sonraí agat mar a thaispeántar sa phictiúr thíos, agus gur mhaith leat na sonraí seo a roinnt go tapa ar iliomad bileoga oibre bunaithe ar cholún A i leabhar oibre trí gach ainm a roinnt ar bhileog oibre nua. Mar shampla, ar fad Kelly roinnfear é ar an mbileog oibre chéanna. Is féidir leat é a dhéanamh mar seo a leanas:

1. Roghnaigh an raon a theastaíonn uait a roinnt ina ilbhileog oibre bunaithe ar cholún.

2. Agus ansin an fóntais a chur i bhfeidhm trí chliceáil Kutools Plus > Bileog Oibre > Scoilt Sonraí. Sa an Roinn Dáta i mBileoga Oibre Il bosca dialóige, roghnaigh le do thoil Colún sonrach agus ansin colún a shonrú ar mhaith leat sonraí a roinnt air bunaithe ar an liosta anuas.

Leid: Má tá ceanntásc sa raon roghnaithe agat, seiceáil le do thoil Tá ceanntásca ar mo chuid sonraí rogha, is féidir leat líon na sraitheanna ceanntásc a shonrú bunaithe ar do chuid sonraí. Mar shampla, má tá dhá cheanntásc i do chuid sonraí, cineál 2 le do thoil.

3. Sonraigh ainmneacha nua na mbileog oibre le do thoil. Is féidir leat an Luachanna an Cholúin mar a ainmníonn an bhileog oibre nua. Is féidir leat cineál a Réimse or Iarmhír le haghaidh ainmneacha na mbileog oibre.

4. cliceáil OK chun sonraí a roinnt, anois is féidir leat a fheiceáil go roinnfear gach ainm sa cholún i mbileog oibre nua laistigh de leabhar oibre nua. Féach an pictiúr:


Roinn sonraí i mbileoga oibre iomadúla bunaithe ar uimhir na sraitheanna

Má ghlactar leis go bhfuil raon sonraí agat mar a thaispeántar sa phictiúr thíos, agus gur mhaith leat na sonraí seo a roinnt go tapa i mbileoga oibre iomadúla bunaithe ar uimhir na sraitheanna, mar shampla, gach 5 shraith sonraí a roinnt i mbileog oibre nua. Is féidir leat é a fháil síos mar a leanas:

1. Roghnaigh an raon is mian leat a roinnt ina iliomad bileoga oibre bunaithe ar gach 5 shraith.

2. Agus ansin an fóntais a chur i bhfeidhm trí chliceáil Kutools Plus > Bileog Oibre > Scoilt Sonraí. Sa an Roinn Dáta i mBileoga Oibre Il bosca dialóige, roghnaigh le do thoil Sraitheanna seasta agus ansin uimhir na sraitheanna sa bhosca a shonrú.

Leid: Má tá ceanntásc sa raon roghnaithe agat, seiceáil le do thoil Tá ceanntásca ar mo chuid sonraí rogha, is féidir leat líon na sraitheanna ceanntásc a shonrú bunaithe ar do chuid sonraí. Mar shampla, má tá dhá cheanntásc i do chuid sonraí, cineál 2 le do thoil.

3. Sonraigh ainm na mbileog oibre nua le do thoil. Is féidir leat an Uimhreacha Rae mar a thugtar ar na bileoga oibre nua. Is féidir leat cineál a Réimse or Iarmhír le haghaidh ainm na mbileog oibre.

4. cliceáil OK chun sonraí a roinnt, roinnfear gach 5 shraith den raon seo i mbileog oibre nua laistigh de leabhar oibre nua. Féach an pictiúr:


Taispeántas: Roinn sonraí go tapa i mbileoga oibre iomadúla bunaithe ar cholún roghnaithe in Excel

Kutools le haghaidh Excel: le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá. Íoslódáil agus triail saor in aisce Anois!

Uirlisí Táirgiúlachta Molta
Féadann na huirlisí seo a leanas do chuid ama agus airgid a shábháil go mór, cé acu ceann atá ceart duitse?
Cluaisín Oifige: Cluaisíní úsáideacha a úsáid i d’Oifig, mar bhealach Chrome, Firefox agus New Internet Explorer.
Kutools le haghaidh Excel: Níos mó ná 300 Ardfheidhmeanna le haghaidh Excel 2019, 2016, 2013, 2010, 2007 agus Office 365.
Roghchlár Clasaiceach don Oifig: Tabhair biachláir eolacha ar ais chuig an Oifig 2007, 2010, 2013, 2016, 2019 agus 365, amhail is dá mba Office 2000 agus 2003 a bhí ann.

Kutools le haghaidh Excel

Níl san fheidhmiúlacht a thuairiscítear thuas ach ceann de 300 feidhm chumhachtach atá ag Kutools le haghaidh Excel.

Deartha le haghaidh Excel (Office) 2019, 2016, 2013, 2010, 2007 agus Office 365. Íoslódáil agus úsáid saor in aisce ar feadh 60 lá.

Scáileán de Kutools le haghaidh Excel

btn léamh níos mó      btn íoslódáil     ceannach btn

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Naomi Malouf · 4 months ago
    Hi there,
    Brilliant function to split data to new worksheets. 
    Sometimes inconsistent naming of the sheets when selecting "Values of Column" as  new worksheet name. Reverts to "Sheet 1" etc. 
    What is the rule that determines this?
    Are there any workarounds?
    Many thanks
    Naomi
  • To post as a guest, your comment is unpublished.
    whalegen@gmail.com · 1 years ago
    Currently, we can split based on text string in a certain column, based on specific rows in a certain column. I think it is fantastic to add the ability to split based on the time group in a certain column. For example, I have a date column, values are 01/01/2020, 01/03/2020....03/05/2025.., I want to split the whole table by year into different sheets.
  • To post as a guest, your comment is unpublished.
    J · 1 years ago
    I can split data, but it doesn't keep the formatting. It's almost not worth it to have it split the data without the formatting.
  • To post as a guest, your comment is unpublished.
    Arturo · 3 years ago
    Is there something similar for Google Sheets?
  • To post as a guest, your comment is unpublished.
    Christian · 4 years ago
    There seems to be an issue with the Kutools "Copy Page Setup" print function when used in Office 365 as it isn't able to copy the "Fit All Columns on One Page" setting to the other worksheets. Instead it uses the "Fit Sheet on One Page". Tried finding the printer default settings for the worksheets created by Kutools, but wasn't successful - it doesn't seem to use the settings from the default template? How can this be achieved?
  • To post as a guest, your comment is unpublished.
    claire.counihan@reddam.house · 4 years ago
    Has there been a resolution to this? I am unable to split data into multiple worksheets based on the content of a column.
  • To post as a guest, your comment is unpublished.
    Debbie Toups · 7 years ago
    This function is not working, any suggestions
    • To post as a guest, your comment is unpublished.
      Algemron · 7 years ago
      I'm having a similar issue with this feature not working.
      seems to copy of of sync. believe its to do with there being only single entries for some of the data.
      cant work out why its not using the selected headers and replacing them with the first entry

      using the macro they have seems to work:
      http://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html
    • To post as a guest, your comment is unpublished.
      Algemron · 7 years ago
      Use the Macro they have on the website to fix this. Seems to work

      http://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html
  • To post as a guest, your comment is unpublished.
    Carrie · 7 years ago
    In my previous comment, the data I was splitting was in a table. Once I converted it to a range, I didn't have the problem with the record. The formatting issue still remains.
    • To post as a guest, your comment is unpublished.
      admin_jay · 7 years ago
      [quote name="Carrie"]In my previous comment, the data I was splitting was in a table. Once I converted it to a range, I didn't have the problem with the record. The formatting issue still remains.[/quote]
      We are going to enhance this utility to accomplish the Table data and try to support keep formatting in upcoming version. :-)

      We are working on it.
  • To post as a guest, your comment is unpublished.
    Carrie · 7 years ago
    When using split data, the last row of each new worksheet has the first record that's supposed to be on the next worksheet. Also, the formatting of the original worksheet is lost in the new worksheets.
  • To post as a guest, your comment is unpublished.
    Lou Oppedisano · 7 years ago
    I cannot locate the Enterprise > Worksheet Tools > Split Data in Excel 2010. Is this a standard tool on the tool bar or do i need to install this from add-ins or some other feature.
  • To post as a guest, your comment is unpublished.
    yohanu · 7 years ago
    I want to split data into multiple worksheets based on columns(2)
    Please give me some help!
    • To post as a guest, your comment is unpublished.
      Ryan · 7 years ago
      I need the same ! I am looking to split the data based on 2 columns. want to see worksheets that show "column1" - "Column2"