Excel for mac select cells with containing specific text

broken image
broken image

It's laborious having to type dollar signs into a cell reference, but fortunately there's a keyboard shortcut you can use instead! Import an excel or text file $ symbol in excel is used to lock a specific cell or rows or columns in a worksheet, the shortcut to lock down a reference in excel is by pressing alt + f4, this feature is used while working in formulas when we do not want the reference to be changed when we copy or drag down the formula to other cell references, this feature will keep the reference same for all the further …

broken image

The insert symbol dialog box is a library of symbols from where you can insert any symbol into your word document with just a couple of mouse clicks. Obey the following steps to insert the dollar symbol in word using the insert symbol dialog box.