Select the first Safety Stock cell (C5).Copy that cell, either by using the Ctrl+C shortcut or the Copy icon found on the Home tab or the right-click menu.In this case, you would enter a 3, as shown in cell D2 of Figure 2. Select any blank cell in your worksheet and enter the number to be subtracted.Let’s say that you needed to reduce the units shown in the Safety Stock column of Figure 2 by a quantity of three. While Microsoft brought the most popular choices from the dialog to the ribbon, there are other powerful commands still available in the Paste Special dialog. With 15 ways to paste available through the Paste icon, it’s possible that many people using Excel have abandoned or forgotten the Paste Special dialog. For those of you who prefer to right-click, the commands shown in blue in Figure 1 are available as icons in the right-click menu. When you click the bottom half of the Paste icon, a dropdown appears with choices for Paste Formulas, Paste Transpose, Paste Links, and more. In Excel 2010, 13 other shortcuts were added (see Figure 1). Starting in Excel 2007, Microsoft started offering the Paste Values command as a shorter method than using the full Paste Special dialog.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |