please can you help

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Please can you help me reinstate my 'Format' box in the toolbar?

Please can you help me reinstate my 'Format' box in the toolbar?

resolvedResolved · Low Priority · Version 365

Fiona has attended:
No courses

Please can you help me reinstate my 'Format' box in the toolbar?

Please can you help me reinstate my 'Format' box in the toolbar?

RE: Please can you help me reinstate my 'Format' box in the tool

Hello Fiona,

Thank you for your question.

If your Font group in Excel has disappeared completely from the Home tab, you can easily recreate it:

Click File > Options > Customize Ribbon

On the right-hand side, below the 'Main Tabs' box, click the 'New Group' button.

Then click 'Rename' to rename the new group, and call it Font. This will now show in the list in the box above these buttons.

Next, drag and drop the following items from the box on the left (Popular Commands) into 'Font' on the right:

Font
Font Size
Increase Font Size
Decrease Font Size
Bold
Italic
Underline
Borders
Fill Color
Font Color

These are the default items in the Font group.

The Font group should sit below 'Clipboard' in the list. If not, you can move it using the up and down buttons to the right of the 'Main Tabs' box.

When you're all done, simply click OK.

I hope this helps.

Kind regards
Marius Barnard
STL

Wed 14 Jun 2023: Automatically marked as resolved.


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.09 secs.