{"id":3645,"date":"2018-12-12T18:16:57","date_gmt":"2018-12-12T18:16:57","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3645"},"modified":"2024-03-28T14:39:44","modified_gmt":"2024-03-28T14:39:44","slug":"the-dollar-sign-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/the-dollar-sign-in-excel\/","title":{"rendered":"The Dollar Sign in Excel"},"content":{"rendered":"\n
The dollar sign ($)<\/strong> in Excel is used to create a locked cell reference. In some cases, locking cells is important, otherwise, you would spend a lot of time rewriting formulas.<\/p>\n\n\n\n There are three ways you can use the dollar sign to lock a cell reference.<\/p>\n\n\n\n In order to change the type of cell reference, you have to follow these steps.<\/p>\n\n\n\n\n
How to use a dollar sign in a formula<\/h2>\n\n\n\n
\n