answersLogoWhite

0

The text must be in the left hand cell. Select the range then 'merge and centre'.

This can be achieved using the merge and centre tool from the toolbar/ribbon or from the format cells menu.

Al

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

How do you i center the label found in a1 across the selected cell in mircsoft excel?

Select the cells and then either click the merge and center icon on the standard toolbar or go to the Format menu and pick Cells and in Alignment, pick Merge Cells and set the alignment to be centred.


When and why are cells selected in Microsoft Excel?

Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.


What is a selected group of cells in excel called?

range


In Excel When selected a column header how many cells are selected?

When you select a column header in Excel, all the cells in that column are selected. This means 65536 cells (the maximum number of rows in Excel). Similarly, if you select a row header, this will select 256 cells (the maximum number of columns in Excel). For more information on Excel Size and Cells: http://www.excel-hocam.com/mod/resource/view.php?id=18&username=guest


What does a copy button do in excel?

It copies what is in the selected cell or cells at that time.


How do you name a selected range of cells in Excel 2007?

Select your cells. Go to the Formulas tab. Select the Name Manager. Then you can create a name for the selected cells.


What is Excel's command creates one cell out of the selected cells and centers the contents within the new cell?

Split and center. It is in the home tab in the alignment group :)


What does the alignment tab allow you to do in Excel?

Within the Alignment section on the Home tab of Excel, you can align the text of a selected cell from center, left, right or justified. It also allow you to merge cells and wrap text.


In Excel what is a highlight?

When you select cells, their colour changes to show that they have been selected, and that is often referred to as a highlight. So you could say that highlighted cells are selected cells.


What does the Clear All command in Excel do?

It clears the content and formatting of the selected cells.


What does ctrl plus R do in Microsoft Excel?

If you have a range of cells selected which includes more than column, it copies what is in the first column to the right. So whatever is in the first cell on each row in the area selected, is copied across that row within the area selected.


What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function