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 10
  • 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

Merge Cells in Excel
How to
Merge Cells in Microsoft Excel: A Quick Guide
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Use If‐Else in Excel
How to
Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
How to
Unhide All Rows and Columns in Microsoft Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Ethernet Doesn't Have a Valid IP Configuration
How to
Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
Password Protect an Excel Spreadsheet
How to
Password Protect a Microsoft Excel Spreadsheet
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create a Graph in Excel
How to
Create a Chart in Microsoft Excel: Step-by-Step Guide
Freeze Cells in Excel3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
Unhide Columns in Excel
How to
Show Hidden Columns in Microsoft Excel & Unhide Column A
Make a List Within a Cell in ExcelThe Best Ways to Make & Format Lists in Excel