Pin and Unpin Columns

Pin Columns to the Worksheet

You can pin worksheet columns, including those with formulas, to the left side of the worksheet. These pinned columns will stay visible regardless of horizontal scrolling. Pin frequently referenced columns, such as important data points, calculations, lookup values, and more.

To pin a column, click the three dots in the column header and select "Pin Column." This will move the column to the left side of the worksheet, where it can be reordered with other pinned columns.

 

Unpin Columns from the Worksheet

Pinned columns always remain on the left side of the worksheet. However, you may want to unpin them if priorities change or if you have too many pinned columns.

To unpin a column, click the three dots in the column header and select "Unpin Column." This will return the column to its original position with the other unpinned columns. (Note: If pinned columns occupy the entire viewing area, you won't be able to scroll horizontally as the scrollbar will be out of view.)

 

PinnedColumn-ezgif.com-video-to-gif-converter.gif

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.