Share layin ɓoye a cikin Foreved. Daya da duka lokaci daya

A cikin Microsoft Office Excel, ba za ku iya cire abin da sauri a ɓoye ba, wofi wanda ya lalata bayyanar tebur da yawa. Yadda ake yin wannan za a gaya a wannan labarin.

Yadda za a Cire Lines a Ingila

Akwai hanyoyi da yawa don aiwatar da aikin da aka aiwatar ta amfani da kayan aikin shirin. Bayan haka, abin da ya fi dacewa da su za a yi la'akari da su.

Hanyar 1. Yadda za a cire layin a cikin tebur ɗaya ta menu na mahallin

Don jimre wa wannan aikin, ana bada shawara don amfani da waɗannan algorithm masu zuwa:

1. Zaɓi layin da ake so na tebur da yawa na lkm.
2. Latsa kowane wuri da aka keɓe yankin-latsa.
3. A cikin menu na mahallin, danna kan kalmar "share ...".

Hanya zuwa Window ɗin Share na Kwayoyin Sel a Microsoft Office Excel

1. A cikin taga da ke buɗe, sanya canjin canjin kusa da "string" sigogi kuma danna Ok.

Zaɓi zaɓi daidai don cire layin a cikin tebur

1. Duba sakamakon. Da aka zaba dole ne a cire shi.
2. Yi wannan hanyar tare da sauran abubuwan farantin.

Hanya 2. guda cirlestLing kirtani ta hanyar zaɓi a cikin tef na shirin

Excel yana da daidaitattun kayan aikin don cire sel mai ƙarfi. Don amfani da su don cire layi, kuna buƙatar yin amfani da wannan:

1. Zaɓi wani tantanin halitta a cikin igiyar da kake son sharewa.
2. Je zuwa shafin "gida" a cikin Panelan Left Panel.
3. Nemo maɓallin Share kuma yana tura wannan zaɓi ta danna dattijo a hannun dama.
4. Zaɓi zaɓi "Share layuka daga takarda".

Algorithm don sharewa da layin da aka zaɓa daga wurin aiki ta hanyar ingantaccen kayan aiki

1. Tabbatar cewa sitit wanda aka zaba da farko an cire shi.

Hanyar 3. Yadda za a Cire duk layin ɓoye nan da nan

Tarawa kuma yana aiwatar da yiwuwar kungiyar shigar da shigar da abubuwan da aka zaɓa na tebur ɗin da aka zaɓa. Wannan zabin yana ba ku damar cire layin wofi da aka watsa a sassa daban-daban na farantin. Gabaɗaya, an rarraba tsarin aiwatar da orestall zuwa waɗannan matakai:

1. Ta hanyar makamancin wannan, canzawa zuwa shafin gida.
2. A cikin yankin da ya buɗe, a cikin "gyarawa", danna maɓallin "Sami da kuma ke ƙarƙashin maɓallin".
3. Bayan aiwatar da aikin da ya gabata, menu na mahallin zai bayyana, wanda mai amfani zai buƙaci danna kan layi "zabar gungun sel ...".

Kasaftawa duk wani layin komai a cikin tsari nan da nan ta "Sami da kuma Canza" Zabi na Forevet

1. A cikin taga da aka nuna, dole ne ka zaɓi abubuwan da zasu haskaka. A cikin wannan halin, ya kamata ka sanya kunna canjin kusa da "wofi sel" siga ka danna "Ok". Yanzu a cikin tushen tebur ya kamata a lokaci guda ya tsaya a kan duk layin fanko ba tare da la'akari da wurinsu ba.

Zabi na Layin komai a cikin taga Zauren Sel

1. Dama-mabuɗen Manipulator Latsa danna kowane ɗayan layin da aka zaɓa.
2. A cikin mahallin taga taga, danna kan kalmar "share ..." kuma zaɓi zaɓi "kirtani". Bayan danna "Ok", duk abubuwan da aka ɓoyewa sun cire.

Kungiyar ta cire abubuwan haɗin ciki

Farantin tare da tsararren tsari a hanyar Excel Hanyar 4. Aikace-aikace na rarrabewa

Hanya ta ainihi wanda aka yi gwargwadon wannan algorithm mai zuwa:

1. Zaɓi filin tebur. Wannan yanki wanda za'a ware bayanai.
2. A cikin shafin gida, tura sutturar da tace.
3. A cikin taga da ta bayyana, zaɓi zaɓi "Abincin zaɓi" ta danna kan shi tare da lkm.

Hanya zuwa taga na raba al'ada

1. A cikin menu na daidaita daidaitacce, saka alama a gaban "bayanan na" sun ƙunshi labarai.
2. A cikin shafi, saka kowane zaɓuɓɓukan rarrabe: ko dai "daga A zuwa Z" ko "daga gare ni zuwa".
3. A ƙarshen saiti na rarrabewa, danna "Ok" a kasan taga. Bayan haka, bayanan a cikin tebur karbi za a tsara ta hanyar da aka ƙayyade.

Ayyukan da ake buƙata a cikin menu na daidaita daidaitacce

1. A cewar makircin da aka tattauna a sashin da ya gabata na labarin, ware duk layin ɓoye da share su.

Yankewa dabi'u ta atomatik fallasa duk layin fanko zuwa ƙarshen farantin.

Cire Lines marasa amfani, wanda aka sa a kai zuwa ƙarshen teburin da aka tsara bayan hanyar rarrabawa 5. Aika tace

A cikin allunan Fifice, yana yiwuwa a tace ƙayyadaddun abubuwan da aka ƙayyade, ya bar kawai bayanin da ake buƙata a ciki. Wannan hanyar zaku iya cire kowane zaren daga tebur. Yana da mahimmanci aiki bisa ga algorithm:

1. Maɓallin hagu na bayanan yana haskaka naúrar.
2. Je zuwa sashin "bayanai", wanda yake a saman menu na wannan shirin.
3. Latsa maɓallin "tace". Bayan haka, kibiyoyi zasu bayyana a cikin taken kowane shafi na tsararru.

Sanya matattara zuwa teburin tushen tushen da ke fice

1. Latsa lkm a kan kowane kibiya don tura jerin matatun masu tace.
2. Cire alamun bincike daga dabi'u a cikin layin da ake so. Don cire madaidaicin igiyar, zaku buƙaci bayyana lambar jerin sa a cikin tebur din.

Cire layuka da ba dole ba ta hanyar tabo

1. Duba sakamakon. Bayan danna "Ok", ya kamata a dauki canje-canje cikin ƙarfi, kuma za a cire abubuwan da aka zaɓa.

Ƙarshe

Don haka, a cikin Microsoft Office Frev Excel cire cire cire ruwa a cikin tebur yana da sauki sosai. Wannan ba lallai ba ne don ya zama mai amfani mai amfani. Ya isa don amfani da ɗayan hanyoyin da ke sama wanda ke aiki da kansa daga tsarin software.

Saƙo Cire ɓoye kirtani a Excel. Daya kuma duk nan da nan ya bayyana da farko akan fasahar bayanai.