Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Selecting entire sheet for formatting

Staycie Francisco
Staycie Francisco ✭
edited 12/09/19 in Archived 2017 Posts

Is there any way to select an entire sheet for formatting? Thanks!

Tags:
· Share on FacebookShare on Twitter

Comments

  • Jeremy Myers
    Jeremy Myers ✭✭✭✭✭

    Selelct the top line, hold down control, select the bottommost line.  Format the entire thing in one swipe.  Or if you are only formatting a single column, use the formatt painter.

    · Share on FacebookShare on Twitter
  • Amy_API
    Amy_API ✭

    For me when I select the first row then hold shift and select the last row it will highlight all rows in between.

    · Share on FacebookShare on Twitter
  • YolandaFay
    YolandaFay ✭

    Easy enough answer to the question I also had :) Does anyone know if Smartsheet is planning to allow "ctrl + A" to select all cells in the future? When you have 500+ rows, scrolling to select the last row isn't ideal....I did find it also works if you select the first column + shift and last column.

    · Share on FacebookShare on Twitter
  • walkmovelive
    walkmovelive ✭

    Hi!

    Found that you can do command + Shift + arrow key down and select everything.

     

    · Share on FacebookShare on Twitter
  • Zachw
    Zachw ✭✭✭

    Shift + Click on rows/columns to select the whole sheet works, but is very cumbersome and annoying IMO.

    Smartsheet should really add a method to select all cells such as:

    • Ctr + A
    • Click on very top left of grid (as in excel or gDocs)
    • Any other method to select the entire sheet.
    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories