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

formatting

ResolvedVersion Standard

Sandra has attended:
Excel Introduction course
Excel Intermediate course

Formatting

how do i format multiple cells

RE: formatting

Hi Sandra,

Thank you for your question - I hope you enjoyed the training you had.

To format multiple cells you need to highlight the cells that you wish to format first. Do this by holding down the left mouse button when the white across appears over the starting cell, and then dragging the mouse across and down the cells you wish to format.

Then go to Format>>Cells, and choose the type of formatting you require. For example to make all highlighted cells appear with 2 decimal places, under the Number tab click on Number. Make sure the Decimal Places box says 2, and then click OK. All of your highlighted cells should now have that formatting applied to them.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Have a great day.

Regards,

Nicole.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

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