Skip to main content

Go héasca ag léamh / ag breathnú ar líon mór sraitheanna agus colúin in Excel

Kutools for Excel

Treisíonn Excel Le 300+
Gnéithe cumhachtacha

Má oibríonn tú ar an mbileog oibre ina bhfuil sonraí ollmhóra leis na céadta sraitheanna agus colúin, b'fhéidir go mbeidh tú ag fáil puzzles go héasca agus tú ag seiceáil agus ag léim na sonraí ó cheann go ceann eile a chuirfidh am amú. Chun an fhadhb seo a réiteach, tá fóntais Grid Focus de Kutools for Excel leagann sé béim ar an tsraith trasna agus ar an gcolún chun an chill nó an raon gníomhach a dhéanamh den scoth mar a thaispeántar thíos. Demo

leagan amach léitheoireachta lámhaigh 2

Cumasaigh fóntais Grid Focus

cliceáil Kutools > Fócas Eangaí chun an áirgiúlacht seo a chumasú, cé go bhfuil an Fócas Eangaí cumasaithe, aibhsítear an cluaisín.
leagan amach léitheoireachta lámhaigh 2

Socruithe Fócas Eangaí

Más mian leat na socruithe ar nós na cruthanna, na stíleanna, na dathanna nó na trédhearcachta a athrú, is féidir leat dul chuig an Socrú Fócas Eangaís dialóg le hathrú.

cliceáil Kutools cluaisín, agus téigh chun cliceáil ar an saighead in aice leis Fócas Eangaí chun an roghchlár anuas a leathnú, ansin cliceáil Socruithe Fócas Eangaí.
leagan amach léitheoireachta lámhaigh 2

sa Socruithe Fócas Eangaí dialóg, is féidir leat na cruthanna, na stíleanna, na dathanna agus an trédhearcacht a theastaíonn uait a athrú, ag an am céanna is féidir leat réamhamharc a dhéanamh ar an athrú i réamhamharc alt sula ndéanann tú na hathruithe a chur i bhfeidhm.
leagan amach léitheoireachta lámhaigh 2

Maidir Aibhsigh réimse na cille gníomhaí agus Aibhsigh an limistéar ar eagarthóireacht cille roghanna.

Cuir tic Aibhsigh réimse na cille gníomhaí rogha, cuirfear béim ar an gcill nó ar an raon gníomhach.

leagan amach léitheoireachta lámhaigh 2

Díthiceáil Aibhsigh réimse na cille gníomhaí rogha, ach tic a chur ar an Aibhsigh an limistéar ar eagarthóireacht cille rogha, ní thabharfar aird ar an gcill nó ar an raon gníomhach, ach aibhsítear an limistéar atá ag cur thar maoil.

leagan amach léitheoireachta lámhaigh 2

Untick an dá Aibhsigh réimse na cille gníomhaí agus Aibhsigh an limistéar ar eagarthóireacht cille ní thabharfar aird ar roghanna, idir an chill ghníomhach nó an raon agus an limistéar atá ag cur thar maoil.

leagan amach léitheoireachta lámhaigh 2

Cumasaigh Fócas Eangaí: cuir tic leis an rogha seo, tar éis socruithe agus cliceáil OK, beidh an Fócas Eangaí cumasaithe go huathoibríoch.

Socruithe Réamhshocraithe: cliceáil ar an gcnaipe seo, tá na socruithe Grid Focus curtha ar ais chuig na socruithe réamhshocraithe de Kutools.

Nótaí:

1. Is féidir leat an fóntais seo a chealú trí chliceáil ar an Fócas Eangaí ordú, athraíonn an cluaisín go liath éadrom.

2. Má osclaíonn tú ilchomhaid Excel, seo Fócas Eangaí cuirtear gné i bhfeidhm ar gach ceann acu.

3. Seo Fócas Eangaí ní chumasófar go huathoibríoch é nuair a sheolfaidh tú an leabhar oibre an chéad uair eile.

Taispeántas Fócas Eangaí


Kutools for Excel: Breis is 300 uirlis láimhe ar do mhéar! Cuir tús le do thriail saor in aisce 30-lá gan aon srianta gné inniu. Íosluchtaigh 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?
    Office Tab: Cluaisíní úsáideacha a úsáid i d’Oifig, mar bhealach Chrome, Firefox agus New Internet Explorer.
    Kutools for Excel: Níos mó ná 300 Ardfheidhmeanna le haghaidh Excel 2021, 2019, 2016, 2013, 2010, 2007 agus Oifig 365.

    Kutools for Excel

    Níl san fheidhmiúlacht a thuairiscítear thuas ach ceann amháin de 300 feidhmeanna cumhachtacha de Kutools for 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á.

    Gabháil scáileáin de Kutools for Excel

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

Comments (17)
No ratings yet. Be the first to rate!
mennan
mennan
This comment was minimized by the moderator on the site
Why doesn't it open automatically at startup? it would be nice to remember the last setting
Reply
Report
0
0
skyyang
skyyang     mennan
This comment was minimized by the moderator on the site
Hello, Mennan,
Sorry for the inconvenience, for the stability of the function, our feature is disabled when opening next time at present, but the last setting and operation can be remembered.
Thanks for your comment.
Reply
Report
0
0
Dejan
Dejan
This comment was minimized by the moderator on the site
I have a problem with the reading layout. Every time when I start it, it behaves strangely. It "chose" a smaller size of the sheet than it is actually on my screen and it works in that sheet. Eg: if I see on my screen columns range from A up to AC and rows range from 1 up to 39, the reading layout chooses that my columns range from A up to half of X and rows range from 1 up to half of 32 and works in that let's call it window.
I tried to uninstall kutools and install it again, but the same problem remains.
Any wise advice would be appreciated from my side.
I am running MS office professional plus 2021.

Thanks in advance
Reply
0
0
Dejan
Dejan     Dejan
This comment was minimized by the moderator on the site
I might detected the problem. I am running 3 displays, one from a laptop 15,6" and two others 24" over wavlink dock. All three displays are running at a resolution of 1920 x 1080. My main display is from the laptop.
I am using excel on another two 24" displays just because they have a bigger screen. When I put excel on the laptop window reading layout behaves as it should, and that is the exact size of the sheet that I previously described as a smaller window.
Reply
0
0
skyyang
skyyang     Dejan
This comment was minimized by the moderator on the site
Hello, Dejan,
Thanks for your comment.
I have fed back this problem to the developers, if there is a an upgrade or fixed, we will let you know in the first time.
Reply
Report
0
0
Andrei
Andrei
This comment was minimized by the moderator on the site
If you make this auto load when opening excel I will buy this product. :D
Reply
0
0
skyyang
skyyang     Andrei
This comment was minimized by the moderator on the site
Hi, Andrei

Thanks for your comment, your suggestion has been fed back to the developers, if there's an upgrade, I'll let you know in the first time. 😄
Reply
Report
0
0
Mohan
Mohan
This comment was minimized by the moderator on the site
Very Good Service Nice blog
Reply
0
0
TractorGuru
TractorGuru
This comment was minimized by the moderator on the site
Hello, Thanks for sharing this informative blog with us.
Reply
0
0
simon@netready.biz
This comment was minimized by the moderator on the site
This feature is great. Bear in mind I had an existing Excel file where this button was ALWAYS disabled. I had to copy-and-paste the data out of the file and save it into a new file to get the "Reading Layout" button to enable. It then worked fine.
Reply
Report
0
0
Excelfans
Excelfans    
This comment was minimized by the moderator on the site
Hello,

Please try to update to the latest version. We have enhanced it.🙂
Reply
Report
0
0
Lindomar
Lindomar
This comment was minimized by the moderator on the site
se eu compra a licença consigo instalar mais de uma vez no pc ou só serve uma vez ?
Reply
0
0
Andrew
Andrew
This comment was minimized by the moderator on the site
This solved one of my biggest headaches. I have one program that outputs a report that when exported to Excell it creates 200 worksheets! I have never been able to use it until now. Merging all of them into one worksheet only takes a few minutes with Kutools.
Reply
0
0
Arun
Arun
This comment was minimized by the moderator on the site
Thanks A lot of this product, mainly its use for reading layout & shortcuts of left side menu
Reply
0
0
Rodger A Sanders
Rodger A Sanders
This comment was minimized by the moderator on the site
My OS: Windows 7 Pro fully updated My Excel: 2010 My sheet: Range R1C6:R504C6 is in use PROBLEM: READING LAYOUT FAILS TO FILL ROW AND COLUMN SELECTED 1. Magnification: 60% 2. Rows 313-355 show 3. Cell R354:C6 selected 4. Column 5 fills to row 323. Row 354 no fill 5. Mag to 50% 6. Rows 311-357 show 7. Column 5 fills top to bottom. Row 354 fills left to right 8. Mag to 60%. Goto 4. 9. Mag to 70%. 10. Rows 319-354 show 11. Column 6 fills to row 325. Row 354 is empty. 12. Click R354:C6 13. No change! 14. WHY? NOTE: At 60% magnification selecting any cell on visible sheet on rows greater than 323 demonstrates same problem. Selecting row 323 or lower i.e R320 the function works as expected with row and column selected but only to row 323!
Reply
0
0
Excelfans
Excelfans     Rodger A Sanders
This comment was minimized by the moderator on the site
Hello,

Please try to update to the latest version. We have enhanced it.
Reply
Report
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations