How to select all in excel

How to select all down in excel

shift ctrl x down arrow can select all down (only use ctrl shift down arrow You can also select the current column), release ctrl, and use shift to arrow up.

1. Shortcut key Ctrl A

This is the ubiquitous select-all copy method in Windows systems.

Press and hold the first cell, and then use the shortcut key to perform the ultimate move.

Copy all the data.

2. Shift ctrl arrow key

The first method is easy to use, but there is a bug. When a row or column is missing in the middle of the table, it You can no longer jump to copy.

At this time, method two can be used. Select the first column

Shift Ctrl [right]

Shift Ctrl [down ]

When you encounter empty rows and columns, repeat the above operation to copy all the data without the blank table (the blank table in the middle will be copied)

More Excel related For technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to select all in excel. For more information, please follow other related articles on the PHP Chinese website!