Close the VBA Editor window. Now click on the button in the spreadsheet, and it will go on worksheet 2, which will be no longer be hidden. In Microsoft Excel, you can use shortcut keys to navigate ...

When the Merge and Center button is missing, greyed out, or not working in Excel, there are two possibilities. First, your worksheet is protected. Second, the Workbook is shared. So, if you turn ...