Question

Copy the values and number formatting, but not the underlving formulas, of cells k4:kg into range b4:b6.

Answer 1

To copy the values and number formatting but not the underlying formulas from cells K4:KG into range B4:B6 in Excel, use the 'Paste Special' feature.

Step-by-step explanation:

To copy the values and number formatting but not the underlying formulas of cells K4:KG into range B4:B6, you can use the 'Paste Special' feature in Microsoft Excel. Here is how you can do it:

1. Select cells K4:KG.
2. Press Ctrl+ C to copy the cells.
3. Select cells B4:B6.
4. Right-click and choose 'Paste Special'.
5. In the 'Paste Special' dialog box, check the 'Values' option and uncheck the 'Formulas' option. Also, make sure the 'Number formats' option is checked.
6. Click 'OK' to paste the values and number formatting.