Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm writing a lab report and I have to copy a table from an already printed paper (I don't have access to this file) that looks like this:

enter image description here

As you can see, it looks like where I actually recorded the numbers myself, the cells are a different width than, say, the "Tests with 0.1 M HCI" or "pH after addition of these numbers of drops". I've looked on the web, and it seems you can't set the width of a specific cell, just the whole column or row, so how would I go about doing this?

share|improve this question
add comment

1 Answer

Select the first cell with the text and then all the cells to the right, as many as you need to cover the whole table width. Then click "merge and center" on the home ribbon.

enter image description here

After that, the table looks like this: Several cells have been merged into one single cell that spans several columns.

enter image description here

Be aware that merged cells should be avoided, because they can be counter-productive when selecting whole rows or columns.

An alternative is to Center Across Selection in the Alignment tab of the Format dialog: Select the cells, then right-click and select "Format Cells". Click the Alignment tab and select "Center across selection" from the "Horizontal" dropdown.

enter image description here

The result will look exactly like the merged cells, but individual cells can still be selected.

enter image description here

The only benefit I see with merged cells is that after Merge & Center, you can format the merged cell to be left- or right-aligned if you don't want the text to sit in the center. With "Center across selection" the text can only be centered.

Another, very simple method is to create borders for the table as you need them, i.e. use just an outside border for the title cell, and all borders for the table body. Then hide the gridlines (on the View ribbon) for screen viewing, or don't bother about that for printing, because gridlines don't print, unless you explicitly tell Excel to print them.

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.