How can we improve Excel for Mac? Sometimes we need to convert a relative reference in a cell (e.g. A1) to absolute values (e.g. $A$1) or the contrary. Open Microsoft Excel. Highlight the cell containing the formula you want to have changed into an absolute or relative reference. In the formula box as shown below, click the formula box or highlight the formula and press the F4 key to switch between an absolute and relative cell reference.
![]()
Here is one of the simple things that just makes life better. Typing a new line within a cell in Excel. Very useful for many reasons but essentially i am talking about the option to write, for example, an mailing address, where the first line is the name of the place, second line is the street address and third line is city and zip code. Something like this: In the Windows version of Excel this was something i was using all the time. The combination of Control + Enter did the trick.
![]()
But in the Mac version of Excel this combination does not work. But don’t lose hope. There is simply a different combination that does it: Control + Option (or Alt) + Enter And it works just the same! (I found this information ).
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |