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

cells format

ResolvedVersion 2003

Ross has attended:
Excel Intermediate course
Excel Introduction course

Cells format

how do i format cells

RE: cells format

Hello Ross,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding formatting cells

There are several ways to format cells.

1.
Select the cells that you want to format, and then Right-click your mouse, and choose format cells. This will bring up the format properties box where you can then choose how to format your cells.

2. Select the cells that you want to format, and then use the Formatting toolbar to make the changes that you want to make to the formatting of the cell.

3. Select the cells that you want to format, and then click on FORMAT > Cells on the menu bar. This will bring up the same properties window that was described in option 1 above.

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. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

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