How to Make a Two Column Spread Sheet in Excel: A Step-by-Step Guide

Creating a two-column spreadsheet in Microsoft Excel is a breeze. Essentially, you’ll open a new Excel workbook, select two adjacent columns, input your data, and then format it to your liking. By following these easy steps, you’ll have a functional two-column spreadsheet in no time!

Step By Step Tutorial: Making a Two Column Spread Sheet on Microsoft Excel

Before we dive into the nitty-gritty, let’s understand what we’re aiming for. A two-column spreadsheet can be a useful tool for various tasks like comparing lists, organizing data side by side, or even for simple accounting. The following steps will guide you through creating one from scratch.

Step 1: Open Microsoft Excel

Start by opening the Microsoft Excel application on your computer.

When you open Excel, you’ll typically see a blank workbook with a single worksheet. This is your canvas for creating your two-column spreadsheet.

Step 2: Select Two Adjacent Columns

Click on the header of the first column you want to use, hold down your mouse, and drag to the next column to select them both.

You’ll notice the columns will be highlighted, indicating they are selected. You can choose any two columns, but for simplicity, we’ll start with columns A and B.

Step 3: Input Your Data

With the columns selected, start typing in your data. Press ‘Enter’ to move down the same column or ‘Tab’ to move to the next column.

Remember, organizing your data neatly will make your spreadsheet easier to read and work with. So think about the order of the information you input.

Step 4: Format Your Spreadsheet

To make your data look neat and tidy, use the formatting options in Excel, such as aligning text, adjusting the column width, and adding borders.

Excel offers a variety of formatting tools. For instance, you can center the text for a header row, make the font bold, add color, or even freeze the top row so that it remains visible as you scroll down.

After completing these steps, you’ll have a two-column spreadsheet that’s ready for use. You can now fill it with data, analyze it, or print it out for a meeting.

Tips: Enhancing Your Two Column Spread Sheet on Microsoft Excel

  • Ensure your headers are descriptive and clearly define the data in each column.
  • Use the ‘Merge & Center’ feature for headers that span across multiple columns.
  • Consider using ‘Conditional Formatting’ to highlight important data automatically.
  • Utilize ‘Sort & Filter’ capabilities to organize your data efficiently.
  • To prevent data loss, regularly save your work with the ‘Save’ feature or by pressing ‘Ctrl+S’.

Frequently Asked Questions

How do I resize the columns to fit my content?

Auto-fit the column width by double-clicking on the right border of the column header. This will automatically adjust the column width to fit your content.

Can I add more columns to my spreadsheet later?

Absolutely! You can insert additional columns at any time by right-clicking on a column header and selecting ‘Insert.’

How do I copy a two-column format to another sheet?

Select the columns, right-click, and choose ‘Copy.’ Then go to the new sheet, right-click where you want to place the columns, and select ‘Paste.’

What if I need to move data from one column to another?

You can cut and paste the data, or simply click and drag the data to the new column.

Can I print my two-column spreadsheet?

Yes, just go to ‘File,’ then ‘Print.’ Make sure your print settings are correct, such as adjusting the scale to fit the sheet on one page.


  1. Open Microsoft Excel
  2. Select Two Adjacent Columns
  3. Input Your Data
  4. Format Your Spreadsheet


There you have it, a simple guide to making a two column spread sheet on Microsoft Excel. Whether you’re a student, a business professional, or someone who loves organizing data, mastering spreadsheets is a valuable skill. Excel spreadsheets can help you keep track of your information, compare data, and present your findings in a clear, professional manner. Plus, with the tips provided, your spreadsheets will not only be functional but also visually appealing.

But don’t stop here. Excel is a powerful tool with endless possibilities. Explore features like charts, pivot tables, and macros to take your data analysis to the next level. The more you practice, the more proficient you’ll become. Happy spreadsheeting!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy