School Data Tutorials
Tutorials
  • Home
  • New to Excel? Start here!  
    • Basic navigation and hot keys
    • Select rows and columns
    • Freeze panes
  • Formatting  
    • Page setup and set print area
    • Format cells
    • AutoFormat
    • Format rows and columns
    • Conditional formatting
  • Working with data  
    • Sort
    • Paste special
    • Filter
  • Entering data  
    • AutoFill
    • Custom fill
    • Data validation
  • Charts, formulas, pivot tables  
    • Charts and graphs
    • Formulas and functions
    • Trace cell references
    • Protection
    • Pivot tables and charts
  • Linking, importing data  
    • Link Excel to other programs
    • Import data into Excel
  • Data collection templates
Other Stuff
  • Help!
  • About this site
  • About CASTLE
  • Acknowledgments
  • Contact us
  • Login (for CASTLE staff only)
Powered by Squarespace

Select rows and columns

[4 minutes total]

These four tutorials show how to select rows and columns in your data. They also teach how to rearrange, resize, and/or move your rows and columns to enhance the readability or create subsets of your data.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

  • Selecting rows and columns (0:56)
  • Using the Ctrl key to select noncontiguous rows and columns (1:19)
  • Using the Ctrl key to copy and paste noncontiguous rows and columns (1:04)
  • Selecting the entire worksheet (0:57)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.

Creative Commons License
This work is licensed under a Creative Commons License.