When the Excel document is initially loaded, the cells are populated with #VALUE!. If I highlight the cell, and go to Formulas, Evaluate Formula, the cell gets evaluated as #VALUE!. If I highlight the cell, click at the end of the formula in the formula bar, and press enter, the value gets populated correctly! If I debug the function, the return value is always correct too!

Hello! I want to create a risk register in excel which visually ranks risks based on their frequency and impact but without using numerical data. It needs to be purely text driven, so for example: If both columns D and E contain "High" it…

I have several spreadsheets that contain some line objects On this particular laptop (HP Elitebook 850 G4 - Windows 10) some the line objects move slightly and mess up the look of the sheet In Excel safe mode the line objects show correctly They also…

I made a file in Excel, typed in some symbols that I wanted to use, and changed the font in the cells with those symbols to a font that I made (Delniit Blocky). Although all those symbols definitely exist in my font (and display just fine when I use a…

From description, you want to plot a line graph in Excel. We'd like to help you. If it's convenient, could you share a screenshot about the current status of the graph? And could you share a sample file with us? It will help us have a better understanding of the scenario on your side and share specific suggestion based on the specific scenario.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.

Microsoft Community

How do you do about “set a cell to add the contents of a column =SUM (A1:A1000)”? Could you list the detailed reproducing steps? If you copy the content from the affected file to a newly created file, what’s the result? Upload a full screenshot of the page showing the version information of the Excel 2016 application you are using. You can access the page via File>Account.

Microsoft Community

It seems that for every cell in column A (2-9) I have to create a new 'Name' in Name Manager.