Logo 
Search:

MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

List the four ways you can change column width?

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 3592

Answer:

• Fit the contents To make the column width fit the contents, double-click the boundary to the right of the column heading. To do the same for all columns on the worksheet, click the Select All button, and then double-click a boundary to the right of one of the column headings.
• Change multiple columns To change the column width for multiple columns, select the columns you want to change, and then drag a boundary to the right of a selected column heading. To change the column width for all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
• Manually change the width To manually change the width, select the column, point to Column on the Format menu, click Width, and then enter a number.
• Copy a width To copy the width of one column to another, select a cell in the column, click Copy on the Standard toolbar, and then select the target column. On the Edit menu, click Paste Special, and then click Column widths.

Share: 
 

Didn't find what you were looking for? Find more on List the four ways you can change column width? Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: