Home > Articles > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

This chapter is from the book

This chapter is from the book

Shortcut for Referencing Ranges

A shortcut is available when referencing ranges. The shortcut uses square brackets, as shown in Table 3.1.

Table 3.1. Shortcuts for Referencing Ranges

Standard Method

Shortcut

Range("D5")

[D5]

Range("A1:D5")

[A1:D5]

Range("A1:D5, G6:I17")

[A1:D5, G6:I17]

Range("MyRange")

[MyRange]

  • + Share This
  • 🔖 Save To Your Account