0
If you have one cell already in Currency, then clicking on the Format Painter tool and then selecting the range you want to apply the formatting to, will do it. You could also copy from the original cell and use Paste Special to paste just the formatting. You could also just select the range and press Ctrl - Shift - 4
What else can I help you with?
In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?
When you use the fill handle it will copy what is in the cell including the formatting.
What are copies the format of a worksheet cell without copying the contents of a cell in excel?
To copy the format of a cell in Excel without copying the contents, you can use the "Format Painter" tool. Select the cell with the desired format, click on the "Format Painter" button in the toolbar, and then click on the cell where you want to apply the format. This will copy the formatting without changing the contents of the cell.
Which one of the following copies multiple formats from selected cells to the other cells?
You would use the format painter to copy formatting from one cell to another cell or cells. You can also use copy and then use Paste Special to copy just the formatting.Use the copy command and then paste format.
What copies the contents and format of a selected range and places the copy on the Office Clipboard?
Copy button
What copies format of source area but not the contents?
Use regular copy, then past only the format (paste format) to a cell.
What is the range of a cell receiving a copy area?
target
What is the button used to duplicate the content of a cell from a source range to a target range?
copy button
How do you use Format Painter?
You use Format Painter by first adding your options to the open cell. Then, double click that cell to make it primary. This allows you to copy formats into non-formatted cells.
Used to copy a cell range of cells and create a series?
fill handle
What is used to copy a cell or range of cells and create a series?
auto fill
What is a feature that allows you to quickly apply contents of one cell to another range of cells?
To apply the contents, use copy and paste. If you want to apply formatting you can use the Format Painter or use facilities from Paste Special.
Does the format painter button copies both the cell's content and formatting?
No. It only copies the formatting. It does not copy content.
