How to Increase/Decrease Width of Column and Rows and Hide , Unhide in Microsoft Excel Urdu Class 13
29 بار بازدید -
پارسال
-
To hide and unhide columns
To hide and unhide columns and rows in Microsoft Excel, as well as adjust their width and height, you can follow these steps:
Hiding Columns:
Select the column or columns you want to hide by clicking on the column header(s).
Right-click on the selected column header(s).
In the context menu, click on "Hide" to hide the selected column(s).
Hiding Rows:
Select the row or rows you want to hide by clicking on the row number(s) on the left side of the sheet.
Right-click on the selected row number(s).
In the context menu, click on "Hide" to hide the selected row(s).
Unhiding Columns:
To unhide a single column, click on the adjacent column headers, then right-click and choose "Unhide" from the context menu.
To unhide multiple columns, select the columns on either side of the hidden columns, right-click, and choose "Unhide" from the context menu.
Unhiding Rows:
To unhide a single row, click on the adjacent row numbers, then right-click and choose "Unhide" from the context menu.
To unhide multiple rows, select the rows above and below the hidden rows, right-click, and choose "Unhide" from the context menu.
Adjusting Column Width:
To increase or decrease the width of a single column, move the mouse cursor to the right border of the column header until it turns into a double-headed arrow.
Click and drag the border to adjust the width of the column as desired.
Alternatively, you can double-click on the border to automatically adjust the width based on the column's contents.
Adjusting Row Height:
To increase or decrease the height of a single row, move the mouse cursor to the bottom border of the row number until it turns into a double-headed arrow.
Click and drag the border to adjust the height of the row as desired.
Alternatively, you can double-click on the border to automatically adjust the height based on the row's contents.
Remember that hidden columns or rows can still be referenced and used in formulas, but they will not be visible on the sheet.
These steps should help you hide, unhide, and adjust the width and height of columns and rows in Microsoft Excel
Hiding Columns:
Select the column or columns you want to hide by clicking on the column header(s).
Right-click on the selected column header(s).
In the context menu, click on "Hide" to hide the selected column(s).
Hiding Rows:
Select the row or rows you want to hide by clicking on the row number(s) on the left side of the sheet.
Right-click on the selected row number(s).
In the context menu, click on "Hide" to hide the selected row(s).
Unhiding Columns:
To unhide a single column, click on the adjacent column headers, then right-click and choose "Unhide" from the context menu.
To unhide multiple columns, select the columns on either side of the hidden columns, right-click, and choose "Unhide" from the context menu.
Unhiding Rows:
To unhide a single row, click on the adjacent row numbers, then right-click and choose "Unhide" from the context menu.
To unhide multiple rows, select the rows above and below the hidden rows, right-click, and choose "Unhide" from the context menu.
Adjusting Column Width:
To increase or decrease the width of a single column, move the mouse cursor to the right border of the column header until it turns into a double-headed arrow.
Click and drag the border to adjust the width of the column as desired.
Alternatively, you can double-click on the border to automatically adjust the width based on the column's contents.
Adjusting Row Height:
To increase or decrease the height of a single row, move the mouse cursor to the bottom border of the row number until it turns into a double-headed arrow.
Click and drag the border to adjust the height of the row as desired.
Alternatively, you can double-click on the border to automatically adjust the height based on the row's contents.
Remember that hidden columns or rows can still be referenced and used in formulas, but they will not be visible on the sheet.
These steps should help you hide, unhide, and adjust the width and height of columns and rows in Microsoft Excel
پارسال
در تاریخ 1402/03/29 منتشر شده
است.
29
بـار بازدید شده