Excel 2016: Modifying Columns, Rows, and Cells - www.office.com/setup - 0 views
-
Akmal Yousuf on 07 Jul 17WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook. Watch the video below to learn more about modifying columns, rows, and cells. TO MODIFY COLUMN WIDTH: In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. positioning the mouse over the column line - www.office.com/setup Click and drag the mouse to increase or decrease the column width. increasing the column width - www.office.com/setup Release the mouse. The column width will be changed. the resized column - www.office.com/setup With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible. TO AUTOFIT COLUMN WIDTH: The AutoFit feature will allow you to set a column's width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. autofitting the column width - www.office.com/setup Double-click the mouse. The column width will be changed automatically to fit the content. the autofit column width - www.office.com/setup You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height. autofitting column width for multiple columns - www.office.com/setup TO MODIFY ROW HEIGHT: Position the cursor over the row line so the cursor becomes a double arrow. hovering over a <a href=row line - www.of
