How do I Use Megabytes & Kilobytes in an Excel Spreadsheet?

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How do I Use Megabytes & Kilobytes in an Excel Spreadsheet?
Bytes are units of storage on a computer. (computer memory image by Rob Hill from

If you're making an information technology Excel spreadsheet, then you are likely using megabytes and kilobytes in your cells instead of regular numbers. A byte is a unit of eight bits of information on a computer, a kilobyte is 1,024 bytes, and a megabyte is 1,024 kilobytes. Instead of typing in the numbers and the letters "KB" or "MB" each time you want to use a kilobyte or megabyte in an Excel spreadsheet, you can set up an Excel spreadsheet with kilobyte and megabytes columns.

Skill level:

Other People Are Reading


  1. 1

    Start Microsoft Excel by double clicking on the Desktop icon or by clicking on the "Start" or "Microsoft" button and then locating Excel in "All Programs > Microsoft Office." A new spreadsheet will open.

  2. 2

    Click on cell "A1" and then type "Megabytes."

  3. 3

    Click on cell "B1" and then type "Kilobytes."

  4. 4

    Enter the megabytes in your data into column A, starting in cell "A2." For example, if you want to enter 2,000, 4,000, and 10,000 kilobytes, then click on cell "A2" and type "2000," then click on cell "A3" and type "4000" then click on cell "A4" and type "10000."

  5. 5

    Click on cell "B2," type "=A2*1024," then press "Enter." This converts the 2,000 megabytes to 2,048,000 kilobytes.

  6. 6

    Click on the "Fill handle" in cell B2. The fill handle looks like a little black square in the bottom right corner of the cell. Drag the fill handle down to cell B4. This moves the Excel formula down to all cells in the column and converts all of the megabytes to kilobytes.

Tips and warnings

  • If you want to convert megabytes to kilobytes, then use the formula =A2/1024 instead of =A2*1024.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.