Hey guys, this is just a short video on a great shortcut in Microsoft Excel. The absolute reference symbol ($) is used when you want to keep a specific cell in place when using a formula. You can put the absolute reference just in front of the row or just in the front of the column to just keep those the same also. The shortcut on Mac: Cmd + T The shortcut on PC: F4 Note: Remember you have to click the cell that you want to keep absolute before you use the shortcut. You don't use the shortcut and then click on the cell. Follow me on Twitter! ![]() Re: Remove dollar sign in a formula click in it and then click on the F4 key. Best apps for the mac book pro. Amanita games for mac. Make contributors happy, click on the '* Add Reputation' as a way to say thank you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |