Skip to main content

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

Kutools le haghaidh Excel

Treisíonn Excel Le 300+
Gnéithe cumhachtacha

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 2021, 2019, 2016, 2013, 2010, 2007 agus Oifig 365.

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 do Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 agus Office 365. Íoslódáil agus úsáid saor in aisce ar feadh 30 lá.

Scáileán de Kutools le haghaidh Excel

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

Comments (20)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there a way to easily split these worksheets into separate workbooks instead? I have to create 213 workbooks of split data based on a column. It splits it out into sheets which is good too but I then have to manually save each one as a workbook. Just wondering if there is a work around that would speed up the process?
This comment was minimized by the moderator on the site
Hello, Ronel,

Sorry, currently, our feature doesn't support this operation. However, I've conveyed your request to our development team. Should there be any updates, we'll notify you promptly.

Thanks for your feedback.
This comment was minimized by the moderator on the site
It works well, How can I fetch all data from different sheeets to one sheet?

any one to help
This comment was minimized by the moderator on the site
Hello, PETER
To merge data from multiple sheets into one single sheet, the following article may help you.
https://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html
or you can use our Kutools for Excel 's Combine multiple worksheets from workbooks into one worksheet to solve this task, please check this article:
https://www.extendoffice.com/product/kutools-for-excel/excel-combine-worksheets-into-one.html
Please check it, if you have any other problem, please comment here again.
This comment was minimized by the moderator on the site
This split function is really helpful but I need total also in subsequent split sheets. What should I do? Please help
This comment was minimized by the moderator on the site
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 thanksNaomi
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Is there something similar for Google Sheets?
This comment was minimized by the moderator on the site
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?
This comment was minimized by the moderator on the site
Has there been a resolution to this? I am unable to split data into multiple worksheets based on the content of a column.
This comment was minimized by the moderator on the site
This function is not working, any suggestions
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations