# Edit shelves

Add, remove, move and copy shelves and bays on a fixture, one at a time or many at once from the Excel file.

***

Click a shelf’s edge to select the shelf, or a bay’s outer edge to select the bay, and use its **Detail** panel.

- A shelf has **Add Shelf Above**, **Add Shelf Below**, **Reverse Products** and **Remove Shelf**.
- A bay has **Add Bay Left**, **Add Bay Right** and **Remove Bay**.

The selection on the fixture has the same add and reverse controls: plus buttons on a shelf’s top and bottom edges or a bay’s left and right edges, and arrows in the middle of a shelf to reverse its products. With a shelf selected, `R` also reverses them. [Undo](/studio/keyboard-shortcuts) reverses any of these changes.

- **Add Bay Left** and **Add Bay Right** add a bay with one empty shelf.
- **Remove Shelf** also removes the shelf’s products. Removing a bay’s last shelf removes the bay, and a fixture always keeps at least one shelf.
- **Remove Bay** also removes the bay’s shelves and products. A fixture always keeps at least one bay.
- **Reverse Products** needs at least two products on the shelf.

## Move or copy a shelf or bay

Drag a shelf by its shelf edge, or a bay by its outer edge, to where you want it. A shelf can go to another bay. When you drop it, it moves there and the other shelves or bays make room.

Hold `Alt` (Windows) or `Option` (Mac) as you drop to copy the shelf or bay, with its products, instead of moving it.

To move a product, see [Adding and editing products](/studio/adding-and-editing-products#moving-products).

## How shelves are numbered

The **Detail** panel shows a selected shelf’s **Shelf** and **Bay** numbers. Shelves count up from the bottom and bays from the left, unless the project’s **Shelf Order** or **Bay Order** setting, under **Settings**, is **High to Low**.

## Edit many bays in Excel

To remove a lot of bays at once, edit the [Studio Excel file](/studio/studio-excel-file):

1. In the navigation panel, open **Project actions** beside the project’s name and choose **Download**.

2. Open the tab for the fixture’s scenario.

3. Delete the rows of each bay you want to remove, found by the **bay** column, and save the file. With the default Bay Order, the lowest bay number is the left-most bay. To remove the second bay below, delete the two rows with 1 in the **bay** column.

   | product\_id | bay | shelf | facings\_high | facings\_wide | position |
   | ----------- | --- | ----- | ------------- | ------------- | -------- |
   | 10023       | 0   | 0     | 1             | 2             | 0        |
   | 10047       | 1   | 0     | 1             | 3             | 0        |
   | 10052       | 1   | 1     | 1             | 2             | 0        |
   | 10068       | 2   | 0     | 2             | 5             | 0        |

4. Back in Studio, open **Project actions** and choose **Close project**. Delete the project saved under **Local Storage**, then drop the edited file onto the upload box.

> You cannot undo back past the edited file. Keep the file you downloaded in step 1 in case you need to go back.
