Ask Your Question

simeva's profile - activity

2019-02-05 00:10:05 +0200 received badge  Self-Learner (source)
2019-02-05 00:10:05 +0200 received badge  Teacher (source)
2019-02-01 18:58:01 +0200 received badge  Popular Question (source)
2019-02-01 14:54:58 +0200 commented answer No change of address to a cell in calc, when new lines are inserted.

btw, you can stop zero values appearing as "0" by changing the number format. You can make them appear as a blank space,

2019-02-01 14:34:28 +0200 answered a question No change of address to a cell in calc, when new lines are inserted.

Or you could use a different method to insert the space below B3. Highlight the range B4 - D5. (either just those cells,

2019-02-01 14:23:44 +0200 edited question [solved] How do I get a function to treat the content of a cell as range name?

How do I get a function to treat the content of a cell as range name? Say Cell A1 of a spreadsheet contains the text str

2019-02-01 14:23:44 +0200 received badge  Editor (source)
2019-02-01 14:21:01 +0200 answered a question [solved] How do I get a function to treat the content of a cell as range name?

Ha! I found the answer. The function INDIRECT does this.

2019-02-01 13:50:14 +0200 edited question [solved] How do I get a function to treat the content of a cell as range name?

How do I get a function to treat the content of a cell as range name? Say Cell A1 of a spreadsheet contains the text str

2019-02-01 13:49:11 +0200 asked a question [solved] How do I get a function to treat the content of a cell as range name?

How do I get a function to treat the content of a cell as range name? Say Cell A1 of a spreadsheet contains the text str