Easy Way to Move Tabs in Excel

BY STANLEY ZAROWIN

Q. I have a spreadsheet file that contains a bunch of worksheets. The problem is they are out of order. Is there some easy way to change the lineup of the tabs without going through the hassle of creating new tabs and then copying the contents?

A. There’s no need to create new tabs or copy anything. Here’s how to customize their order: Say you want to move the February tab to come after January, which, of course, is where it belongs. Just grab the February tab with the mouse and drag it to between January and March.

SPONSORED REPORT

Tax reform complicates year-end tax planning

Get your clients ready for tax season with these year-end tax planning strategies, which address how to make the most of recent tax law changes, such as the new deduction for qualified business income and the cap on the deductibility of state and local taxes.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.