Question

Which of the following is one way to change column width to fit the contents?

A. Double-click the right edge of the column header.
B. Press Ctrl+C.
C. Right-click and select "Format Column Width."
D. Shake the mouse vigorously.

Answer 1

To change the column width to fit the contents in a spreadsheet, double-click the right edge of the column header. This auto-fit functionality adjusts the width to display all data properly.

Step-by-step explanation:

One way to change column width to fit the contents in a spreadsheet program such as Microsoft Excel is:

• Option A: Double-click the right edge of the column header.

This action triggers the program's auto-fit functionality, which automatically expands or shrinks the column width to match the length of the longest piece of data in that column, making it an efficient way to ensure all contents are visible without manually adjusting the width.