Copying data - Incremented Copy

Page visited 11820 times

 
1. When you use the Autofill handle, you can display your figures in the source cell by units of 1 if you so choose.
To do this, just press the « Ctrl » key before you drag the handle.
Excel-Exercise-Tutorial-1
 
 
 
2. And when you release the mouse, we have the following result

MAGIC

Excel-Exercise-Tutorial-2
 
 
 
3. This is true for every figure type, integer or other. Dates, however, are automatically filled. In this case the CTRL key will block the fill.
Excel-Exercise-Tutorial-3
 
 
 
4. If you wish to display your figures by 0,5 unit, watch the video.
Excel-Exercise-Tutorial-4