Press control+spacebar to select the entire column of the active cell or shift+spacebar to select the entire row of the active cell. With the active cell surrounded by empty cells, press command+A to select the entire worksheet. When active cell is adjacent to other data, press command+A to select all contiguous cells with data.
- [Voiceover] You can select an entire column…or an entire row with a mouse or with a keyboard,…and sometimes it just depends upon whether your hands are…on the keyboard or on the mouse or track pad.…Maybe I've been making some changes to the data here.…I'm using the right arrow.…I'm in this column.…I want to select the entire column.…So, my hands are near the keyboard.…I'll hold down the Control key as I click spacebar.…It highlights the entire column.…Think of C for control, c for column.…At different times maybe I want the entire row…to be highlighted.…
Here, too, I'll be using the spacebar,…but now with the Shift key.…So Shift-spacebar highlights the entire row.…I think for many people you're more likely…to use the mouse for that,…but, nevertheless, that's a technique for selecting data.…Now zooming back a little bit on this worksheet,…using that slider bar in the lower right-hand corner,…I might want to highlight all the data that's…within this list.…Now notice that there are column headings…out in columns L, M, and N.…
Author
Dennis Taylor
Released
5/11/2016The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple right-drag
- Undoing and redoing with keyboard commands
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Applying formatting with keyboard shortcuts
- Accelerating copying and moving data with drag and drop
- Creating formulas rapidly
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome37s
-
-
1. Top Ten Shortcuts
-
2. Display and Navigation Shortcuts
-
Navigate within worksheets6m 38s
-
3. Selection Shortcuts
-
4. Data Entry and Editing Shortcuts
-
Accelerate data entry8m 11s
-
-
5. Formatting Shortcuts
-
6. Drag-and-Drop Techniques
-
7. Formula Shortcuts
-
Use AutoSum shortcuts4m 9s
-
Use rounding shortcuts7m 54s
-
Generate random numbers9m 13s
-
8. Operational Shortcuts
-
Realign imported text4m 20s
-
9. Data Management Techniques
-
10. Tips for Using Charts and Visual Objects
-
11. Ten Tiny Tips
-
Conclusion
-
Goodbye26s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Select entire row, column, or worksheet