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

cells

ResolvedVersion 2007

Angela has attended:
Excel Introduction course
Excel Intermediate course

Cells

How do you change formatting in a cell

RE: cells- -Formatting

Dear Angela

Thank you for attending the Excel Intro course!! I hope you enjoyed the course and benefited from it.


Formatting simply means the appearance. That can include formatting like Bold, Italic, Change in size, font, colour and fill. Or you could change the appearance of the cells that have numbers by applying currency symbols or decimal places. All these can be done by using the Formatting toolbar. 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 Format> Cells

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

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.11 secs.