Hold down the left hand mouse button and drag the border to the left or right to make the column narrower or wider as required.Īs you carry out this action, the width of the column displays. Here are the steps I used to fix the issue: First, press CTRL +D to bookmark this page as.Position the cursor on the right hand border of the column letter box, until you see a double headed arrow.Use the right hand border to increase or decrease the width of a column.
Resize the width of a column using the mouse You can choose between the two methods for resizing a single row or column, but you must use the Format option for more than one row or column. To resize one or more than one column or row, you may use Format on the menu bar. So, if you scroll down, you will see the top row will always remain visible. It will freeze the top row of the worksheet. As a result, the Freeze Panes menu will appear. To resize a single row or a single column, you may use the mouse. To freeze the top row, Go to the View tab and click on Freeze Panes from the Window ribbon. Resizing may be done in either of two ways. You will therefore need to adjust the width of the column and/or the height of the row.
Typically this is required if the existing size cannot adequately accommodate the amount of data included. There may be times when you will need to adjust the size of the cells in the columns and rows of your worksheet. Selection | Inserting | Deleting | Widths and heights | Entering data | Changing contents | Copy, move, delete | Shifting cells | Sorting data | Speeding data entry | Find and replace | Practice |
0 kommentar(er)
