0
What is the feature that creates a single cell out of many cells when using excel?
Wiki User
∙ 9y ago
Merging, or sometimes called Merge and Center, as content can be centered in the resulting cell.
Note, however, that only the content in the first (top, left) cell will be retained using the standard Merge or Merge and Center features.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
Which Excel feature can be utilized to only allow the input of certain data such as dates times or numbers?
Validation is the feature that can limit what is entered into cells in Excel.
What are two or more selected cells that Excel also treats as a single cell?
Depending on what you mean, it could be a range, which is a group of cells in Excel, that can be referenced in a formula as a block, but they are not a single cell then. You could be referring to cells that have been merged, in which case Excel treats them as a single cell.
Which Excel feature enables you to select certain types of cells like number cells or text cells?
The Goto Special command.
How do you get merged cells to auto height with out a macro in Excel?
I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.
What best describes Excel's Auto Fill feature?
On request, cells are automatically filled with data, usually based on cells above, or to the left.
In excel which feature could be used to print a very long worksheet on a single sheet of paper?
scale to fit
Which feature could be used to print a very long worksheet on a single sheet of paper in excel?
scale to fit
What excel feature lets you assign a specified format to cells that contain specific texts?
You can use Conditional Formatting to achieve this.
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 is an Excel feature that outlines cells in color to indicate which cells are used in a formula and that positions the insertion point within the cell?
range finder
What feature of Excel works behind the scenes correcting common mistakes?
Autocorrect can do it and you can also set up Data Validation for cells.
How do you take and Excel 2003 cell and break it into multiple cells?
A cell is the smallest unit in Excel, you cannot break it into multiple cells. However, if you have merged multiple cells into one large cell, you can break that merged cell into multiple cells by unmerging the single large merged cell.
