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
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.
Click on cell "A1" and then type "Megabytes."
Click on cell "B1" and then type "Kilobytes."
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."
Click on cell "B2," type "=A2*1024," then press "Enter." This converts the 2,000 megabytes to 2,048,000 kilobytes.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for