【英文】Excel快捷键

Posted on Edited on Views:

Preface

Excel shortcuts

Quickly remove decimal points

  1. Select all cells that need to remove decimal points
  2. Ctrl+Shift+1

Quickly find the differences between two columns

  1. Select two columns of data
  2. Ctrl+\

Quickly calculate the sum

  1. Select the rows and columns that need to be summed, you can sum the current row or column
  2. If the diagonal is also selected, the total sum can be calculated
  3. Alt+=

Quickly generate alternate row highlighting

  1. Select the cells that need to be beautified
  2. Alt+T

Quickly generate charts

  1. Select the cells that need to generate charts
  2. Alt+F1

Quickly generate line charts

  1. Select the cells that need to generate charts
  2. Ctrl+Q

Select all used cells

  1. Ctrl+L

Completion

References

Little Red Book - Workplace Understanding Brother
Little Red Book - Workplace Understanding Brother