Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to fill up cell in Excel ?

user-image
Question ajoutée par shoaib iqbal , Personal Assistant , Waheed Associates Engineers Pvt. Ltd
Date de publication: 2014/10/20
Mohanad Khodor
par Mohanad Khodor , Senior System and Network Engineer / Team leader , Professional Communities Est

select the empty cells with the cell above it and press F2 if text. this will copy the original one in all the selected cells under it. if you have numbers cells click on the cell then on the right side of it click on the plus sign and drag down. that will give u1,2,3,4 

lots of ways to quickly and easily do it 

Madhavan  Namboodiri
par Madhavan Namboodiri , General Manager Revenue Assurance , Reliance Communications Ltd

Type the content you want to fill in the cell by using keyboard

Okoro Ejike Eugene
par Okoro Ejike Eugene , SALES REPRESENTATIVE , Certis

By dragging the first cell that contains data to fill up the lower cells in the same column with the same data.

Mohamed Shaker
par Mohamed Shaker , Quality Assurance Leader , Procter & Gamble

Ensure that the cell is not protecting from editing, it it is unprotected then select this cell and fill it with the data you want. you can drag the first cell that contains data to fill up the lower cells in the same column with the same data otherwise the first cell contains numbers, in case of containing numbers, the will change in a serial way between the lower cells

you can validate the cell to select data from a drop list or validate the cell to accept a specific type of data such as numeric or between two numbers or from a list

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?