Follow this topic

Zulkifli Nurhakim Halida

Last answered:

05 Aug 2023

Posted on:

04 Aug 2023

0

Resolved: add $ by using F4 instead

in Introduction to Excel / Using Absolute and Relative Cell References

actually, you could add the $ mark by using F4 button

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

05 Aug 2023

0

Yes, absolutely! That's a great tip!

Helpful answer

Submit an answer

related questions

Mario Contreras

1

12

Why are we using SUMIF to transfer data instead of using VLOOKUP?

Megburu Cynthia

0

8

I can't find the option for 'Format' after using command Ctrl + H

1

6

Hi. Are you using some key combination to put the $ sign in your formula?

0

6

Using Free Online version of Excel to Create a Bridge Chart

Obioha Chijioke

1

6

Using x's in excel to speed up copy and paste.

0

4

Resolved: Column width increasing instead of decreasing?

0

4

Resolved: Would it not be easier to simply concatenate with ", " instead of ","&" "

0

2

error value in using AND FUCTION

Muntaser Younis

0

2

how did you add the currency?

Tansaya Khajikhan

2

2

use xlookup instead

Brenda Nadam-Olegnowicz

0

2

Resolved: Can I use Google Sheets instead of Excel?

0

2

Error in formula code for exercise 50 (using index and match together)