Excel - Formatting Commands

Formatting Commands To automatically adjust a column to fit the widest entry on the row where the row letters are click to the right of the column you wish to increase the size of and double click. Alternatively you can click and drag to adjust the column to the size of your preference. The Alignment group on the Home ribbon gives you lots of formatting options.

Wrap text Vertical alignment tools Merge and Center Horizontal alignment tools

Merge and Centre This command allows you to select the cells that contain your heading and drag them across the columns you wish your heading to be centered over.

Wrap Text This allows you to wrap text in a column without increasing the column to an unnecessarily large size. The row will increase in height to accommodate all the text,

Increasing the Row Size Click on the line underneath the row number and drag until your row is the desired height.

Aligning Text Click on one of the alignment tools in the Alignment group on the Home ribbon above. There is a group to align your text vertically (i.e. top to bottom) and immediately underneath a set of icons to align your text horizontally (i.e. left to right)/

Provided by Abacus Computer Training, Rickmansworth T: 01923 710552

PDF Creator - PDF4Free v2.0

M: 07885 232 030

E: [email protected]

http://www.pdf4free.com

Often when increasing row heights the text can end up sitting at the bottom of the row which does not look very good. You can use the alignment buttons to either align the text vertically and/or horizontally. For more options go to the Format Cells dialog box by pressing Ctrl and 1 and then select the Alignment tab

Provided by Abacus Computer Training, Rickmansworth T: 01923 710552

PDF Creator - PDF4Free v2.0

M: 07885 232 030

E: [email protected]

http://www.pdf4free.com