# Google Sheets

# How to Use Google Sheets

## Step 1: Create a spreadsheet

To create a new spreadsheet:

1. Open the Sheets home screen at [sheets.google.com.](https://sheets.google.com/)
2. Click New ![Add](https://lh3.googleusercontent.com/031izoDKMxdXAU77HRfxgztmGRusj8fE1D8SYiw0QMEeXPMgkVuaTHYKyfRSoYZI3xM1=w18-h18 "Add"). This will create and open your new spreadsheet.

You can also create new spreadsheets from the URL [sheets.google.com/create](https://sheets.google.com/create).

## Step 2: Edit and format a spreadsheet

You can add, edit, or format text, numbers, or formulas in a spreadsheet.

- [Edit and format a spreadsheet](https://support.google.com/docs/answer/46973?hl%3Den%26ref_topic%3D1361470)
- [Use formulas and functions in a spreadsheet](https://support.google.com/docs/answer/46977?hl%3Den%26ref_topic%3D1361471)

## Step 3: Share & work with others

You can [share files and folders](https://support.google.com/docs/answer/2494822) with people and choose whether they can view, edit, or comment on them.

# Edit & format a spreadsheet in Google Sheets

## Edit data in a cell

1. Open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Click a cell that’s empty, or double-click a cell that isn’t empty.
3. Start typing.
4. **Optional:** To add another line within a cell, press **⌘ + Enter** on a Mac or **Ctrl + Enter** on Windows.
5. When you’re done, press **Enter**.

## Format one or more cells

1. Open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Click a cell, then drag your mouse across nearby cells you want to select, or hold **⌘** on a Mac or **Ctrl** on Windows and click another cell.
3. To format text or numbers in a cell, use the options in the toolbar at the top.

## Format your data

Here are some options for formatting your cells or text. You can find these options above the document.

<div id="bkmrk-%C2%A0undo-%C2%A0redo-%C2%A0bold-%C2%A0i"><div><div><div><div>- ![Undo](https://lh3.googleusercontent.com/CHuRqTmzu2hpM0Gpog720hYtLNP9M2Raq_QzLpBpFIPfUD6wMwaLKNJf5ljtcs7DGA=w18-h18 "Undo") Undo
- ![Redo](https://lh3.googleusercontent.com/vXEbHzzgxLrfFI1ODR_ad6BCPOAn-JTLqBUc8x77ga9H71TioPiPZaddqxhKrlyMWYU=w18-h18 "Redo") Redo
- ![Bold](https://lh3.googleusercontent.com/_T2kybuciVtdpD5ygzl3Kb9UM49es9eqZ3u8J5wZ-a4CAD31kMEln8Srg5rMdzJZlg=w18-h18 "Bold") Bold
- ![Italic](https://lh3.googleusercontent.com/ElyCDjZQxNiqfJzBfgAWwOSJX1sm9oyYjVODJDRmKTtA3jn5CPqDEQQcryuve3p8aQw=w18-h18 "Italic") Italic
- ![Strikethrough](https://storage.googleapis.com/support-kms-prod/SNP_3832520C8ACB462119E2A0A14321C72512F6_6048463_en_v0 "Strikethrough") Strikethrough
- Change font or font size
- ![Color text](https://lh3.googleusercontent.com/HxbZh0aTXg-UifoaypjvRO-NZSsxahe4w29GLfwnskfzFaj_ylZjMdbF6VP-RHSGw-F7=w18-h18 "Color text") Change text color
- ![Fill color](https://lh3.googleusercontent.com/6DCwjNw7blFzegoF6vXVEoPrDbEos-yTVZ3zTnRc_qtkeF_ti2EQbVIxKjU7oA7NZDQ=w18-h18 "Fill color") Change cell fill color 
    - Single color
    - Alternating colors
- ![Borders](https://lh3.googleusercontent.com/Nct7FrmBKBS_U4Jfoi3ayy6AvX7ApeESA8cldH_t7P3YRThZhBWxWfpqPjjZ3N9Kk8aT=w18-h18 "Borders") Change cell borders 
    - ![Border color](https://lh3.googleusercontent.com/RLgyKVNzaYhcnwF4XQm9ttq8xEp_ELHwFtob2TTgbnoYnvGa1SJiVD96W0fzs68_OoY=w18-h18 "Border color") Change border color
    - ![Border style](https://lh3.googleusercontent.com/jP1Dzx3f6DjsfzoaFr1EbylIwtp9bVENEPQYOfGzQ1bJZF97qcnCemFoA_E5ZQjIsg=h18 "Border style") Change border style
- ![Merge cells](https://lh3.googleusercontent.com/u1NsUDAGj1wz2gzldR6XCkXTjkmvVOI0MDvKr0sFuXjMEjRWDynu8UKLzTQKnwFFz3k=w18-h18 "Merge cells") Merge cells
- Change horizontal text alignment
- Change vertical text alignment
- Rotate text in a cell
- ![Wrap](https://lh3.googleusercontent.com/ruBFwRqPZXklK-DGoFrVDv_ZX58XaNoAYUkWknhk3BOl6fBYEmS4ExvNeyyj5PiRYJA=w18-h18 "Wrap") Wrap text in a cell

</div></div></div></div></div>To format part of the text or content in a cell, double-click the cell, select what you want to format, then select a formatting option.

## Align &amp; resize objects

<div id="bkmrk-move-an-object-anywh"><div></div><div><div><div>Move an object anywhere you want or change its size. Lines will appear that show what it lines up with, equal space between objects, and when one object is the same size as another.</div></div></div></div>## <a id="bkmrk-" name="add_theme"></a>Add a theme 

You can apply changes to the format of an entire spreadsheet with themes.

1. Open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. At the top, click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Theme**.
3. Choose an available theme or click **Customize** to create your own.

**Notes:**

- If you create a custom theme, the most recent version will be saved.
- Colors from your current theme are available in the text and fill color pickers.

## Parts of your spreadsheet affected by theme 

<div id="bkmrk-text-font-and-color-"><div><div></div><div><div>- Text font and color of grid text, charts, and pivot tables
- Hyperlink color of grid text
- Chart background color
- Color of series in charts
- Pivot table background

</div></div></div></div>**Note:** If you change the format of an item in your spreadsheet, it will override the theme.

# Use conditional formatting rules in Google Sheets

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number.

1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Select the cells you want to apply format rules to.
3. Click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Conditional formatting**. A toolbar will open to the right.
4. Create a rule. 
    - **Single color**: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met.
    - **Color scale**: Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow ![Down Arrow](https://storage.googleapis.com/support-kms-prod/76B4941B08D1516AC7336D5A3C2E7914920D "Down Arrow").
5. Click **Done**.

<div id="bkmrk-example"><div><div><a aria-expanded="true" class="zippy index1 goog-zippy-expanded" data-stats-idx="1,3" data-stats-ignore="" data-stats-imp="" data-stats-ve="2" role="button" tabindex="0">Example</a></div><div><div></div></div></div></div>A teacher can highlight test scores to see which students scored less than 80%.

<div id="bkmrk-on-your-computer%2C-op-0"><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Select the test scores.
3. Click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Conditional formatting**.
4. Under "Format cells if," click **Less than**. If there's already a rule, click it or **Add new rule** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Less than**.
5. Click **Value or formula** and enter 0.8.
6. To choose a red color, click Fill ![Color fill](https://lh3.googleusercontent.com/q_VFSqjbh-0IbvSAObg1EAOj7joV92KCmhCbaSjIZKMaF4y-Sd1f2VVkv0bwMLOAPAQ=w18 "Color fill").
7. Click **Done**. The low scores will be highlighted in red.

</div></div></div>## Use advanced conditional formatting

<div id="bkmrk-use-custom-formulas-"><div><div><a aria-expanded="true" class="zippy index2 goog-zippy-expanded" data-stats-idx="2,3" data-stats-ignore="" data-stats-imp="" data-stats-ve="2" role="button" tabindex="0">Use custom formulas with conditional formatting</a></div><div><div></div></div></div></div>You can use custom formulas to apply formatting to one or more cells based on the contents of other cells.

<div id="bkmrk-on-your-computer%2C-op-1"><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Select the cells you want to format.
3. Click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Conditional formatting**.
4. Under the "Format cells if" drop-down menu, click **Custom formula is**. If there's already a rule, click it or **Add new rule** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Custom formula is.**
5. Click **Value or formula** and add the formula and rules.
6. Click **Done**.

</div></div></div></div>**Note**: Formulas can only reference the same sheet, using standard notation "(='sheetname'!cell)." To reference another sheet in the formula, use the [INDIRECT](https://support.google.com/docs/answer/3093377) function.

### Example 1

To highlight when there's more than one occurrence of the same value in your data:

<div id="bkmrk-on-your-computer%2C-op-2"><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Select the range you want to format. For example, cells A1 to A100.
3. Click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Conditional formatting**.
4. Under the "Format cells if" drop-down menu, click **Custom formula is**. If there's already a rule, click it or **Add new rule** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Custom formula is.**
5. Write the rule for the first row. In this case the rule would be, "=COUNTIF($A$1:$A$100,A1)&gt;1."
6. Choose other formatting properties.
7. Click **Done**.

</div></div></div></div>### Example 2

To format an entire row based on the value of one of the cells in that row:

<div id="bkmrk-on-your-computer%2C-op-3"><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets/u/0/).
2. Select the range you want to format, for example, columns A:E.
3. Click **Format** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Conditional formatting**.
4. Under the "Format cells if" drop-down menu, click **Custom formula is**. If there's already a rule, click it or **Add new rule** ![and then](https://lh3.googleusercontent.com/3_l97rr0GvhSP2XV5OoCkV2ZDTIisAOczrSdzNCBxhIKWrjXjHucxNwocghoUa39gw=w18-h18 "and then") **Custom formula is.**
5. Write the rule for the first row. For example, if you want to make the whole row green if the value in column B is "Yes", write a formula like "=$B1="Yes"."
6. Choose other formatting properties.
7. Click **Done**.

</div></div></div></div>### Absolute vs. relative references

Often, you will need to add dollar signs ($) in front of letters and numbers in formulas so that the formatting is applied using absolute references as opposed to relative references (A1 to B1, A2 to B2).

<div id="bkmrk-use-wildcard-charact"><div><div><a aria-expanded="true" class="zippy index3 goog-zippy-expanded" data-stats-idx="3,3" data-stats-ignore="" data-stats-imp="" data-stats-ve="2" role="button" tabindex="0">Use wildcard characters with conditional formatting</a></div><div><div></div></div></div></div>You can use wildcard characters to match multiple expressions. Wildcard characters can be used with the "Text contains" or "Text does not contain" fields while formatting.

<div id="bkmrk-to-match-any-single-"><div><div>- To match any single character, use a question mark (?). For example, a text rule containing "a?c" would format cells with "abc," but not "ac" or "abbc."
- To match zero (0) or more characters, use an asterisk (\*) . For example, a text rule containing "a\*c" would format cells with "abc," "ac," and "abbc" but not "ab" or "ca."
- To match a question mark or asterisk in text, you can escape the wildcard characters by adding a tilde (~) in front of them. For example, a text rule containing "a~?c" would format cells with "a?c" but not "abc" or "a~?c."

</div></div></div>**Notes**:

- To remove a rule, point to the rule and click Remove ![Remove](https://lh3.googleusercontent.com/BZ4bD0q7UU_F0Ljtv_oc3ZHPaPbdFA7Z-6jpNHxajcYmrOj1Jy1izEajlia5i6rJKnCv=w18-h18 "Remove").
- Rules are evaluated in the order listed. The first rule found to be true will define the format of the cell or range. To reorder rules, click and drag them.
- If you copy and paste from a cell or range that has formatting rules, these rules will be applied when you paste the copied data.

# Sort & filter your data in Google Sheets

You can sort data in alphabetical and numerical order, or use filters to hide data you don't want to see.

**Note**: [Filter views](https://support.google.com/docs/answer/3540681#filter_view) are only available on a computer. See the [FILTER](https://support.google.com/docs/answer/3093197) article for info about the function.

## Sort data in alphabetical or numerical order

1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Highlight the group of cells you'd like to sort.
3. Click **Data** ![and then](https://lh4.googleusercontent.com/kfNHdjKxcNDulFe54jpq_aLskWqdghyZLdVwM9zqK7Z8yBK5-vYyevNTezRZCf6yVPyOPPMhmBpBzsQ7doWg30UDL2YvimLWzZ99QXwcd-8E3t_pM_qDcdDQm7dDdgSwPVpJZg58 "and then") **Sort range**.
4. If your columns have titles, click **Data has header row**.
5. Select the column you'd like to be sorted first and choose a sorting order.

- To add another sorting rule, click **Add another sort column**.

6. Click **Sort**.

## Sort an entire sheet

<div id="bkmrk-on-your-computer%2C-op-0"><div><div></div><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. At the top, right-click the letter of the column you want to sort by.
3. Click **Sort sheet by A to Z** or **Sort sheet Z to A**.

</div></div></div></div></div>**Tip**: If your sheet includes a header row, [freeze the first row](https://support.google.com/docs/answer/9060449).

## Sort by color

<div id="bkmrk-on-your-computer%2C-op-1"><div></div><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Select a range of cells.
3. Click **Data** ![and then](https://lh6.googleusercontent.com/avwUN6-zU6OQvgJ4-T-iv5FOI0bouq5vD77O5roZ1uXuqAFsZj90aISaySzITAM_0N3wLzAZyTihP5kUEbl4i1nx2AiCziY3XNoAIKREjX9cUCLLZXyef7TFhJ3xpi6ouhAn5oyd "and then") **Create a filter**.
4. To see filter options, go to the top of the range and click Filter ![Filter](https://lh4.googleusercontent.com/NSe_cMW8YwmX-aH1yLdqXfBSWCm7c2_a3I1yyfDUoXa2PenxrVnKxR-uzTNBZ_duF6x5D4AiRe5Xt4eoFuq4LHXTjEfuX9wZ5sLQD9BpcRbcRtW1Rd8KtXl-fjq01AIPYqrjEFFm "Filter"). 
    - **Sort by color:** Choose which text or fill color to filter or sort by. Cells with the color you choose to sort by will move to the top of the range. You can sort by conditional formatting colors, but not alternating colors.
5. To turn the filter off, click **Data** ![and then](https://lh4.googleusercontent.com/souGNTVlL1msX-h7l815PWsfKx5Dk4IFEEblICuWdms6S91ffWhCYyPt7CgQb8UGF2RPsPX1irVPugACuq0FKlYU22GbkIZQ87qehIt6ToB-J02jiW_WjhW5aTVE-0a9-c5nVtaC "and then") **Turn off filter**.

</div></div></div></div>## Filter your data

To see and analyze data in a spreadsheet, use filters. Filters let you hide data that you don’t want to see. You’ll still be able to see all your data when you turn the filter off.

### Filters vs. filter views

Both filters and filter views help you analyze a set of data in a spreadsheet.

Filters can be useful if:

- You want everyone viewing your spreadsheet to see a specific filter when they open it.
- You want your data to stay sorted after using the filter.

Filter views can be useful if:

- You want to save multiple views.
- You want to name your view.
- You want others to be able to view the data differently. Since filter views need to be turned on by each person viewing a spreadsheet, each person can view a different filter view at the same time.
- You want to share different filters with people. You can send different filter view links to different people so everyone will see the most relevant information for them.
- You want to make a copy or create another view with similar rules.
- You don't have edit access to a spreadsheet and still want to filter or sort. In this case, a temporary filter view will be created.

**Note**: You can import and export filters, but not filter views.

### Use filters in a spreadsheet

To temporarily hide data in a spreadsheet, add a filter.

**Note**: When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.

## Filter your data

To filter your data:

<div id="bkmrk-on-your-computer%2C-op-2"><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Select a range of cells.
3. Click **Data** ![and then](https://lh6.googleusercontent.com/0D1gXOBZ7vmhdu5yqFPwv3byX-0W6GN-JlrgNF-RQmueANKVKq2tucE94lMaEMpAFy4XTr_eSQfdYJF1E-rIoCc4HyuVYEZ4h9tuGzgoWby98-LVtGPlwMXygbv4wrQ348-In0S9 "and then") **Create a filter.**
4. To see filter options, go to the top of the range and click Filter ![Filter](https://lh6.googleusercontent.com/EKt4dPmDnaZCJlqAP0o2VKlr6tU94KtZ2CAJrcbKe2QAgkh66n1zE8XNttCrW1Lg7HoFvlJ6zGHOuLadwGqxhgCP8i6ciV7rZ03Jzipkg4-_jgrFk6gxncdbBnXY_GjfjyuCgzCU "Filter").

- **Filter by condition**: Choose conditions or write your own.
- **Filter by values**: To hide data points, uncheck the box next to the data point and click OK.
- **Search**: Search for data points by typing in the search box.
- **Filter by color:** Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.

5. To turn the filter off, click **Data** ![and then](https://lh4.googleusercontent.com/CpBcqZHFP45D9KV0hpNiL65LJoyzXu9FgXoUDFA7fGppX39b5dzwtdnpDbvcL7QQBNxRerdWHC9yNT5wCmYqswtqLHJ9zLH5b1-hMUaiyvzbUypOsoRyCC9GP1N4kK5ouirzQ7jf "and then") **Turn off filter**.

</div></div></div></div>**Tip**: You can sort data with a filter turned on. Only the data in the filtered range will be sorted. Learn how to sort data.

### Create, name, and save a filter view

Use a filter view when:

- You want to save your filter and use it later.
- You don't want to disrupt others' view of the data.
- You want to share a link to a specific filter with others.
- You can’t edit a spreadsheet, but you want to filter or sort data.

Create, save, or delete a filter view

<div id="bkmrk-on-your-computer%2C-op-3"><div><div></div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Click **Data** ![and then](https://lh6.googleusercontent.com/fYTc18ErhNaq1h7p6zYtE7brlh10ZZ_l2n8FB6Vt3l9RaKbKDXMjxjw8zMpz5Ed735PUVBUHoowOUH18m0DFLHDgpPhuI1s6Wb65QS-cPUDnjMin8o42KqysPgzF1HIi3OytrPr8 "and then") **Filter views** ![and then](https://lh6.googleusercontent.com/tybfeSPKTmc_lkE1VS4HFKknHbCIxWow1WJAVR49l0a1aZ-MU3wuZV8f2x3HBuFZb-tlmDw45d-xSqhm5n94ySahIZNP0D8GYQ0FqUbIVQxhPUDMiN3uhlPedsZAL0q9D_QiMLTY "and then") **Create new filter view**.
3. Sort and filter the data.
4. To close your filter view, go to the top right and click Close ![Close](https://lh5.googleusercontent.com/5uCFegw9J1_v7FNcZP5Fs8Fh0TKixNppoNJ2WWYpVuDL6AzuvGkdur1dUQTe1COE3olMFghdMTz_1jd1Bwi8KxcCdddPIEhvyUa-5XUp5dXhhpMmVU-Os2IouFWfFXiTYjyHwSuV "Close").
5. Your filter view is saved automatically.

</div></div></div></div>To delete or duplicate a filter view, in top right, click Options ![Settings](https://lh4.googleusercontent.com/epS-gXLI11nmbCyI2ZAsbfNA8wilBir4DaQ8g6NrNTAG9ekMYXNyJ60CABdv_c7BEfs-mCr7a0djqnQzDqP4vMT-gFQ_sVk_hjNM8EBq_M-U5aSrBAMN1ueJ706-SLlpV4iRvOaN "Settings") ![and then](https://lh3.googleusercontent.com/1E5UPasbIetOOOFJK7p8cphiIJXJ89mFaGpUf0RGaj5YFqc-69Hz3EVsZoPdxBlS3hgKiIfj_3-w6MVDFivukAAzvTa0MvTK20sdz5VX55r3fEKwqP7idJI8tTndFXlS_011x3Oq "and then") **Delete or Duplicate**.

## Rename a filter view

<div id="bkmrk-on-your-computer%2C-op-4"><div></div><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Click **Data** ![and then](https://lh4.googleusercontent.com/YnhVS_rhh6QiRhyPJkVg6mZp3LNcd3O2HhGALLFm5o7zSqRDiNJaLihIJVHVc9UDaWQB4sSO1WgFKKAnbmRETtVe79-gHSpnK2tv1NUqc8azSx3gmI0YLVoXu7prfWvlAV7mkTqO "and then") **Filter views**.
3. Select a filter view.
4. Click the filter view name in the top left of the black bar and type the new name.
5. Press Enter.

</div></div></div></div>## See an existing filter view

<div id="bkmrk-on-your-computer%2C-op-5"><div></div><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Click **Data** ![and then](https://lh4.googleusercontent.com/JUvka1FtpWrM207vi-8swCiF1XZFG_t7jyCxH5b9ds5mDGSFpvSvSwIJGKCCsQjXauqB8KnDZbcEZkSRS1NFnWt1jK2ZNrIspfLJQRAvW8CAVOJymGCpr0aOVpM2abEDAJlI_Whs "and then") **Filter views**.
3. Select a filter view.
4. Your filter will be applied to the spreadsheet.
5. To close your filter view, go to the top right and click Close ![Close](https://lh3.googleusercontent.com/9MqTYvsLa4Qg7n-_qGp6QPQaSwXNHaB0zQoc3BbuzLuQ5P3hCTp2wV2sBG6fvNjihAx2dEzLf6S82qayND_o6Te9ZR0J1Bory1QHJPkIVf9LgfXMmgpMYnd3uwM-qY-9GFxwXEf4 "Close").

</div></div></div></div>## Save a filter as a filter view

<div id="bkmrk-on-your-computer%2C-op-6"><div></div><div><div><div>1. On your computer, open a spreadsheet in [Google Sheets](https://docs.google.com/spreadsheets).
2. Apply a filter.
3. Click **Data** ![and then](https://lh6.googleusercontent.com/W02uTnMuvzLMnY84PWQjBIXiZ2XmUek97pdYmXYYfDCNCqm8dep8ABZ_NdNyYEvUdaf6fr6dHETqrL_8dHLlspEMZxqdZg3zOmw3ju_Ha4yWaCOj5C_BfRuxDfMTDe6bYVgiOUsv "and then") **Filter views** ![and then](https://lh6.googleusercontent.com/UYowNpNo_kFkViQ6w_ewBc_l8btf_Pu8xyfi7LvrIQDynoT5f-suhhuryr7P7rxvfDm2-dQfzHF6HZJc8HE6K3DClMuD7E_FYg019okRdKjzWVlux4tcEcDudHrsnCxJt4chglIb "and then") **Save as filter view**.

</div></div></div></div>## Use filter view with "view only" access

If you have permission to view a spreadsheet but not edit it, you can still use filter views:

<div id="bkmrk-to-apply-existing-fi"><div><div><div>- To apply existing filter views, click **Data** ![and then](https://lh5.googleusercontent.com/2ikvcWX9-nXrHPjGn6SUgOaIBL97oi9PBsw7A5x6Tqzf7eGq9oJuPtYhIp_Gz06mDtO7GevfUxyJctFQXeXRVorDS0T55CoeQcjtFGAlupwVTdqH3ibOyghry-BYBZWgYcRVL67j "and then") **Filter views**.
- You can create a temporary filter view that only you can use. Because you don’t have "edit" access to the spreadsheet, the filter view won't be saved.
- Only users with permission to edit a spreadsheet can create filter views that anyone viewing the spreadsheet can use.

</div></div></div></div>