USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which Paste Special option pastes only the result of a formula rather than the formula itself?
|
|
Formulas
|
|
|
Values
|
|
|
Formats
|
|
|
Formulas and number formats
|
Explanation:
Detailed explanation-1: -To Paste Values only – Alt+E+S+V + Enter. To Paste Formatting only – Alt+E+S+T + Enter. To Paste Comments only – Alt+E+S+C + Enter. To set column width the same as that of the copied cells – Alt+E+S+W + Enter.
Detailed explanation-2: -To use options from the Paste Special box, select Home, select the clipboard icon (Paste), and select Paste Special. Keyboard Shortcut: Press Ctrl+Alt+V.
There is 1 question to complete.