Which of the following is the correct method to change the height of a row in MS Excel?

This question was previously asked in
OSSC Excise SI (Mains) Official Paper (Held On: 17 Oct, 2024 Shift 2)
View all OSSC Excise SI Papers >
  1. Right-click on the column letter and select 'Row Height'.
  2. Right-click on the row number and select 'Column Width'.
  3. Press 'Ctrl + H'.
  4. Drag the boundary below the row number to resize.

Answer (Detailed Solution Below)

Option 4 : Drag the boundary below the row number to resize.

Detailed Solution

Download Solution PDF

The correct answer is Drag the boundary below the row number to resize.

Key Points

  • This method allows for quick and direct resizing of rows by dragging the boundary below the row number.
  • It is an intuitive and visual way to adjust row height without needing to input specific values.
  • This approach can be used to resize multiple rows simultaneously by selecting them first.
  • It is a commonly used method due to its simplicity and ease of use.

Important Points

  • Adjusting row height can improve the readability of data in an Excel sheet by ensuring all content is visible.
  • This method is particularly useful when dealing with cells that contain wrapped text or large font sizes.
  • Ensuring consistent row heights can help maintain a clean and professional appearance in your Excel documents.
  • Excel also offers other methods to change row height, such as specifying an exact height value through the 'Row Height' option in the context menu.
Latest OSSC Excise SI Updates

Last updated on Feb 8, 2025

-> OSSC Excise SI PET/PMT Merit List has been released on the official website. The test was conducted on 4th and 5th February 2025. 

-> OSSC Excise SI 2024 Notification has been released for 10 vacancies.

-> The selection process includes Written Examination, PMT and PET, and Certificate Verification.

Get Free Access Now
Hot Links: happy teen patti teen patti star apk teen patti online game teen patti vip teen patti apk download