hat
Si ou gen yon fichye ki gen kolòn twò anpil ak ranje, ou ka vle kache tout ranje ak kolòn eksepte sa yo ki nan yon seri espesifik. Pa fè sa, ou ka fasilman rete konsantre sou done yo reyèl ou bezwen fè fas ak, oswa anpeche deplase nan travay la. Avèk sa Mete zòn Scroll sèvis piblik nan Kutools pou Excel, ou ka byen vit kache kolòn seleksyone ak ranje nan yon fwa.
eng
If you have a worksheet with too many columns and rows, you may want to hide all rows and columns except those in a specific range. By doing this, you can easily stay focus on the actual data you need to deal with, or prevent moving around in the worksheet. With this Set Scroll Area utility of Kutools for Excel, you can quickly hide unselected columns and rows at once.