arrow
arrow
arrow
If a column has a width of 0 (zero), then the column is __________ in an Excel worksheet.
Question



If a column has a width of 0 (zero), then the column is __________ in an Excel worksheet.

A.

Highlighted

B.

Hidden

C.

Copied

D.

Pasted

Correct option is B

In an Excel worksheet, if the column width is set to 0, the column becomes hidden and cannot be seen in the spreadsheet until unhidden.
Important Key Points:
1. Hidden Column: Setting a column's width to 0 effectively hides it from view. Users can unhide it by adjusting the width back to a positive value.
2. Highlighting and Copying: These operations do not make a column disappear; only setting the width to 0 or explicitly hiding it does.
Knowledge Booster:
· Hiding vs Deleting: Hiding a column does not delete data—it simply removes the column from the current view.
· Shortcut to Unhide Columns: Select the adjacent columns to the hidden one, then right-click and select Unhide to make it visible again.

Free Tests

Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘Supreme Court of india’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
368k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow