FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you copy the format of a cell, you copy both the format and the content of the cell(s).
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.

Detailed explanation-2: -Select the cell with the desired format and press Ctrl+C to copy its content and formats. Select the entire column or row that you want to format by clicking on its heading. Right-click the selection, and then click Paste Special. In the Paste Special dialog box, click Formats, and then click OK.

Detailed explanation-3: -To use this shortcut, simply select the cell where you want to paste the text. Then, press Ctrl + Shift + V on your keyboard. This will paste the text without any formatting. If you want to paste the text and keep the formatting, you can use the Ctrl + V shortcut instead.

Detailed explanation-4: -To copy the formatting of selected text: Press Ctrl + Alt + c (Windows or Chrome OS) or ⌘ + Option + c (Mac).

There is 1 question to complete.
Previous
Next