Highlight whole sections of Data

1. Click on the first cell.

2. Hold the shift key

3. Click on the End key

4. Click on the down arrow or left/right arrow depending on the direction needed.

Highlight your entire worksheet.

  1. Click CTRL + A.

a. If the active cell is above or to the right of data, only the information to left and above will be highlighted.

b. Clicking CTRL+ A a second time will highlight all data.

2. Another option: Click on the button in the upper-left corner of your spreadsheet where the column and row headers interest.

3. Click CTRL+Shift+Space Bar (Works same was as Step 1 above).

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Beanstalk CFO Group
Beanstalk CFO Group

Written by Beanstalk CFO Group

Our firm, Beanstalk CFO Group, delivers financial management & advice to small business owners.

No responses yet

Write a response