AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() It's also possible to reference data from other sheets. You can create a reference to an individual cell, a range of cells, or an entire column. You do this with cell or column references. Press or hold down that key (it varies from system to system) as you press the F4 key, and it should work as you expect.When you create formulas, it's possible to include values from other cells or columns on the sheet. To get to the normal operation of a particular function key, look for a key labeled something like FN (short for "function") or F Lock (for "function lock"). On these types of keyboards the function keys typically do special things, such as adjust your volume, adjust screen brightness, etc. If the F4 key still doesn't work as you expect, then it is a good bet that you are using a laptop computer or a super-duper, multi-function keyboard with your desktop system. In other words, select the cell you want, press F2 to enter edit mode, use the left and right arrow keys to move through the formula, and press F4 whenever you want to cycle a reference through various permutations of absolute and relative notation. There is a caveat, however: You need to make sure that you are in "edit mode" when it comes to using F4 with formulas. Testing on a Windows 10 system indicates that the F4 key still cycles through absolute/relative versions of references. She would like F4 to work as it traditionally did in Excel. As Hazel only has one monitor, but lots of requirements to set cell references to and from absolute, this is driving her crazy. ![]() ![]() Instead, F4 opens a sidebar about projecting to a second monitor. She has found that she can no longer use F4 as a method of toggling a cell reference through the absolute/relative settings. Hazel recently bought a new computer that uses Windows 10. ![]()
0 Comments
Read More
Leave a Reply. |