Wednesday, December 26, 2018

Enter and edit data by using shortcut keys

Enter and edit data by using shortcut keys

Press

To

ENTER

Complete a cell entry and move down in the selection

SHIFT+ENTER

Complete a cell entry and move up in the selection

TAB

Complete a cell entry and move to the right in the selection

SHIFT+TAB

Complete a cell entry and move to the left in the selection

ESC

Cancel a cell entry

BACKSPACE

Delete the character to the left of the insertion point, or delete the selection

DELETE

Delete the character to the right of the insertion point, or delete the selection

CTRL+DELETE

Delete text to the end of the line

Arrow keys

Move one character left (LEFT ARROW) or right (RIGHT ARROW) within a cell, or return to the previous location of the insertion point (UP ARROW), or move to the end of the cell contents (DOWN ARROW); or move one cell up, down, left, or right within the datasheet

HOME

Move to the beginning of the line within a cell; or move to the beginning of a row within the datasheet

END

Move to the end of the line within a cell; or move to the end of a row within the datasheet

CTRL+PERIOD

Move clockwise to the next corner of a selected range of cells

F2

Edit or append data to the contents of the active cell

CTRL+; (SEMICOLON)

Enter the date (datasheet only)

CTRL+SHIFT+: (COLON)

Enter the time (datasheet only)

CTRL+C

Copy the selection

CTRL+V

Paste the selection

CTRL+X

Cut the selection

DELETE

Clear the contents of the selection

CTRL+SHIFT+PLUS SIGN

Insert blank cells

CTRL+ –

Delete the selection

CTRL+Z

Undo the last action


2 comments:

  1. Hi all! Our agency is creating a team of specialists in 2d bounding box annotation services. Therefore, if you need a team of remote professionals, then I recommend that you pay attention to our company. We offer only highly professional services, as well as many additional options to ensure security.

    ReplyDelete
  2. Real estate online auction software is a digital platform that allows real estate properties to be sold to the highest bidder in an online auction format. This software provides a simple and convenient way for buyers to participate in real estate auctions remotely from anywhere in the world. With real estate online auction software, sellers can reach a wider audience, generate more interest in their properties, and potentially get a higher selling price. This type of software also allows for transparency in the auction process and provides all necessary information to buyers and sellers in real-time.

    ReplyDelete