answersLogoWhite

0


Best Answer
  1. Highlight all the cells across the columns where you want to center the text.
  2. Select cell format and choose alignment, then check merge cells.
  3. Observe that now you have one cell that combines all the highlighted cells.
  4. Type your text and select center.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

TEXT OR NUMBERS:

  1. Highlight the cells across the width of the page where you would like to center your text.
  2. Merge the cells.
  3. Align center.

OBJECT, SUCH AS AN IMAGE:

  1. Insert your object.
  2. Drag the object to where you want it. There is no automatic page center option in Excel, like you would find in Word.
This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Select more than one cell. You can then click on the icon. You can also press Ctrl - 1 and go to the Alignment tab in the Format Cells dialog box that will have opened and then click on the option there.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Click on the center text button or go to the cell format section and choose horizontal alignment center.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

Click on the center icon. Go to the format menu and pick Cells and then Alignment and from there you can pick whichever format of alignment you want.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Go to the alignment tab in the Format Cells dialog box, which you can activate using Ctrl - 1. In the Horizontal and Vertical options, set both to Center.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Highlight the cell and click on the text format to align center.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When using Excel how do you center a cell both horizontally and vertically?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you center vertically?

This depends on what tools you have at hand. Are you using a computer and trying to vertically center a letter in a table cell? or are you nailing a letter on a board? On the computer the program you are using may have a "center vertically" among it's formatting commands.


How do you vertically center a letter?

This depends on what tools you have at hand. Are you using a computer and trying to vertically center a letter in a table cell? or are you nailing a letter on a board?


What are the 3 important things to remember when using latitude and longitude?

1.longitude lines go vertically 2. latitude lines go horizontally 3.latitude is the angular distance o degrees of the equator By "vertically" is meant "north-south". By "horizontally" is meant "east - west".


What does cross checking mean?

It means checking an answer by using a different method. It is most apparent in spreadsheet situations, where adding everything vertically and then horizontally can be cross-checked by adding everything horizontally and then vertically.Also, in hockey, it is a penalty given for checking a player with one's stick held horizontally in front of oneself.


How high can jaguar jump?

Jaguars can jump vertically around 10ft and horizontally around 19ft, to get higher up trees they climb using their claws, even up vertical tree trunks.


How high can a jaguar jump?

Jaguars can jump vertically around 10ft and horizontally around 19ft, to get higher up trees they climb using their claws, even up vertical tree trunks.


How do you play piano using left and right hand?

If you're talking about simultaneous playing, playing left hand and right hand at the same time requires practice. Try thinking of the music vertically as well as horizontally.


What does daverage do in Excel?

It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.


How do you scroll horizontally on keyboard?

Using the arrows -> and <-


How do you find slope of line using graphs?

The slope of the line (on a linear equation) is rise over run. Meaning how far apart vertically (up and down) two points on the graph are, divided by how many units apart they are horizontally (left to right).


How do you set a horizontally and vertically repeating background image to an HTML page using inline CSS?

Use the "style" attribute in the "body" tag to set inline styles. Set the "background-image" and "background-repeat"CSS attributes to the body element. "background-image" should have a path to the image you want as a background, and "background-repeat" should have "repeat," indicating you want the image to tile both horizontally and vertically. For example (replace path-to-image.jpg with a relative or absolute path to the background image of your choice): ---- ... ----


What does minced garlic mean?

it means that the garlic is crushed or diced into very small pieces. so basically, all you have to do to mince garlic is to peel it, slice it multiple times vertically then horizontally (to form small squares) then using a rocking motion with the knife, mince it!