grayed

  1. L

    Show only active page

    I am running office 365 and have Excel 2016 on my machine. I have a spreadsheet that is in "Page View" but I only have info on the 1st page. However I still see grayed out pages beside and below. Is there a way to only show the one page without the grayed out ones? Regards, L. Ambrose
  2. D

    trendlines

    hi all. In my Excel at home I have the ability to add trendlines by either right clicking or Add chart elements. I've already tried to add the Tool Pak. Before Trendlines was grayed out in the Add Chart Elements, but didn't show up in the right click. Now it shows up in both, but is still grayed...
  3. mikecox39

    grayed out menu options, time formated delivers 0000

    When I rt click a column or cell and set the format for time and date and enter [4-25] I get [1/13/1900 12:00:00 AM] in the address field and [4/25/19 0:00] in the cell. First, why are the options grayed out; they seem to be working otherwise and is there a way to get the program to plug in...
  4. R

    Entire workbook grayed out

    I have a workbook with multiple worksheets. I was working in it a week ago and everything was fine. I opened it today and the entire workbook, including all of the menus, is grayed out. Where the cells would be is just a big gray blank, no borders, no cells, no numbers. Even in the File menu...
  5. H

    Sort Data by colored cell.

    Hi mrexcel forum. I registered here by googling only to solve my problem. If this problem is solve than my task would be much much easier. I have data on two column till 600 rows. first 300 is grayed and 2nd 300 is white. I want some kind of conditional formatting or filter or rule or anything...
  6. L

    trend equation

    Hi I am trying to display trend equation on my line chart but the option is grayed out in the format trend window. Why is that? Thank you so much.
  7. P

    Insert Row Grayed Out, Two Tables: How can I insert in both?

    I made a table next to a table of employees. This table has formulas that I would like to preserve (auto-populate) if someone inserts a row. But if I try to insert a row across sheet, it is grayed out. My users do not know excel so trying to tell them to do two different "Insert Into Table" is...
  8. L

    inserting table

    Hi I created 3 simple tables. Then I went to Insert-->Table and renamed each table as following year16 year17 year18 I went to Formula tab-->Name Manager. I see 3 of them there. When I click on any of them, the Delete option is grayed out. Why is that? I tried everything but I can not delete...
  9. G

    How to remove gridlines for all but work area

    Hello, I see lots of worksheets where only the work area has gridlines, the rest of the worksheet is all white - not grayed out. This focuses your attention to the work area. How to accomplish this? Thanks! G
  10. L

    Excel Table - Copy to second worksheet - paste link grayed out

    Hello, I have an Excel table that I want to copy to a second worksheet, and then delete selected columns and rows, and re-sort. But I need the data that is remaining to be linked to the original sheet so updates are automatically captured. One of the columns I am keeping will be email...
  11. K

    Conditional formatting based on a cell

    Hello - I have several columns that need to be grayed out if the header = "False". So for example F5:P5 indicates either true or false F6:P10 has rates. So if F:5 indicates false I want cells F6:F10 to be grayed out. Is there a faster way to do this then to do conditional formatting each...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top