Necessary cookies are absolutely essential for the website to function properly. To change the background of Excel Sheet, you can right click desktop -> choose Personalize -> choose Windows Color -> Advance appearance settings -> In the Item list, choose Windows with the gray color. In the Go To Special dialog box, check the Formulas radio button, and click OK. To lock all cells with formulas, go to the Home tab > Editing group > Find & Select > Go To Special. Click the “Home” tab on the command ribbon, and then click the “Format as Table” button in the Styles group to display a gallery of styles.Click and drag to select the cells that you want to format.Selecting a gray and white combination helps separate each row without the distraction of bright colors. Click “Use a formula to determine which cells to format”…. Click Conditional Formatting > New Rule… in the Home tab of the ribbon. How do you automatically GREY out cells in Excel? Delete Background is available only when a worksheet has a sheet background. On the Page Layout tab, in the Page Setup group, click Delete Background.Make sure that only one worksheet is selected. Click the worksheet that is displayed with a sheet background.
Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode >will gray out a lot of menu options - notably most Edit options (except cut >& paste). Why are some options greyed out in Excel 2010?
Drop-down arrows will appear in the header of each column.Select the Data tab, then locate the Sort & Filter group.Begin with a worksheet that identifies each column using a header row.Select “Unprotect Sheet” from “Protection” section of the drop-down menu to unlock the worksheet. Click the “Home” menu, then choose “Format” in the “Cells” tab. You must unprotect the workbook, worksheet or cell to unlock the unavailable menus.
How do you unlock a greyed out menu in Excel 2010? The Sort and Filter icon will now become active.
To ensure that you have only one active sheet in order to enable Soft and Filter icon, right click on the sheets and click on Ungroup Sheets. The most common reason why the Sort and Filter icon is grayed out in Excel is because multiple sheets are selected.
0 kommentar(er)
