Amfani da Hanyar Hanya ta Excel don Ƙara Wurin Shafi

Wanene ya san cewa wannan sauki ne?

Kamar yadda zaɓuɓɓukan Excel masu yawa, akwai hanyoyi masu yawa na saka ɗawainiya ɗaya ko fiye cikin littafi mai aiki.

Ga umarnin don hanyoyi guda uku:

1. Yin amfani da makullin gajeren maɓallin kewayawa.
2. Yin amfani da linzamin kwamfuta da takardar shafi.
3. Amfani da zaɓuɓɓukan da aka samo a kan shafin shafin shafin rubutun .

Saka Sabuwar Wurin Hanya ta Amfani da Maɓalli Keyboard

Akwai ainihin maɓallin kewayawa guda biyu don saka sabon takardun aiki a cikin Excel:

Shift + F11
ko
Alt Shift + F1

Misali, don shigar da takardun aiki tare da Shift + F11:

1. Latsa ka riƙe maɓallin Shift a kan keyboard.
2. Latsa kuma saki maɓallin F11 - located a sama da jere na lamba akan keyboard.
3. Saki da Shift key.
4. Za a saka sabuwar takarda aiki a cikin littafin littafi na yanzu zuwa dama na dukkan ayyukan aiki.
5. Don ƙara ɗakunan rubutu masu yawa suna ci gaba da danna kuma saki maɓallin F11 yayin riƙe da maɓallin Shift .

Saka bayanai da yawa ta hanyar amfani da maɓallin Ƙaramar hanya

Don ƙara fayilolin rubutu masu yawa a lokaci guda ta amfani da gajerun hanyoyi na keyboard, dole ne ka fara nuna yawan adadin ayyukan shafukan aiki don gaya Excel yadda za a kara yawan zanen gado kafin amfani da gajeren hanya na keyboard

Lura: Shafukan da aka zaɓa waɗanda aka zaɓa su kasance kusa da juna don wannan hanya don aiki.

Za'a iya yin zaɓin ƙididdiga masu yawa tare da maɓallin Shift da linzamin kwamfuta ko tare da ɗaya daga waɗannan gajerun hanyoyin keyboard:

Ctrl + Shift + PgDn - zaɓi zanen gado zuwa dama.
Ctrl + Shift + PgUp - zaɓi zanen gado a hagu.

Alal misali, don saka sababbin takardun aiki uku:

1. Danna kan shafin ɗawainiya guda ɗaya a cikin ɗawainiyar don ya haskaka shi.
2. Latsa ka riƙe maɓallin Ctrl + mai saukewa a kan keyboard.
3. Latsa kuma saki PgDn maɓalli sau biyu don nuna alama biyu zanen gado zuwa dama - zane-zane uku ya kamata a yanzu a haskaka.
4. Bi umarnin da ke sama don sa waƙa ta amfani da Shift + F11.
5. Dole ne a kara sababbin takardun muƙalma uku zuwa littafin littafi zuwa dama na dukkan takardun aiki.

Saka Sabbin Ayyuka na Tashoshi ta Amfani da Mouse da Shafuka Tabs

Don ƙara ɗawainiya ɗaya ta amfani da linzamin kwamfuta, danna kan gunkin New Sheet kusa da takardun shafukan a kasa na allo na Excel, kamar yadda aka nuna a cikin hoto a sama.

A cikin Excel 2013, sabuwar takaddun shaida shine alamar da aka nuna a cikin hoton farko a sama. A cikin Excel 2010 da 2007, icon ɗin shine hoton ɗigon ayyuka amma har yanzu yana kusa da shafukan takardun a ƙasa na allon.

Sabuwar takarda an saka shi zuwa dama na aiki ta t .

Saka bayanai da yawa don amfani da takaddun shafi da kuma linzamin kwamfuta

Duk da yake yana yiwuwa don ƙara ɗakunan rubutu masu yawa kawai ta hanyar latsa sau da yawa a kan sabuwar takardar shaidar, wani zaɓi shine:

1. Danna kan takardar takarda don zaɓi shi.
2. Latsa ka riƙe maɓallin Shift a kan keyboard.
3. Danna kan ƙarin shafukan da ke kusa da su don haskaka su - haskaka yawan adadin takardun shafuka kamar sabon zane don ƙara.
4. Danna-dama a kan ɗaya daga cikin shafuka da aka zaba don buɗe Siffar maganganun.
5. Danna kan icon ɗin Worksheet a cikin akwatin maganganu.
6. Danna Ya yi don ƙara sabon zane da kuma rufe akwatin maganganu.

Za a kara sababbin takardun muƙallan zuwa ga dama na dukkan takardun aiki.

Saka Sabuwar Takaddun shaida Amfani da Ribbon

Wata hanya don ƙara sabon saƙon rubutu shine don amfani da zaɓi Zaɓuɓɓuka wanda aka samo a kan shafin shafin shafin rubutun:

1. Danna kan shafin shafin shafin rubutun.
2. Danna kan Insert icon don buɗe jerin sauƙi na zaɓuɓɓuka.
3. Danna kan Saka takardar don ƙara sabon takardar zuwa hagu na takardar aiki.

Saka bayanai da yawa ta amfani da Ribbon

1. Bi matakan 1 zuwa 3 a sama don zaɓar nau'in adadin takardun shafuka kamar sabon zane don ƙara.
2. Danna kan shafin shafin shafin rubutun.
3. Danna kan Insert icon don buɗe jerin sauƙi na zaɓuɓɓuka.
4. Danna kan Saka takardar don ƙara sabon saitunan aiki a hagu na takardar aiki.