MOVING A RANGE Select the range to move Cut select the cell from which the range will start Edit Paste ►Edit ► ► ► ► COPYING A RANGE Same operation but using the command Copy instead of Cut. ERASING A RANGE Select the range and Supr ► Edit Erase ► ► RENAMING A RANGE It is very useful to give a name to a range, especially if we use it often. This way, whenever we want to refer to it, we can do it easily. Select the range and Insert Name Define write name Add Accept ► ► ► ► ► ► The name of our range will appear inside the Names Bar► If we want to find it later, we will look for it in this bar. TRANSPOSING A RANGE Transpose means to exchange rows by columns and viceversa Select the range and ► Edit Click on the starting cell Edit Pegado especial Tick Transposing Box Accept ►Copy ► ► ► ► ► *As we click on Pegado especial, a new menu will open. It shows us the different elements we can paste from our selected range: Todo and format, formulas... All ►data
MOVING A RANGE Select the range to move ►Edit ► Cut ► select the cell from which the range will start ► Edit ► Paste COPYING A RANGE Same operation but using the command Copy instead of Cut. ERASING A RANGE Select the range and ► Supr ► Edit ► Erase RENAMING A RANGE It is very useful to give a name to a range, especially if we use it often. This way, whenever we want to refer to it, we can do it easily. Select the range and ► Insert ► Name ► Define ► write name ► Add ► Accept The name of our range will appear inside the Names Bar► If we want to find it later, we will look for it in this bar. TRANSPOSING A RANGE Transpose means to exchange rows by columns and viceversa Select the range and ► Edit ►Copy ► Click on the starting cell ► Edit ► Pegado especial ► Tick Transposing Box ► Accept *As we click on Pegado especial, a new menu will open. It shows us the different elements we can paste from our selected range: Todo All ►data and format, formulas...
3c2ba-eso-excel-2003-manual.docx