Forum Discussion
Formulas and Functions $ Automatic Fill
How do I automatically fill a spreadsheet with the $ function that refer to Exact Cells
select table column,
right mousekey
format cells...
Numbers --> Currency
Icon: click dropdown
Choose preferred currency
Ok...and it's done!
right mousekey
format cells...
Numbers --> Currency
Icon: click dropdown
Choose preferred currency
Ok...and it's done!
- Thanks but I am looking for the solution for the $ sign as a precise cell such as $B$7 for example to auto Complete sheets
If you select a cell or range reference in a formula, pressing function key F4 toggles between the absolute/relative options:
B7 will change to $B$7, then to B$7, next to $B7 and then back to B7.
- Thanks that is true what you say but if you have 225 cells to page on one sheet and 31 sheets then it becomes a big job ,
