Cuidiú fianáin linn ár seirbhísí a sheachadadh. Trí úsáid a bhaint ár gcuid seirbhísí, aontaíonn tú úsáid a bhainimid as fianáin.
Leid: Aistrítear Google-theangacha eile. Is féidir leat cuairt a thabhairt ar an English leagan den nasc seo.
Logáil isteach
x
or
x
x
Cláraigh
x

or

Roinnt sonraí a roinnt go héasca i iláin bileoga oibre bunaithe ar an gcolún roghnaithe in Excel

Má tá bileog oibre agat go bhfuil sonraí i gcolún A go G, tá ainm an díoltóra i gcolún A agus ní mór duit an sonraí seo a roinnt go huathoibríoch i iláin bileoga oibre atá bunaithe ar an gcolún A sa leabhar oibre céanna. Déanfar gach díoltóir a roinnt i mbileog oibre nua. Kutools le haghaidh Excel'S Dáta Scoilte is féidir le fóntais sonraí a roinnt go tapa i go leor bileoga oibre bunaithe ar an gcolún roghnaithe in Excel.

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

Roinn sonraí i mbileoga oibre ilbhunaithe atá bunaithe ar gach sraitheanna eile


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

lámhaigh sonraí scoilte 01 kutools-arrow-right

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

Deimhin de go bhfuil sonraí réimse agat mar a thaispeántar sa scáileán thíos, agus ba mhaith leat go roinntear na sonraí seo go tapa i go leor bileoga oibre bunaithe ar an gcolún A i leabhar oibre trí gach ainm a scoilt i mbileog oibre nua. Mar shampla, go léir Kelly a scaipeadh isteach sa bhileog oibre céanna. Is féidir leat é a dhéanamh mar seo a leanas:

1. Roghnaigh an raon ar mhaith leat a roinnt i ilbhileog oibre bunaithe ar cholún. Leid: Má roghnaigh tú réimse le ceannteideal, seiceáil le do thoil Tá ceanntásca ag mo chuid sonraí rogha.

2. Agus ansin an fóntais a chur i bhfeidhm trí chliceáil Kutools Níos mó > Bileog Oibre > Sonraí Scoilte. Sa an Dáta Scoilt i Illeabhar Bileoga Oibre dialóg, roghnaigh Colún sonrach agus ansin colún a shonrú ar mhaith leat sonraí a roinnt bunaithe ar an liosta anuas.

3. Sonraigh an t-ainm nua bileoga oibre le do thoil. Is féidir leat an Luachanna na Colún mar ainm nua na bileoga oibre. Is féidir leat Réimse nó Iarmhír a chlóscríobh freisin don ainm bileoga oibre.

4. cliceáil OK sonraí a roinnt. Féach ar an scáileán:

Rinneadh gach ainm sa cholún a roinnt i mbileog oibre nua.


Roinn sonraí i mbileoga oibre ilbhunaithe atá bunaithe ar gach sraitheanna eile

Má tharlaíonn go bhfuil sonraí éagsúla agat mar a thaispeántar sa scáileán thíos, agus gur mhaith leat an sonraí seo a roinnt go héasca i iláin bileoga oibre bunaithe ar gach sraitheanna eile, mar shampla, gach sraith sonraí 5 a roinnt i mbileog oibre nua sa leabhar oibre céanna. Is féidir leat é a fháil mar seo a leanas:

1. Roghnaigh an raon gur mhaith leat a roinnt i ilbhileoga oibre bunaithe ar gach sraitheanna 5.

2. Agus ansin an fóntais a chur i bhfeidhm trí chliceáil Kutools Níos mó > Bileog Oibre > Sonraí Scoilte. Sa an Dáta Scoilt i Illeabhar Bileoga Oibre dialóg, roghnaigh Sraitheanna seasta agus ansin an líon sraitheanna sa bhosca a shonrú.

3. Sonraigh an t-ainm nua bileoga oibre le do thoil. Is féidir leat an Uimhreacha Ró mar ainm nua na bileoga oibre. Is féidir leat Réimse nó Iarmhír a chlóscríobh freisin don ainm bileoga oibre.

4. cliceáil OK sonraí a roinnt. Féach ar an scáileán:

Tá gach sraith 5 den raon seo spite i mbileog oibre nua sa leabhar oibre céanna.


Taispeántas: Roinnt sonraí a roinnt go héasca i iláin bileoga oibre bunaithe ar an gcolún roghnaithe in Excel

Kutools le haghaidh Excel: le níos mó ná breiseán láimhe Excel 200, saor in aisce chun iarracht gan aon teorannú a dhéanamh i laethanta 60. Íoslódáil agus triail saor in aisce Anois!


Uirlisí Táirgiúlachta Molta
Is féidir leis na huirlisí seo a leanas a shábháil go mór do chuid ama agus airgid, a bhfuil ceann ceart agat?
Tab Office: Ag baint úsáide as cluaisíní láimhe in d'Oifig, mar bhealach Chrome, Firefox agus Internet Explorer Nua.
Kutools le haghaidh Excel: Níos mó ná 300 Feidhmeanna Casta le haghaidh Excel 2019, 2016, 2013, 2010, 2007 agus Office 365.
Menu Classic don Oifig: Cuir biachláir eolasacha ar ais chuig an Oifig 2007, 2010, 2013, 2016, 2019 agus 365, amhail is dá mba Oifig 2000 agus 2003 é.

Kutools le haghaidh Excel

Is é an fheidhmiúlacht atá tuairiscithe thuas ach ceann de na feidhmeanna cumhachtacha 300 de Kutools for Excel.

Deartha do Excel (Oifig) 2019, 2016, 2013, 2010, 2007 agus Office 365. Íoslódáil agus úsáid saor in aisce do laethanta 60.

Lámhach scáileán de Kutools do Excel

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

Say something here...
symbols left.
You are guest ( Sign Up? )
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.
    Arturo · 5 months ago
    Is there something similar for Google Sheets?
  • To post as a guest, your comment is unpublished.
    Christian · 1 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 · 1 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 · 4 years ago
    This function is not working, any suggestions
    • To post as a guest, your comment is unpublished.
      Algemron · 4 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 · 4 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 · 4 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 · 4 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.