copy visible cells in excel 2013 for mac

The full tracking numbers should be visible now.

Step 6: Select Number under the Category section at the left side of the window, change the value in the Decimal places field to 0, then click the OK button. Step 5: Right-click on the selected cells, then click the Format Cells option. Step 4: Select the column with the scientific notation numbers again. If automatically resizing the column didn’t do anything, then your cells might not be in the right format, so continue with step 4 below. If you are having difficulty doing it this way, you can also autofit the column by clicking the Format button in the Cells section of the ribbon, then clicking the AutoFit Column Width option. Step 3: Position your mouse on the right border of the column heading (the cursor should change to look like a vertical line with an arrow coming out of either side), then double-click your mouse to automatically resize the column to fit the width of your tracking numbers. If the tracking numbers are in a row instead, click the row number. Step 2: Click the column letter containing the tracking numbers that are displaying incorrectly. Step 1: Open the spreadsheet containing the tracking numbers that are currently displaying as scientific notation. If that is the case, then you can just stop at that point. We will show you both ways as one long method, but you may find that the first part, which consists of making the column wider, is enough to fix the issue. There are two potential ways to resolve this issue.

This means that they are probably in a format like 1.23456E+7, or something similar. The steps below will assume that you have a spreadsheet full of tracking numbers, and that they are all displaying as scientific notation. How to Display Full Tracking Numbers in Your Cells in Excel 2013 Fortunately you can resolve this problem by expanding the column or, if that doesn’t work, by changing the format of the cells.

Almost all of the customers receiving those packages will want a way to track their shipments, so you may find yourself in possession of an Excel file with a lot of tracking numbers.īut Excel has an annoying habit of displaying large numbers, such as tracking numbers, as scientific notation when the number is wider than the column in the spreadsheet. Many large businesses will ship dozens, if not hundreds or thousands of packages in a day.

Copy visible cells in excel 2013 for mac