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 13
Uses RANDBETWEEN(), so will refresh immediately
5
Roll 26
6
Roll 33
7
Roll 45
8
Roll 53
9
Roll 62
10
Roll 76
11
Roll 83
12
Roll 94
13
Roll 106
14
What are the contents of cell?
15
B83
INDIRECT cell references in this sheet also update.
16
What time is it now?
17
24/10/2025 08:03:51Uses NOW()
18
How long ago was?
19
24/11/2022 00:00:00
20
Days1065
Based on cell A18 = NOW()
21
Hours8
22
Mins3
23
Seconds51
24
What time is it now when we import the time from another sheet?
25
24/10/2025 08:03:50
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 Jones46734.61
GOOGLEFINANCE (upto 20 minutes delay)
28
FTSE 1009577.48
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