I have an Excel spreadsheet that calculates a whole load of values from other sheets in the workbook.
It helpfully tells me that I have made an error as the "Formula omits adjacent cells", clearly Microsoft don't believe that that's what I actually want to do. I have about 100 of these messages, indicated by irritating green tabs in the corner of the relevant calls.
Can I get rid of these in some more efficient way than manually removing them all individually?
Yes go into excel options and deselect the "errors" you don't want to be highlighted. Numbers as text is another annoying one.
Stand down, problem solved, it's on the File-Options-Formulas-Error checking settings.
Edit: thanks Muggo, I was too slow.
Sorry to hijack your thread, but is there any good online resources for learning about spreadsheets? I need to start using them for work but I really don't know how to start. I have OpenOffice Calc, which I hear is the same kind of thing as Excel.