ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
TICK/UNTICK To Update
If you tick or untick this box, or make any change
to any cell on this sheet any cells based on
NOW(), TODAY(), RAND(), or RANDBETWEEN()
formulas will recalculate
2
3
Rolls of the dice....Result
4
Roll 11
Uses RANDBETWEEN(), so will refresh immediately
5
Roll 26
6
Roll 31
7
Roll 46
8
Roll 55
9
Roll 63
10
Roll 71
11
Roll 84
12
Roll 93
13
Roll 101
14
What are the contents of cell?
15
B85
INDIRECT cell references in this sheet also update.
16
What time is it now?
17
30/07/2026 09:35:53Uses NOW()
18
How long ago was?
19
24/11/2022 00:00:00
20
Days1344
Based on cell A18 = NOW()
21
Hours9
22
Mins35
23
Seconds53
24
What time is it now when we import the time from another sheet?
25
30/07/2026 09:35:53
IMPORTRANGE this is importing the time from another sheet using NOW() to generate it
Data Freshness
https://support.google.com/docs/answer/3093340?hl=en#zippy=%2Cdata-freshness
26
Stock Indices
Google Sheets ensures that Sheets users get the fresh data while they keep their use reasonable. IMPORTRANGE automatically checks for updates every hour while the document is open, even if the formula and spreadsheet don’t change. If you delete, read, or overwrite the cells with the same formula, the reload of the functions trigger. If you open and reload the document, it doesn’t trigger a reload on IMPORTRANGE.
27
DOW Jones51594.14
GOOGLEFINANCE (upto 20 minutes delay)
28
FTSE 10010967.97
29
30
31
32
33
34
35
36
37
38
https://support.google.com/docs/answer/58515?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cchoose-how-often-formulas-calculate
39
Updating NOW(), TODAY(), RAND(), or RANDBETWEEN() formulas
40
Press Backspace ← or Del on any empty cell to immediately trigger a recalculation of formulas depending on NOW(), TODAY(), RAND(), or RANDBETWEEN() (in all Sheets of the whole Spreadsheet, as usual).
41
42
(If no empty cell is at hand, you can delete a filled cell instead and then undo that with Ctrl+z.)
43
44
45
INDIRECT() formulas are unfortunately not updated like this by default.
46
47
Updating INDIRECT() formulas
48
You can update a (range of) cells of INDIRECT() formulas by pasting the range on itself:
49
50
Select cell/ range
51
Ctrl+C
52
Ctrl+V
53
You can use Ctrl+A to select the whole current Sheet in step 1.. But for large Sheets then the other 2 operations can take several seconds each.
54
A trick to know when the process of copying a large range has finished: Copy some single cell before copying your range: The single cell losing its dotted border will be your notification of the large copy finishing.
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100