0
What cell do you activate to freeze rows 1 - 5 in an Excel worksheet?
Wiki User
∙ 11y ago
You would make cell A6 the active cell and then activate the freeze panes option.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How do you lock a Microsoft Excel workbook to always open on the same worksheet and cell instead of on whichever worksheet or cell you were on when you last saved the file?
Private Sub Workbook_Open() Worksheets(1).Activate End Sub In VB worksheet
What is the small black handle on an Excel worksheet?
The one on the cell in a worksheet is known as the fill handle.
A numeric value that originates in a excel worksheet cell is called a data?
A worksheet cell with a numeric value is called a data point.
What helps to set off sections of a worksheet in excel?
cell borders
What is in 6th row and 5th column in excel worksheet?
Cell E6.
What is the name of individual box in Microsoft Excel 2007?
Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.
Which short cut key is used to select the top leftmost cell of the Excel sheet?
Ctrl-Home will bring you to cell A1 in a worksheet in Excel.
What cell does formulas and functions in Excel make use of?
Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.
What is a sparkline in Excel?
It is like a small line chart that fits inside a cell. It can be positioned on a worksheet, usually close to the values it is charting.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
What is the key that selects the cell up one worksheet window from the active cell in Excel workbook?
page up
What is B20 in excel?
It is the reference to the cell formed where column B meets row 20.
