First youll need to open your Excel spreadsheet and press Alt F11 to open the Microsoft Visual Basic for Applications window. Go to the Home tab and in the Clipboard group select the Paste drop-down arrow then choose Paste Special. For more shortcuts like this and for building strong muscle memory in Microsoft Excel you can play with keySkillset educational games that include more than 200 shortcuts and over 70 formulas.
Release the Ctrl button type the closing parenthesis in the formula bar and press Enter.
For more shortcuts like this and for building strong muscle memory in Microsoft Excel you can play with keySkillset educational games that include more than 200 shortcuts and over 70 formulas. You can use a combination of the concatenate operator and the SUSTITUTE function to create an excel formula as follows. We know the format of the sentence to be framed. Select cell A3 to add that cell reference to the formula after the equal sign.