You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou can’t do this. You have to format each of the new cells individually.Cells must be formatted before data is entered into them.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You must copy the cells over the new cells, then type the data back in.You can use the Format Painter to copy only the formats from the old cells to the new cells.
Question
You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.1 pointYou can’t do this. You have to format each of the new cells individually.Cells must be formatted before data is entered into them.You can use the Format cells option after right-clicking a cell, to copy the formats from the old cells to the new cells.You must copy the cells over the new cells, then type the data back in.You can use the Format Painter to copy only the formats from the old cells to the new cells.
Solution
The correct answer is: You can use the Format Painter to copy only the formats from the old cells to the new cells.
Here are the steps to do this:
- Click on the cell with the formatting you want to copy.
- Go to the Home tab in the ribbon.
- Click on the Format Painter button.
- Click on the cell you want to apply the formatting to. The formatting from the first cell will be applied to the second cell.
Remember, this will not copy the content of the cell, only the formatting.
Similar Questions
Cells J2:M6 have been copied. Paste the copied cells into the selected worksheet location (cell N2) so the formulas, formatting, and source cell widths are pasted.
To copy highlighted data that has hidden rows and/or columns in it, press this keystroke shortcut to select Visible Cells Only.
o delete the contents of a cell, _____.Select one:a.select the cell, click the Format button, and select Delete Cellsb.select the cell and press the Delete keyc.select the cell and press the Enter keyd.select the cell, click the Format button, and select Clear Structure
From the following list of choices, select the choice that BEST describes the purpose of using the Paste Special feature in Excel.*It allows you to paste special characters, such as the trademark symbol, into a worksheet.It allows you to copy cells and then paste only selected elements into a new locationIt allows you to copy data from a Microsoft Word table and paste it into Excel worksheet.
Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done.Save As.csv.htmlWorksheet tabFormat CellsSUMFunctionDestination cellHome tabAutoFitAApplies a border or shading to selected cellsBWhere cut or copied data is pastedCSaves workbook with a different nameDThe extension for a web page workbookEA function that adds the values in a selected rangeFWhere the Clipboard group is foundGA common file format that can be opened by many applicationsHDisplays the name of the worksheet near the bottom leftIResizes column width or row height to accommodate the largest entryJA built-in formula
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.