Q&A for How to Make Tables Using Microsoft Excel

Return to Full Article

Coming soon

Add New Question

Question

How do I resize the columns?

Community Answer

Place your mouse between the columns until the cursor changes into a double arrow pointing to the left and to the right. Left click and hold. Drag the mouse, while holding the left button, to the left to shrink or to the right to enlarge the column.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 11
Question

How do I change the width of a column in Excel?

Community Answer

If you go up to "Format," and select "Width" you will be able to change the size.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 9
Question

How do I make a table in Excel fit the size of a paper?

Community Answer

In Excel 2013, click the "Page Layout" tab, then click the "Size" dropdown menu. Most printers use 8.5 x 11 inch paper.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 9
Question

How do I capitalize the first word in a table?

Community Answer

Select the cell to the right of the name, and type =PROPER(cell with the incorrect name ie. a1) Then you can drag that down and it will correct for the rest.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 4
Question

How do you make two separate tables, where editing in one table doesn't affect the other table?

Community Answer

You could create (copy/paste, or create from scratch) the second table in a separate worksheet and label the sheets (Format: Rename sheet) accordingly.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 4
Question

How do I label the columns?

Community Answer

Hover your mouse over the existing column label (A, B, C, and so on). Move your pointer around slowly until it changes. Then, right-click and select the "Rename" option from the menu that appears.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 0