Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - When there are many rows in excel, how to quickly select all the data? You don't need a blank table, you need to select a range with data.
When there are many rows in excel, how to quickly select all the data? You don't need a blank table, you need to select a range with data.
Excel table quickly select all data operation method is as follows:

1.CTRL+ Click to select the data area, and double-click to select the whole table.

2. Place the mouse on any cell in the data area, and then press ctrl+shift+8 to select the continuous area.

3. Place the mouse on the first row of the data area and press ctrl+shift+ DOWN key to select all rows of the data area.

4. Place the mouse in the first column of the data area and press ctrl+shift+ RIGHT ARROW key to select all columns in the data area.

5. Place the mouse in the upper left corner of the data area, drag the scroll bar to the last line, hold down shift and click the cell in the lower right corner.

6. Select a specific discontinuous area: hold down CTRL and SHIFT, click and select.

Related articles
  • What hospital in Nanjing has good ears?
  • How to correct buck teeth? In addition to wearing braces
  • Who knows about a Korean movie starring Lim Soo Jung? Thanks
  • Application for judicial expertise
  • How about space star Xi branch?
  • How is the goddess temperament tempered?
  • What industry is the most explosive after the epidemic?
  • Collect the detailed information of photoelectric switch completely.
  • What are the abdominal muscles of girls?
  • Small eyes, small forehead, big face, big nose, and some dark circles. Now 18 years old, male. Seek answers.

    • copyright 2024 Plastic Surgery and Aesthetics Network All rights reserved