Skip to main content

Conas bosca téacs a chruthú le scrollbharra in Excel?

Is uirlis úsáideach é bosca téacs dúinn roinnt faisnéise moltach a chur le sonraí na mbileog oibre. Uaireanta, caithfimid bosca téacs beag a chur isteach ina bhfuil ábhar mór, sa chás seo, ní thaispeánfar an t-ábhar go hiomlán mura gcliceálann tú an bosca téacs. Má tá barra scrollbharra sa bhosca téacs, beidh sé furasta an t-ábhar a fheiceáil agus tá cuma álainn ar an mbosca téacs freisin.

Cruthaigh bosca téacs le scrollbharra in Excel

mboilgeog cheart gorm saighead Cruthaigh bosca téacs le scrollbharra in Excel

In Excel, ní féidir leat ach an scrollbharra a chur isteach don bhosca téacs a chaithfidh a bheith Rialuithe ActiveX foirm amháin. Déan mar seo le do thoil:

1. Chun bosca téacs a chur isteach trí chliceáil Forbróir > Ionsáigh > Bosca téacs, féach ar an scáileán:

doc-add-scrollbar-to-text-box1

2. Ansin tarraing an luch chun bosca téacs a tharraingt de réir mar is gá duit.

doc-add-scrollbar-to-text-box1

3. Agus ansin cliceáil Forbróir > Airíonna leis an mbosca téacs roghnaithe, féach an scáileán:

doc-add-scrollbar-to-text-box1

4. Sa an Airíonna dialóg, roghnaigh True ó na Illíne titim anuas, ansin roghnaigh 2-fmScrollBarsIngearach ó na Barraí Scrollaigh liosta anuas. Féach an pictiúr:

doc-add-scrollbar-to-text-box1

5. Tar éis na socruithe a chríochnú, dún an Airíonna dialóg, agus cliceáil ar an Mód Dearaidh imeacht as an Mód Dearaidh. Agus nuair a iontrálann tú ábhar mór atá níos faide ná an bosca téacs, cuirfear an scrollbharra go huathoibríoch. Féach an pictiúr:

doc-add-scrollbar-to-text-box1

nótaí: In Excel, níl ach an Rialuithe ActiveX is féidir bosca téacs foirme a chur leis an scrollbharra.

Earraí gaolmhara:

Conas scrollbharra a chur le cairt in Excel?

Conas téacs faoi leith a aimsiú agus a athsholáthar i mboscaí téacs?

Conas téacs a aimsiú agus a athsholáthar i dteidil cairte in Excel?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (8)
No ratings yet. Be the first to rate!
Stephanie
Stephanie
This comment was minimized by the moderator on the site
I used this tutorial to set up 3 text boxes within one sheet however the scroll bars in the text boxes disappear when I open the excel sheet in excel. It is tremendously frustrating because half of the information is not visible because the scroll bars disappear and then when I click the text box, the text size changes and becomes very tiny and the only way to fix it is by going into design mode and changing the font size. Is there a way to make sure the scroll bars show up?
Reply
0
0
Myrthe
Myrthe     Stephanie
This comment was minimized by the moderator on the site
Stephanie, did you ever find an answer to this? I have the same problem.
Reply
0
0
Patti P.
Patti P.
This comment was minimized by the moderator on the site
I figured out how to add the scrolling text box, however, I need to be able to copy and paste the column where the text box is housed and have the text box and its contents move with the column. I have active and discharged clients in two separate worksheets and the client column may need to be cut and pasted from one to the other. Is this possible to do?
Reply
0
0
Sab En
Sab En
This comment was minimized by the moderator on the site
Thank you for providing step by step instructions for this. Works fine till I exit out of design mode. When I click on the cell with the text box and scroll bar though, the size of my text is less than 2 or 3 so you can't read anything at all. Not sure why this is happening though. The font size for the excel file is set to 11.
Reply
0
0
Kees van Hasselt
Kees van Hasselt
This comment was minimized by the moderator on the site
Hi folks, above works fine. However I would really like to be able to format the text within the textbox like I can with a 'normal' textbox (bold/normal font, underlining, aligning, formatting, etc.). Now as far as I can see I can only change the overall text font size and bold/normal. Does anyone know how to do that?
Reply
0
0
Bekki
Bekki     Kees van Hasselt
This comment was minimized by the moderator on the site
Just wondering but did you ever find an answer to this? I'm looking to do the same thing if possible.
Reply
0
0
Frumpy Jones
Frumpy Jones
This comment was minimized by the moderator on the site
Quick follow up question to this: Is it posible to make the wheelmouse work from withing the textbox with scrollbars? Loked at all the properties and saw nothing that makes sense to me, but I am so not a programmer anymore :(
Reply
0
0
Patrick
Patrick
This comment was minimized by the moderator on the site
I would like to link the text box to a different tab so as I add text on that tab the information will appear in this text box with scroll bar.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations