FNF4 - Absolute Reference

I need to use F4 to create an absolute reference in Excel, but my MacBook Air only phases in and out of my app drawer. How do I fix this?

MacBook Air 13″, macOS 12.6

Posted on Oct 10, 2023 7:25 PM

Similar questions

Is it possible to reference a text cell, but without the format? IF cell A1 contains "Name" and cell B1 = A1, I'd like B1 to also contain "Name"... however, I'd like to format B1's text to be different from A1. I'm on macOS Big Sur Version 11.7.7; Numbers version 12.1; It seems to me that in prior versions, when you referenced a text cell, that the formatting of the referenced cell either did not pass to the new cell OR you were at least able to change the formatting on the new cell. However, at some point it seems now that when a text cell is referenced, it passes along the formatting and thus far I can't figure out how to change it. Why do I want this? My use case is that I have a numbers document that is a template for each employee I have. I would like to enter the employee's name once in the document and throughout the document I can reference that one cell and have their name be displayed in many other places for other formulas to work, as well as for it to look nice. Over the past few years I've developed my own little system to format the text color of a cell a particular color (blue), to visually guide the user to cells that should be changed. All other font color is black. So, it is encouraged to change blue text (A1), but do not change black text (B1). This has worked well for many, many years. However, over the past year or two, something changed in Numbers and it seems to now pass along the text formatting when referencing a another text cell. So before, it was easy to see that the cell with the blue text is the cell to enter the new employee's name. Now, the employee's name is blue everywhere throughout the document and you essentially need to click on the cell to see if it is a reference or if it in fact is the cell you should change. After I've referenced the cell, I've tried to then tried to go around the document and format the other cells. It seems the referenced format overrides all other cells. I've also tried to format the entire column or row in which the reference text is displayed: every other cell will change, but not the referenced text...it again continues to be displayed exactly as it does in the original cell (A1). Please let me know if there is a way to reference the text content from one cell to another without the formatting of the original text. Thanks in advance!!
548 3
Can Mac Pages format superscript numbers sequentially? I have a very long academic document with lots of references. For now I have used the normal * as a placeholder for where the superscript number should be. I have then attached the reference text as a 'comment' to the asterisk. So now I can see all my dosument with the references in the comment pane. But how do I change all those asterisks to be incremental superscript numbers? How do I format the document so the comments appear at the bottom of each page, where they relate to the superscript numbers. Do I need another app to do this?
552 1

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

FNF4 - Absolute Reference

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up