Help with Bold and Painter function inExcel 365 that stop working.

falex4806aolcom 

If the "Bold" and "Format Painter" functions in Excel 365 have stopped working, it could be due to various reasons, including software issues or user settings. Here are some troubleshooting steps to help you resolve these issues:

For the "Bold" Function:

1. Check the Text: Ensure that the cells or text you are trying to make bold are not empty or locked for editing. If a cell is locked for editing or contains no content, you cannot apply the bold formatting.
2. Keyboard Shortcut: Try using the keyboard shortcut for making text bold, which is typically "Ctrl + B" (Windows) or "Command + B" (Mac). This can be a quick workaround if the formatting toolbar is not working.
3. Excel Options:
• Click on "File" in Excel.
• Go to "Options."
• In the Excel Options dialog, navigate to "Advanced."
• Scroll down to the "Display options for this worksheet" section.
• Ensure that the "Show" option for "Objects" is selected.

For the Format Painter Function:

1. Check Cell Selection: Make sure you have selected the cell with the formatting you want to copy (source cell) before using the Format Painter. The Format Painter copies formatting from the selected source cell to the target cells.
2. Format Painter Button: If the Format Painter button is not working, try the following:
• Click the "Home" tab.
• Find the Format Painter button in the Clipboard group.
• Ensure that it's active (highlighted) before selecting the target cells to apply the formatting.
3. Excel Options:
• Click on "File" in Excel.
• Go to "Options."
• In the Excel Options dialog, navigate to "Advanced."
• Scroll down to the "Cut, copy, and paste" section.
• Ensure that the "Show Paste Options button when content is pasted" option is selected.
4. Restart Excel: Sometimes, Excel can have temporary glitches. Save your work, close Excel, and then reopen it.
5. Update or Repair Office: If the issue persists, it may be related to the installation of Microsoft Office. Try updating your Office suite to the latest version or repairing the installation.  The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.