Q&A for How to Make Tables Using Microsoft Excel

Return to Full Article

Coming soon
Search
Add New Question
  • Question
    How do I resize the columns?
    Community Answer
    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 12
  • Question
    How do I change the width of a column in Excel?
    Community Answer
    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 2 Helpful 9
  • Question
    How do I make a table in Excel fit the size of a paper?
    Community Answer
    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 11
  • Question
    How do I capitalize the first word in a table?
    Community Answer
    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
    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
    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
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

Return to Full Article

You Might Also Like

Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create Pivot Tables in Excel
How to
Create Pivot Tables in Microsoft Excel to Analyze Data
Remove Table Formatting in Excel2 Easy Ways to Remove Table Formatting in Microsoft Excel
Add Header Row in Excel
How to
Add a Header Row in Excel: Step-by-Step Guide
Add a Row to a Table in Excel
How to
Add Rows to an Excel Table: Step-by-Step Guide
Add Up Columns in Excel
How to
Add Up Columns in Microsoft Excel: Quickly Sum Numbers
Filter by Color in Excel
How to
Filter by Color in Excel
Insert a Table in a Microsoft Word Document2 Quick Ways to Insert a Table in a Microsoft Word Document
Sort a List in Microsoft Excel
How to
Sort a List in Microsoft Excel
Use AutoFilter in MS ExcelEasy AutoFilter Basics for Beginners
Edit Data in Microsoft Excel3 Simple Ways to Edit Data in MS Excel
Quickly Make a Table for WordPad
How to
Quickly Make a Table for WordPad
Create a Form in a Spreadsheet
How to
Create a Form in Excel: Step-by-Step Guide