Did you know that 最新博彩网站 Sheet can recogonize and correlate names used in formulas with cells / cell ranges automatically? You have to just give the row / column header of a table as arguments to functions and 最新博彩网站 Sheet will auto-recogonize the cell range associated with the name. It is very convenient to quickly type in the formulas with these names instead of worrying about keying in the proper cell range.
Consider the following sheet available at /docs/sheet.html?/public.do?fid=25835
Look at the formulas in the cells F5:F7 and C9:E9. The formula =SUM(USA) will automatically add the cell values in the row with the header 鈥淯SA鈥. Earlier you had to use =SUM(C5:E5). Now the row header can directly be used. You do not even need to name / label the cell ranges. If the row / column header has a space in between, then you can use single quotes in formulas. For example: =SUM(鈥楿nited States of America鈥). Please note that special characters like a single quote in a row / column header needs to be escaped using a back slash 鈥 \. For example: =SUM(鈥楤ob\鈥檚 Expenses鈥)
You can even copy and paste these formulas to adjacent rows or columns and they will automatically be adjusted relatively. In this case, copying the F5 cell and pasting it to F6, will result in the formula =SUM(EMEA) in F6.
We hope it considerably eases typing in of formulas. As always, kindly try it out and send us your feedback and suggestions to support (at) zohosheet (dot) com.
Comments