0
What button in excel allows you to copy values with or without formatting or the format only?
Wiki User
∙ 11y ago
Copy the values by either highligting the cells and clicking copy or by highlighting the cells and using the keyboard shortcut of ctrl+c ( apple users apple + C) then paste the copied data into its new location. When pasting the data right click in the designated cell or use paste special and select the formatting of your choice Values only, values with source formatting or values with destination formating.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
Does the format painter button copies both the cell's content and formatting?
No. It only copies the formatting. It does not copy content.
What is a button that allows you to choose weather to copy the values from the source to the destination area with formatting without formatting or copy only the format?
After you paste your text into the new cell, before you click away from it there should be a small picture of a clipboard that pops up next to the pasted text. When you click on that it will give you the different formatting options.
Which Office tool allows you to copy formatting from one area of your document to others?
The Format Painter. You can also use Paste Special and choose just to paste the formatting.
What allows you to copy all formatting changes from one object to another?
format painter
What does the format button allows you to do in Excel?
You may be referring to the format painter button, which has a little paintbrush on it. What it does is take the formatting from one cell or a set of cells, and applies it to other cells. So if you do something like put a number into a cell, bold it, colour the cell red, format the number to 2 decimal places and change the font size, that cell will have that formatting. To do the same for other cells may take some time. So what you can do is first select that cell and click on the format painter button. Then you would select a range of cells that you want to apply that formatting to. It will immediately format all the cells to be the same as the original one. It won't change any numbers or formulas in those cells, just change the formatting. So it is painting the formatting of one cell onto other cells.
How do you activate the format painter button?
Click on the cell that you want to take formatting from. If you click once on the Format Painter, you can then click on another cell and it will receive the formatting from the other cell and the Format Painter will be deactivated. If you double click on the Format Painter, then it is turned on until you click on it again, meaning you can apply formatting to lots of cells.
What button copies multiple formats from selected cells to other cells?
The button that you can use to apply multiple formatting style to selected cell is called format painter (the icon is a little brush on the "standard" toolbar). The way it works is as follows: 1/ select an area of the spreadsheet that already have the formatting that you want to use. 2/ click on the format painter button on the standard toolbar. 3/ select the area of the spreadsheet where you want to copy the formatting. That's all. Note that if you want to apply the same formatting in several places, you can double click on the format painter button in step 2/ instead of a single click. Then you can do step 3/ several times. When you are finished, click again on the format painter button to deactivate it.
Can you format a floppy without erasing the data on it?
Formatting destroys all data.
What Excel button lists formatting options?
Insert Options
What allows you to specify the data format of the value typed into a text box?
You can not specify the data format in a text box, other than formatting the text in the box.
Why did you lose space after formatting ntfs to fat 32?
Windows 2000 and XP computers utility for formatting only supports 32GB formatting for fat32. However, FAT32 allows up to 2TB of space to be formatted from ntfs. So most likely your using XP. Search Google for "Disk Format Utilities" and you can find ones that will format your drive from ntfs to fat32 without losing space.
What does the Format Painter button do in Excel?
It enables you to copy the format you have used in one or more cells, and apply it to other cells. A cell using a combination of formatting can have all of its formatting applied to other cells, without having to apply the individual settings one at a time.
