Press the Paste under the icone paste to view the options.įrom the list of options, select Transpose.įrom the list of options of the context menu, select Paste special.
Here is an example.Įnter the values in the appropriate cells. The Transpose option consist of "turning" a range of cells on its side. This option will paste the formula, the value and other presentation elements except the border. For example, if the result of the formula =A1*A2 is 225, the Paste Values option will place the value 225 instead of the formula. This option will paste the value of the cell instead of copying the formula. This option allows you to copy only the formulas you cut or copied without taking into consideration the formatting such as the font style, its size and its background color. It will either copy the text, the value or the formula from the source cell into the selected cells. This option works like the basic Paste command.
There is first the option is a basic Paste that will paste to the location of your choice the element that was cut or copied.īy pressing the second half of the Paste button, you will have access to all the possible options for this command. They will be descripbed later in this text. This option also offers many possibilities. The Paste command consists to placing the content of the cell, or range of cells, that you cut or copied into a new location. For example, the cell blinking will stop as soon as you go start to write in another cell. The border of the cells you selected to copy, or the source, will blink until you stop copying it. For example, you can recopy one or many formulas to many other cellsin your model. The Copy command allows you to select the element of your choice, leave it at the same location and paste it to as many other places. You must select an object, cut it so that you can paste it elsewhere. The Cut option allows you to move an object from one location to another. It can also reproduce the formatting of a cell with Format painter. Since Office 2003, it can contain and manipulate many objects at the same time. You will find in the clipboard all the commands and options to cut, copy and paste objects. This web page concentrates on explaining the commands under this tab. The Home tab represents theįirst step and is composed mostly of basic commands. Each tab represents a step in creating a document. Microsoft Excel introduced a new menu structure called the Ribbon.
0 kommentar(er)
