Microsoft Office Tutorials and References
In Depth Information
Cut and Paste, Digital Style
yet again, Excel changes the cell reference back to completely relative (as in
E12). After you’re back where you started, you can continue to use F4 to cycle
through this same set of cell reference changes all over again.
If you’re using Excel on a touchscreen device without access to a physical
keyboard, the only way to convert cell addresses in your formulas from relative
to absolute or some form of mixed address is to open the Touch keyboard and
use it add the dollar signs before the column letter and/or row number in the
appropriate cell address on the Formula bar.
Cut and Paste, Digital Style
Instead of using drag and drop or AutoFill, you can use the old standby Cut,
Copy, and Paste commands to move or copy information in a worksheet. These
commands use the Office Clipboard as a kind of electronic halfway house
where the information you cut or copy remains until you decide to paste it
somewhere. Because of this Clipboard arrangement, you can use these
commands to move or copy information to any other workbook open in Excel or
even to other programs running in Windows (such as a Word 2013 document).
To move a cell selection with Cut and Paste, follow these steps:
1. Select the cells you want to move.
2. Click the Cut command button in the Clipboard group on the Home
tab (the button with the scissors icon).
If you prefer, you can choose Cut by pressing Ctrl+X.
Whenever you choose the Cut command in Excel, the program
surrounds the cell selection with a marquee (a dotted line that travels
around the cells’ outline) and displays the following message on the
Status bar:
Select destination and press ENTER or choose Paste
3. Move the cell cursor to the new range to which you want the
information moved, or click the cell in the upper-left corner of the new range.
4. Press Enter to complete the move operation.
If you’re feeling ambitious, click the Paste command button in the
Clipboard group on the Home tab or press Ctrl+V.
Search JabSto ::




Custom Search