Select the first cell in the range
Hold Shift and select the last cell in the range
Drag to highlight the cells you want
Use the Name Box to type a range like A1:D10
Use formulas with a range like =SUM(A1:A10)
Use a range across columns like A1:D1
Use a range across rows like A1:A10
Use a mixed range like A1:C5
Use Ctrl+Shift+Arrow keys to extend a selection
Use F5 or Ctrl+G to go to a specific range
Use the colon symbol to define a range between two cells
Use ranges in charts, tables, and formulas
Use absolute ranges with dollar signs like $A$1:$A$10
Use named ranges for easier reference
Use the Insert Function box to select a range in a formula