Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Formatting work sheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training - Formatting work sheet

Resolved · Low Priority · Version Standard

Reply Mon 17 Dec 2007, 15:00Delegate Clementine said...

Clementine has attended:
Excel Introduction course

Formatting work sheet

how do i fromat a label using text formatting?

For upcoming training course dates see: Pricing & availability

Reply Tue 18 Dec 2007, 13:12Trainer Rajeev said...

RE: formatting work sheet

Dear Clementine

Thank you for attending Excel Intro course.

Formatting is anything that helps you to change the appearance of the selected cells, Sheets, etc..

Label is referred to the cells that are mainly heading of the rows and columns which will not be used to perform calculation/s.
In order to Format labels you can simply select the cells containing the labels. And use the Formatting toolbar and use the buttons such as B, I U which stand for Bold, Italic and Underline. Or you can change the colour of the cells or the font colour of the labels by using the appropriate buttons.

It is possible to perform all these actions by selecting the cells and select Format > Cells

Excel articles

· Never Lose It In Translation With Excel
· Improve Performance Of Your Excel Macros
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Make More of your Money with Excel 2007
· How To Print Worksheets In Excel

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips