And stay tuned for more keyboard shortcuts, moving on to ones that are more obscure but amazingly handy.
End plus any arrow key moves the cursor to the last occupied cell in a column or row of data just before a blank, empty cell.Word Options at the bottom of the window, click Customize in the left pane, and then the Customize button to the right of "Keyboard shortcuts" at the bottom of the Word Options dialog box.CtrlHome moves the cursor to the Home positionthat is, the beginning of the document.In Excel 2007, click Home*Paste*Paste Special*Text*OK*View*Stop Recording.In Excel, ShiftEndDown Arrow and ShiftEndUp Arrow highlight from the cursor position down or up to the end or beginning of the matrix/range row.However, in Word, Redo is shown as a circular arrow, and in Excel, its an arrow that curves to the right.Paste the steSpecial DataType:wdPasteText line from the macro above after the last and before the End Sub line.To assign the keyboard shortcut in Word 2007, click the Office button in the top-left corner, choose.Undo is depicted by an arrow curved to the left in both Word and Excel.In the, macro name field, type.You can paste the same information repeatedly until you cut or copy a new item or text.(Note that the original post of this tip reported that PureText required that you click its icon in your system tray before you press the shortcut keys to paste plain text.(Note: End-Down Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like CtrlEnd).Macros in drop-down list.Therefore, CtrlEnd moves the cursor to the last row and column of the matrix that contains an active cell (or G14).Select t (or whatever template you want to add this macro to) from the.
Please note that in this article, the letter 'F' followed by a number (1 through 12) refers to the function keys.