Learn more

Changing the size of the spreadsheet columns

Changing the spreadsheet column headings

Eliminating excess column width on the spreadsheet (Best Fit Column)

Making spreadsheet columns non-scrolling

Turning spreadsheet columns on or off

Changing the order of the spreadsheet columns

To change the order of the spreadsheet columns:

  1. Use the mouse to select the headings of the columns you want to move. You can move one column, or multiple, adjacent columns. Columns that have both a quantity and a unit move the two together.

    The cursor changes to a four-way arrow.

  2. Press and hold the mouse button as you drag the selected columns to their new location. Release the mouse button to insert the columns.

Tips:  

  • You can use this feature to customize the appearance of the Spreadsheet report:

    1. Follow the procedure above to move the spreadsheet columns where you want them.
    2. Select the Spreadsheet report from the Estimate Reports group on the Reports tab (or on the Reports menu, in classic view).

    3. Click [Report Options], and then click [Prefill from Spreadsheet] in the Spreadsheet Report Options window.

      The report settings now match the setup of your estimate spreadsheet.

  • You can also change the order of the spreadsheet columns in the Modify Spreadsheet Layout window.

    1. Click Home tab > Sequence group > [Layout]. (In classic view, click View > Spreadsheet Layout.)

    2. Select the column name you want to move, and then click Reposition Column to move the column to a new location.