Ho sebelisa Shortcut ea Excel ho Add Sheet Worksheets

Ke mang ea tsebang hore ho bonolo ho e etsa?

Joalo ka likhetho tse ngata tsa Excel, ho na le mekhoa e mengata ea ho kenya e le ngoe kapa lipampiri tse ling ka har'a buka ea mosebetsi e teng.

Mona ke litaelo tsa mekhoa e meraro e sa tšoaneng:

1. Ho sebelisa linotlolo tsa melaho lebokoseng.
2. U sebelisa mouse le tabeng ea lakane.
3. Ho sebelisa dikgetho tse ka lebokoseng la Lehae la Ribbon .

Kenya New Worksheet Ho Sebelisa Shortcut Keyboard

Ho na le likarolo tse peli tsa keykey bakeng sa ho kenyelletsa leqephe le lecha la Excel:

Shift + F11
kapa
Alt + Shift + F1

Ka mohlala, ho kenya leqephe le Shift + F11:

1. Tlanya le ho tšoara konopo ea Shift lebokoseng.
2. Tlanya le ho lokolla senotlolo sa F11 - se ka holimo ho nomoro ea nomoro lebokoseng.
3. Lokolla senotlolo sa Shift .
4. Tlhahiso e ncha e tla kenngoa bukeng ea hona joale ea ho sebetsa ho le letona la li-sheshe tsohle tse teng.
5. Ho eketsa maqephe a mangata a maqephe a tsoelapele ho hatella le ho lokolla senotlolo sa F11 ha o ntse o boloka konopo ea Shift .

Kenya Lipampiri Tse Fapaneng Tse Sebelisang Shortcut Shortcut

Ho eketsa maqephe a mangata ka nako e le 'ngoe u sebelisa meqotlo ea lebokose e ka holimo, o tlameha ho qala ho totobatsa palo ea likhaba tsa lipampiri tse teng hore u bolelle Excel hore na likhaete tse ncha li lokela ho kenyelletsoa pele u sebelisa kemiso ea lebokose

Tlhokomeliso: Likarabo tse khethiloeng tsa mosebetsi li tlameha ho ba haufi le e mong bakeng sa mokhoa ona ho sebetsa.

Ho khetha maqephe a mangata ho ka etsoa ka sesepa sa Shift le mouse kapa ka e 'ngoe ea mekhoa ea khetho ea keyboard:

Ctrl + Shift + PgDn - e khetha lipampiri ka ho le letona.
Ctrl + Shift + PgUp - e khetha lipampiri ka ho le letšehali.

Ka mohlala, ho kenya lipampiri tse ncha tse tharo:

1. Tobetsa tabeng e le 'ngoe ea lipampiri bukeng ea mosebetsi ho e totobatsa.
2. Tlanya le ho tšoara linotlolo tsa Ctrl + Shift lebokoseng.
3. Tlanya le ho lokolla letšoao la PgDn ka makhetlo a mabeli ho totobatsa maqephe a mabeli ka ho le letona-maqephe a mararo a lokela ho totobatsoa hona joale.
4. Latela litaelo tse ka holimo bakeng sa ho kenyelletsa lipampiri ho sebelisa Shift + F11.
5. Lihlahisoa tse tharo tsa lipampiri li lokela ho kenngoa bukeng ea mosebetsi ho le letona la li-sheshe tsohle tse teng.

Kenya New Excel Worksheets Ho Sebelisa Mouse le Li-Tab

Ho eketsa leqephe le le leng le sebelisang mouse, tobetsa letšoao la Sehlopha se Ncha se fumanehang haufi le likhaba tsa maqephe ka tlase ho skrine ea Excel, joalokaha ho bontšoa setšoantšong se ka holimo.

Ho Excel 2013, letšoao le lecha le letšoao le letšoao le bontšitsoeng ka setšoantšo sa pele ka holimo. Ka Excel 2010 le 2007, setšoantšo ke setšoantšo sa leqephe la lipampiri empa se ntse se fumaneha haufi le likhaba tsa maqephe ka tlase ea skrine.

Letlapa le lecha le kenngoa ka letsohong le letona la terene e sebetsang .

Kenya Lipampiri Tse Fapaneng tsa Sebelisoang ka Thabiso ea Lintlha le Mouse

Ha ho ntse ho khoneha ho kenya litokomane tse ngata ka ho tobetsa makhetlo a 'maloa setšoantšong se secha, ho khetha ho:

1. Tobetsa lebopeng le le leng ho u khetha.
2. Tlanya le ho tšoara konopo ea Shift lebokoseng.
3. Tobetsa litabeng tse ling tse ka tlaase tsa leqephe ho li totobatsa - totobatsa palo e lekanang ea likhaba tsa lekhabiso e le maqephe a macha a lokelang ho kenngoa.
4. Tlanya ka ho le letona ho e 'ngoe ea lihlopha tse khethiloeng ho bula lebokose le reng Insert box.
5. Tobetsa setšoantšo sa Worksheet ka fensetereng ea lebokose la lebokose la lihlooho.
6. Tobetsa OK ho kenya maqephe a macha mme u koale lebokose la lebokose.

Liphetolelo tse ncha li tla kenyelletsoa ho le letona la li-sheshe tsohle tse teng.

Kenya New Worksheet Ho Sebelisa Ribone

Tsela e 'ngoe ea ho eketsa leqephe le lecha ke ho sebelisa kgetho ea ho kenya e ka tlung ea Lehae ea Ribbon:

1. Tobetsa Thabeng ea Lehae ea Ribbon.
2. Tobetsa ho letšoao la ho kenya ho bula menu ea theoha ea dikgetho.
3. Tobetsa ho kenya Lethathamo ho kenya lakane e ncha ho ea ka letsohong le letšehali la leqephe le sebetsang.

Kenya Lipampiri Tse Fapaneng Tse Sebelisang Ribbon

1. Latela mehato ea 1 ho ea holimo ka holimo ho khetha nomoro e lekanang ea lipampiri e le maqephe a macha a ho kenyelletsoa.
2. Tobetsa Thabeng ea Lehae ea Ribbon.
3. Tobetsa ho letšoao la ho kenya ho bula menu ea theoha ea dikgetho.
4. Tobetsa ho kenya Lethathamo ho kenya lipampiri tse ncha ka letsohong le letšehali la leqephe le sebetsang.