Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adjust rows and columns (2003)

    How can you adjust rows and columns of an entire spreadsheet to the smallest they can be. Sometimes when I change the font size the rows and columns need to be adjusted to eliminate the extra space.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adjust rows and columns (2003)

    Ctrl-A to select all then dbl-click on a row to adjust all and dbl-click on a column to adjust all.

    Note: if the standard row width is wider than some of the cells it will keep the standard. So the statndard font size of the rows should be made as small smaller than the smallest font you will use, otherwise autosize will base it on the largest font in the row.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •