QUESTION : I have a plot, drawn in Excel 2013. The data begins from almost 0.9 to almost 5.1. I […]
Category: Ms-Excel
How do I stop the excel file being in use? [duplicate]
QUESTION : This question already has answers here: Microsoft Office document is “locked for editing by ‘another user’” (11 answers) […]
How to auto-refresh an Excel auto-filter when data is changed?
QUESTION : How to I auto-refresh an Excel auto-filter when data is changed? Use case: I change the value of […]
Format series of excel pivot chart based on series title
QUESTION : I have a non-stacked pivot bar chart that is showing two values (Sum of Planned Hours & Sum […]
Dragging Excel formula involving INDIRECT
QUESTION : =INDIRECT(“‘”&$A4&”‘!E4”) This is supped to use the value from cell E4 of the sheet with name found in […]
How can I find the Maximum of Polynomial Trendline?
QUESTION : I have a XY chart. I used a polynomial trendline, now I need to find the maximum of […]
Excel doesn’t automatically update ranges in SUMIF expression — why?
QUESTION : In Excel 2007, I have a worksheet arranged like this: A B C 1 x 2 15 2 […]
VBA copy a chart worksheet from a template
QUESTION : I have a worksheet chart that I want to use as a template in a macro. I am […]
Format text list with corresponding key into spreadsheet
QUESTION : I have a text file with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 […]
Problems exporting word dashes and quotes from Excel into .csv
QUESTION : I’m trying to export a spreadsheet to a .csv file and when I do, it takes all of […]