![]() ![]() To exit a selection without pasting, press the Escape key on your keyboard.Ĥ. If you perform a separate action after copying or cutting and before pasting, the selection will automatically be unselected. The dotted lines around the selection alerts you to the fact that the cells are currently selected. Excel will automatically paste the contents over the correct number of cells, you need not select the cells.Ĭaution: When selecting cells to copy or cut and paste, the original selection will remain selected until you paste (see screenshot of selected cells below). Position your cursor in the top left most cell of the selection where you wish to paste the copied or cut cells and press Ctrl+v to paste the cells. Once you have made your selection, press Ctrl+c to copy the selection to the Office Clipboard or Ctrl+x to cut the selection.ģ. First you need to select the cell(s), row(s) and/or column(s) you wish to copy.Ģ. ![]() Cut, copy and paste are the three musketeers of data entry. Shortcut key combinations make performing all of the above actions quick and easy.ġ. Some cells contain so much data that you may want to format these by inserting a ‘paragraph’ break in the cell. Some cells may contain a lot of information in the form of multiple paragraphs of text where you may only wish to copy, edit or format a section of the text. It will also ensure your data is consistent as you did not have to re-enter the information. When you work with large amounts of data, knowing how to cut, copy and paste contents from one section into another may save you a lot of time. For example if you bold a word in a cell and select another cell and press Ctrl+y, the bold action will be repeated. You can also use Ctrl+y to repeat certain actions. To redo any actions that you used undo on, press Ctrl+y. Pressing Ctrl+z repeatedly will undo the last series of actions that you have performed.Ģ. The undo and redo shortcut combinations allow you to undo and redo actions without lifting your fingers from the keyboard.ġ. The redo function acts as a further insurance policy against the undo function and allows you to reinstate actions that you reversed using the undo function. * Shortcuts to Undo and Redo The ability to undo mistakes, unintentional formatting or data entries and edits, is extremely useful. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĮxcel Keyboard Shortcuts for Cell Contents Test ![]() * Shortcuts to Display Cell Value or Formula Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to cut, copy, paste, and format the contents of the cells. * Shortcuts to Insert Comments and Hyperlinks * Shortcuts to Cut, Copy, Paste and Edit Cell Contents Excel Tutorial – Keyboard Shortcuts for Cell Contents Tutorial with corresponding Free Online Test – Excel 2010 Keyboard Shortcuts for Cell Contents ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |