Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

In an Excel Sheet , when you write an English day as (Saturday in a cell and then you wanna complete the days of the week ,?

you'l just drag the cell down and it will be completed ) but when writing an Arabic day  , How does it work?

user-image
Question ajoutée par samia kouadri , Document control , Rowad Modern Engineering
Date de publication: 2016/02/11
مصطفى صابر عبدالله hamada
par مصطفى صابر عبدالله hamada , كشير , سلسه سوبر ماركت كارفور

Mobilize the series and dates of numbers or other elements of the series are builtYou can quickly mobilize cells within the scope of a series of numbers or dates, or built-in days or days of the week or months or years, a series using the fill handle or order filling.Fill cells with a series using the fill handle, select the first cell in the range you want to fill. Type the beginning of the value chain. Type a value in the next cell to establish a pattern. For example, if you want a series of numbers 1, 2.3, 4.5 ..., type 1 and 2 in the first two cells. If you want a series of numbers 2.4, 6.8 ..., type 2 and 4. And if you want a series of numbers 2.2, 2.2 ..., you can leave the second cell empty. Select the cell or cells that contain the starting values. Drag the fill handle the fill handle across the range you want to fill. Mobilization in an increasing order, drag down or to the left. To mobilize in decreasing order, drag up or to the right. Note You can also set the type of the chain using the right mouse button to drag the fill handle on the scale, and then clicking the appropriate command from a short list. For example, if the date is January 2007 represents a starting value, click the mobilization of months to get the February series in 2007, and in March 2007, and so on; or click Fill years to get the January 2007 series, and in January 2008, and so on. If the selection on the figures contained, you can control in the series you want to create the type. You can turn off the automatic packing by holding down the Ctrl when you drag the fill handle to select from two or more cells. It is then copied to the specified values ​​of adjacent cells, and Excel will expand the chain.

More Questions Like This