Keyboard shortcuts: Microsoft Windows

This document provides an overview of Microsoft Windows keyboard shortcuts. For shortcuts specific to Mac OS, see Keyboard shortcuts: Mac OS.

You can also view keyboard shortcuts within Sigma by pressing ctrl + /. 

General

Open search

/

Open help

shift + /

Show shortcuts

ctrl + /

Common

Undo

ctrl + Z

Redo

ctrl + shift + Z

Refresh data

ctrl + shift + R

Query history

ctrl + shift + H

Clear selection

Esc

Selection

Select multiple, individual cells or columns

ctrl + left-click

Select a range of cells or columns

shift + left-click

Select all columns

ctrl + A

Select column or cell furthest to the right

ctrl + →

Select column or cell furthest to the left

ctrl + ←

Select top-most cell in column

ctrl + ↑

Select bottom-most cell in column

ctrl + ↓

Select all columns or cells to the right

ctrl + shift + →

Select all columns or cells to the left

ctrl + shift + ←

💡

You can resize multiple columns at the same time by first selecting multiple columns using either of the Select multiple rows or columns shortcuts and then clicking and dragging one of the columns to your desired size. All selected columns are resized simultaneously.

Workbook

Edit column formula

=

Add column

shift + ＋

Hide column

shift + H

Rename column

shift + R

Delete column

Del

Toggle column grouping

shift + G

Add column filter

shift + F

Move column to start

ctrl + shift + ↑

Move column to end

ctrl + shift + ↓

Show column details

ctrl + I

Toggle maximize

space

Toggle table

shift + T

Next element

tab

Previous element

shift + tab

Add element

ctrl + shift + ＋

Customize element

ctrl + \

Delete element

ctrl + Del

Duplicate element

ctrl + D

Sort ascending

S + A

Sort descending

S + D

Copy format

ctrl + alt + C

Paste format

ctrl + alt + V

Create container from selection

ctrl + G

Remove container from selection

ctrl + shift + G

Column formats

Format: auto

!

Format: number

#

Format: currency

$

Format: percent

%

Format: scientific

^

Decrease precision

<

Increase precision

>

Formula editing

Open formula bar

=

Move up

ctrl + ↑

Move down

ctrl + ↓

Submit query

ctrl + enter

Open autocomplete

ctrl + space

Toggle comments

ctrl + /

Start of the line

ctrl + ←

Indent line

tab

Indent less

shift + tab

Delete current line

shift + alt + K

Select line

ctrl + L

Shift line up

ctrl + alt + ↑

Shift line down

ctrl + alt + ↓

Join lines

ctrl + J

Duplicate line

shift + ⌘ + D

Text editing

Bold

ctrl + B

Italic

ctrl + I

Create link

ctrl + K

Toggle bullet list

ctrl + shift + 8

Toggle ordered list

ctrl + shift + 7

Align left

ctrl + alt + L

Align center

ctrl + alt + T

Align right

ctrl + alt + R

Open formula bar

=

Input tables

Fill down

ctrl + D

Fill right

ctrl + R

Select cell on right

tab

Expand selection right

shift + →

Select cell on left

shift + tab

Expand selection left

shift + ←

Select cell down

enter

Expand selection down

shift + ↓

Select cell up

shift + enter

Expand selection up

shift + ↑

Select row

shift + space

Add row

⌘ + ⌥ + =

Cut and copy

ctrl + X

Paste

ctrl + V

Undo

ctrl + Z

Redo

ctrl + shift + Z