# How to Sort Numbers in Google Sheets

Viewport: 1920x950 @0.800000011920929x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Sort Numbers in Google Sheets
   - body: This guide provides a step-by-step walkthrough on sorting numbers in Google Sheets. Follow these instructions to easily organize your numerical data in ascending or descending order.
   - voiceover: This guide provides a step-by-step walkthrough for sorting numbers in Google Sheets. Follow these instructions to organize your data in ascending or descending order.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhq6zk00120cl2c8ctgvei.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the column you want
   - source type: IMAGE
   - description: Open Your Google Sheets Document
   - target: (210, 151), rect: top=142.94921875 left=75 width=1960.99609375 height=23.984375
   - hotspots: 1
     - hotspot_01 (210, 151), rect: top=142.94921875 left=75 width=1960.99609375 height=23.984375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Click on the lettered header of the column you want to sort. This action highlights the entire column, indicating it is selected.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhqb1b00140cl2548k6k0j.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhlvm40000033paz91zos9.png
2. step_02 [image] - Click Data tab
   - source type: IMAGE
   - description: Select the Range of Numbers
   - target: (317, 51), rect: top=33.984375 left=298.84765625 width=47.3046875 height=23.984375
   - hotspots: 1
     - hotspot_01 (317, 51), rect: top=33.984375 left=298.84765625 width=47.3046875 height=23.984375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Navigate to the top menu and click on the 'Data' tab. This will open a dropdown menu with various data-related options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhqb1x00150cl27ash67j6.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhlz9i0002033pdro5or6g.png
3. step_03 [image] - Click Sort range and choose Advanced range sorting options
   - source type: IMAGE
   - description: Access the 'Data' Menu
   - target: (854.0137483238134, 176.94353109514316), rect: top=192.91015625 left=637.08984375 width=209.74609375 height=17.5
   - hotspots: 1
     - hotspot_01 (854.0137483238134, 176.94353109514316), rect: top=192.91015625 left=637.08984375 width=209.74609375 height=17.5
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Within the 'Data' tab dropdown menu, click on 'Sort range'. A sub-menu will appear; choose 'Advanced range sorting options' to proceed.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhqb2n00160cl23lmafmyv.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhm3z70004033p9h3u9i0g.png
4. step_04 [image] - Tick the checkbox if data has header row
   - source type: IMAGE
   - description: Choose 'Sort Range' Option
   - target: (1118.0250706052009, 497.9435020764794), rect: top=496.73828125 left=958.22265625 width=40 height=40
   - hotspots: 1
     - hotspot_01 (1118.0250706052009, 497.9435020764794), rect: top=496.73828125 left=958.22265625 width=40 height=40
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: If your data includes a header row, tick the checkbox labeled 'Data has header row'. This ensures that the header is not included in the sorting.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhqb5b00170cl2025tej2f.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhm4va0005033pv41y0hp6.png
5. step_05 [image] - Choose sorting ascending or descending
   - source type: IMAGE
   - target: (1355.1670162696437, 572.6928047073156), rect: top=532.6928053033621 left=1107.667019957681 width=247.49999631196266 height=79.99999880790712
   - hotspots: 1
     - hotspot_01 (1355.1670162696437, 572.6928047073156), rect: top=532.6928053033621 left=1107.667019957681 width=247.49999631196266 height=79.99999880790712 style=STYLE2
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Select either 'Sort A to Z' for ascending order or 'Sort Z to A' for descending order. Click the 'Sort' button to apply the chosen sorting order to your column.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhqb6v00180cl27gx6bess.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhm6h20006033pymxo9yq3.png
7. [Outro] Next: Verify the Sorted Data
   - body: After sorting, ensure that the numbers are organized correctly by double-checking the range. If needed, you can repeat the steps to sort in the opposite order.
   - voiceover: After sorting, review your data to ensure it is organized as intended. If necessary, repeat the steps to adjust the sorting order or apply sorting to additional columns.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hhlq7v004bl80cyaj9iqqy/cm6hhq8oa00130cl2haihd2zg.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6hhlq7v004bl80cyaj9iqqy/tour