How to use microsoft excel 2010 viewer how to#
How to use microsoft excel 2010 viewer update#

YouРІР‚в„ўre using Excel for Microsoft 365: MicrosoftР’В might add the feature to other versions of Excel later, but for now, itРІР‚в„ўs only available on MS365.

If you donРІР‚в„ўt see the Geography Data Type in Microsoft Excel, please make sure your device meets the following requirements: To do so, right-click the cell that contains your location, and then click Data Type > Refresh.

How to use microsoft excel 2010 viewer update#

This means youРІР‚в„ўll want to update your spreadsheet so it contains the most current data. Since the Geography data comes from an online source, itРІР‚в„ўs updated regularly. To add a piece of data from the Data Type Card to your spreadsheet, hover your cursor over it, and then click the Extract to Grid icon that appears. You can drag the bottom-right corner to enlarge it. YouРІР‚в„ўll then see an easy-to-read card containing all the details. To see it, just right-click the cell containing your location, and then select РІР‚СљShow Data Type Card.РІР‚Сњ This gives you a snapshot of the data with the labels. Just click the cell containing the data to see what it is in the Formula Bar.Р”Р„long with the data in the list, you can view whatРІР‚в„ўs called a Data Type Card for your location. If you add several items for your location, though, and donРІР‚в„ўt label them with column headers, itРІР‚в„ўs easy to forget what each is for. You can continue to add data from the list, and theyРІР‚в„ўll populate in subsequent cells on the right. When you select something from the list, it will appear in the cell to the right of your location immediately. You can select an abbreviation, area, total tax or unemployment rate, urban population, and more. For example, if you type a country, youРІР‚в„ўll see more options than you would for a city. The data available here will depend on the kind of location youРІР‚в„ўve selected. This will display a scrollable list of data from which you can make selections. Now, itРІР‚в„ўs time to pull in the data you need.Р”В¬lick the cell that contains the location name, if necessary, and then click the Insert Data icon that appears next to the cell.

If you donРІР‚в„ўt see the location you want, you can type it in the Search box at the top of the sidebar to look further.Р”Р„fter you select a location in the Data Selector, youРІР‚в„ўll see a map icon next to the location name and the sidebar will disappear.

How to use microsoft excel 2010 viewer how to#

In the Order list, select the order that you want to apply to the sort operationР’В - alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).Р”Р‡or more information about how to sort data, see Sort data in a range or tableР’В .Click РІР‚СљSelectРІР‚Сњ below the correct location on the right.

In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. In the Sort by list, select the first column on which you want to sort. On the Data tab, in the Sort & Filter group, choose Sort. Select a single cell anywhere in the range that you want to sort. Select a single cell in the column on which you want to sort.Р”В¬lick to perform an ascending sort (A to Z or smallest number to largest).Р”В¬lick to perform a descending sort (Z to A or largest number to smallest). The range can include titles that you created to identify columns or rows. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column).