Moving Power View Sheet Tabs in Excel 2013

I’ve heard a number of requests for the ability to reorder Power View sheet tabs in Excel 2013. While this is currently a bug that will be fixed in the future, there is a work-around to do this now.

Assuming you have a workbook that contains a number of Power View sheets and you want to move the last one you created (“Power View4” in the screenshot here) to be the leftmost tab in the workbook.

MPVS1

First, click on the plus sign to create a new Excel sheet.

MPVS2

Move that sheet to be next to the Power View sheet you want to move. With the new Excel sheet selected, hold down the control key and click on the Power View sheet you want to move so that both tabs are selected.

MPVS3

Now, click and drag the Excel sheet to the desired location. The Power View sheet will come along for the ride.

MPVS4

When the Power View sheet is in the desired location you can select and delete the new Excel sheet that you created.

MPVS5

Advertisements
4 comments
  1. Steve said:

    Thanks. very simple and works great. Just avoided a lot of frustration.

  2. Amy said:

    Awesome. thanks for this solution.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: