0
In a macro, the cell at the intersection of the third column and the fifth row can be referenced as range("C5") or cells(5, 3). In the cells property, the numbers can be replaced with variables.
Wiki User
∙ 10y ago
Wiki User
∙ 9y agoColumns (horizontal) are referenced Alphabetically; while rows (vertical) are referenced numerically
Add your answer:
Earn +20 pts
What represents the columns in a worksheet?
Columns are referenced by letters.
What Are the Intersecting structures of an Excel worksheet called?
Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.
What are the vertical sectors of an excel worksheet?
Columns.
How much cells can a spreadsheet in Microsoft Excel have?
Excel 2003 and earlier has 16,777,216 cells per worksheet (65,536 rows * 256 columns). Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).
What are the letters at the top of an Excel worksheet that designate the columns?
column labels
If you shrink a worksheet will excel be able to display more columns?
probably
An excel worksheet is divided into?
Rows and columns, which in turn gives you cells.
How many columns in microsoft 2007?
The last cell in Excel 2007 is XFD 1,048,576 There are 16,384 columns and 1,048,576 rows.
When using spreadsheet software what are the rows and columns collectively are called?
Cells
What feature can you use to quickly insert totals in worksheet rows or columns in Excel?
The Autosum.
What is an excel worksheet The worksheet is a organized rectangular grid containing vertical columns and horizontal rows?
OK. You answered your own question.
A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet is an Excel?
table
