Here are some interesting Operating system and softwares tips and tricks 4u.JUST CLICK ON THE PICTURE IN THE BLOG FOR ENALARGED VIEW.

sd

Tuesday, February 21, 2012

Standardize column width(Excel XP, 2003, 2007)

By Tuesday, February 21, 2012 No comments
            Several columns need to have exactly the same width so that the table looks neat and uniform.
            First select all desired columns by keeping [Ctrl] pressed and then click the column headings one after the other. In order to select adjacent columns, you can click the heading of the left column, then keep the [Shift] key pressed and then click the heading of the right column. Alternatively, you can keep the mouse button pressed and drag the cursor over the column headings to be selected.
             Move the cursor to the right border of the heading of one of the selected columns. As soon as the display changes and the cursor becomes a vertical line with a horizontal double arrow, press the left mouse button. You can modify the column width as long as you keep the mouse button pressed. Here, Excel informs you about the current width. As soon as you release the mouse button, Excel adjusts the widths of all selected columns to the modified width.
              You can also specify an accurate value for the column width. For this, right-click on the selection, select ‘Column width’ and enter the desired value in the dialog. After clicking ‘OK’, Excel adjusts the fi elds. Even the height of several rows can be adjusted using the described procedure.

0 comments:

Post a Comment

please write your comment

Note: Only a member of this blog may post a comment.

THE WINDOWS TRICKS Headline Animator