Search results

Thank you the formula bar is the place. There is another little nuance I found - if you just type in "=B164" in the formula bar it comes up with an unhelpful message "References in series formulas must be external references to worksheets." Which basic ally means you need to put the sheet name...

I must be doing something dumb. The text I want for my chart title is in cell B164. So I click on the chart title so I can edit it. I try typing in "B164" - I get a chart tile that says "B164", not the contents of cell B164. I try typing in "=B164" - I get a chart tile that says "=B164"...

Thank you everyone. I was looking everywhere but the ribbon!!!!

I have a pivot table in a model that has been set up by a consultant who predictably has now taken his fee and buggered off. Where do I click on the existing pivot table to definiatively prove what table of data is feeding it please?

Great thank you, I found it an other helpful advice as well. I had totally missed the correct icon on the file list. Interestingly the icon you tap is one normally found at the top or the bottom of the screen, and that is where I was looking....

I have just started the frustrating journey of using Excel for iPad. I have successfully saved a couple of files on to my iPad (not Onedrive). Now I wish to delete one of them. How do I do that please? Secondly is there a way of overwriting and an existing file when you go to save please? Again...

Thank you Patnaik, that worked:rolleyes:. I will add it to my list of tricks in personal.xls. SirJB7, luckily I am only using fixed ranges in this model, whew.;) With this help you have given me I will end up with a much better model, and the sources of all the numbers will be a lot clearer...

I have set up a vlookup like this: =VLOOKUP($C11,DGPlus,H$2,FALSE) (which works) As per best practice the range that is being looked up is in a named range called "DGPlus". (and the lookup value is in column $C, and the lookup column number is in row $2) Now I want to have a series of vlookups...

That worked great thank you. I had already done something similar but using 0,1,2,3,4. But using the decimal makes much more sense. It seems to me that the percentage function in this conditional formating icon set feature of Excel is a dog? Bow wow?

I am building a visual strategy template, and one of the visuals is a pie in which you fill in the quarters as the project progresses. Luckily this in one of the new Icon Sets in the new Excel conditional formatting. The problem is that I am having trouble with the pie one I need. I have set...