formatting cells

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting cells

Formatting cells

resolvedResolved · Low Priority · Version 2003

Ian has attended:
Excel Intermediate course

Formatting cells

Can you use special formatting to dfine bold as well as the ## commnads

RE: Formatting cells

Hi Ian

Thank you for your question and welcome to the forum.

I don't believe that you can tell Excel to format something in bold as part of a custom format.

If it was something like wanting to bold either positive or negative numbers, then you could use conditional formatting to do this instead (Format - Conditional Formatting).

Amanda


 

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


Server loaded in 0.08 secs.