Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

format

ResolvedVersion 2003

Annabel has attended:
Excel Introduction course

Format

how do you change a format in a cell?

RE: formattin cells.

Dear Annabel

Thank you for attending Excel Itro Course, I hope you enjoyed the course and benefited from it.

RE: formattin cells.

Dear Annabel

Thank you for attending Excel Itro Course, I hope you enjoyed the course and benefited from it.

RE: formatting cells

Dear Annabel

My apologies for the previous incomplete responses.

When you say formatting cells it depends on what formatting you would like to apply on the cells. Simple formatting like Bold, Italic, Change in size, font, colour and fill can be done by using the Formatting toolbar.

If you are trying to format cells that have numbers and want to have decimal places or a thousand separator then again formatting toolbar can be used. If you are not sure about the names of the buttons then simply place your mouse arrow on any button and you should be able to see the name on a yellow box.

It is however easier to use the Forma > Cells

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.