98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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?
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting constant values onlyIf 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. |