Yuav Luam Li Cas Tsuas Yog Pom Cov Cells hauv Excel: 9 Kauj Ruam

Cov txheej txheem:

Yuav Luam Li Cas Tsuas Yog Pom Cov Cells hauv Excel: 9 Kauj Ruam
Yuav Luam Li Cas Tsuas Yog Pom Cov Cells hauv Excel: 9 Kauj Ruam

Video: Yuav Luam Li Cas Tsuas Yog Pom Cov Cells hauv Excel: 9 Kauj Ruam

Video: Yuav Luam Li Cas Tsuas Yog Pom Cov Cells hauv Excel: 9 Kauj Ruam
Video: koj lam ua txuj zoo rau saum luag.nkauj tawm tshiab by Kablia vwj. 2024, Tej zaum
Anonim

Los ntawm lub neej ntawd, thaum koj luam cov cell hauv Excel, qhov kev zov me nyuam luam tawm zais thiab lim cov cell nrog rau pom cov cell. Qhov wikiHow no yuav qhia koj li cas luam theej duab tsuas yog pom cov cell kom koj tsis txhob theej cov ntaub ntawv tsis tsim nyog. Koj yuav tsum tau siv lub khoos phis tawj desktop los ua qhov no vim tias lub vev xaib tsis muaj qhov tshwj xeeb uas koj xav tau.

Cov kauj ruam

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 1
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib koj daim ntawv hauv Excel

Koj tuaj yeem qhib koj daim ntawv los ntawm hauv Excel los ntawm kev mus rau File> Qhib lossis koj tuaj yeem nyem rau ntawm cov ntawv hauv koj cov browser browser, xaiv Qhib Nrog thiab Excel.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 2
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 2

Kauj Ruam 2. Xaiv cov ntaub ntawv koj xav luam

Koj tuaj yeem xaiv ib lub xov tooj ntawm tes lossis ntau ntxiv los ntawm kev rub thiab xa koj cov ntawv xaiv.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 3
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem rau Home tab (yog tias nws tseem tsis tau xaiv)

Koj yuav pom qhov no nyob rau sab saum toj ntawm koj daim ntawv kho kom raug.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 4
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 4

Kauj Ruam 4. Nyem Nrhiav & Xaiv hauv qab ntawm ob lub tsom iav

Koj yuav pom qhov no mus rau sab xis ntawm lub qhov rais tom ntej ntawm lub cim ntawm lub lim dej hauv pawg "Kho kom raug neeg".

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 5
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 5

Kauj Ruam 5. Nyem Mus Rau Tshwj Xeeb

Qhov no feem ntau yog cov npe thib plaub hauv cov ntawv qhia zaub mov nco. Qhov "Mus Rau Tshwj Xeeb" lub qhov rooj sib tham yuav pop-up.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 6
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 6

Kauj Ruam 6. Nyem sau lub voj voog nyob ib sab ntawm "Pom cov cell nkaus xwb

" Lub voj voos yuav sau kom pom tias nws raug xaiv.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 7
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 7

Kauj Ruam 7. Nyem OK

Koj yuav pom qhov no hauv qab ntawm lub qhov rai pop-up. Txhua cov ntaub ntawv zais yuav tsis raug xaiv los ntawm koj xaiv.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 8
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 8

Kauj Ruam 8. Nias Ctrl+C. (Windows) lub ⌘ Cmd+C (Mac).

Koj yuav luam cov ntaub ntawv pom.

Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 9
Luam Tsuas Yog Pom Cov Cells hauv Excel Kauj Ruam 9

Kauj Ruam 9. Muab tshuaj txhuam koj xaiv

Tsuas yog cov cell uas tau pom yuav muab tso rau. Koj tuaj yeem nias Ctrl+V (Windows) lossis ⌘ Cmd+V (Mac) los muab tshuaj txhuam.

Pom zoo: