![]() Looks like the cells have been hidden, to do this select the column from where you want the grey to start, then hit control, shift and the right arrow, then right click and hit ‘hide’ Ta da!! Why are some functions greyed out in Excel? Click the “Page Layout” tab at the top of the ribbon, then find the Sheet Options area of the ribbon, which includes two small checkboxes under the Headings category.Open the Excel spreadsheet where you want to define your column headings.Select either Excel Add-ins or COM Add-ins fr4om the Manage dropdown, then click Go… One approach is to disable add-ins one by one until the problem disappears. You can enable / disable add-ins in File > Options > Add-Ins. If it works when you start Excel in Safe Mode, the most likely culprit is an add-in. Uncheck the box for “Locked” to unlock the cells.In the “Cells” area, select “Format” > “Format Cells“.Here’s how to lock or unlock cells in Microsoft Excel 20. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |