This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 57.99999999999999%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
My boarder function for cells in excel isn't working. I did when i first purchased the subscription but has somewhere since lost the function. I can color cells but not use the boarder function. Please help.
This can't be a protection problem if Borders are the only feature affected. More likely it's a matter of needing to restart the Mac and/or applying OS & Office updates.
If you provide the present Version Numbers of both Office & macOS that can be determined. It's always good to include that info when posting a question.
Hello,
It sounds like your worksheet has become protected, try first to remove protection:
Once the sheet is unprotected, select the cells you want bordered and use Home > Borders to apply the style you need. If you still can't draw borders after unprotecting, right click a bordered cell, choose Format Cells, go to the Border tab, make sure an appropriate color and line style are selected, then click the diagram edges where you want borders applied and hit OK.
Let me know if this works!
The file was not protected. Thanks for the suggestion !
Hi again,
I see, then It's most likely that your cells are inside an Excel "Table", which forces formatting via its Table Styles and disables manual borders.
To restore the normal Borders button, click any cell in your data range. If you see a Table Design tab appear on the ribbon, you're in a Table. Go to Table Design > Tools > Convert to Range, and confirm. Now select your cells and the Home > Borders menu should work again exactly as before.
Let me know if this changes something!
