+ Reply to Thread
Results 1 to 4 of 4

Column widths on multipage spreadsheets

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    2

    Column widths on multipage spreadsheets

    I'm very raw at Excel- when I do reports the width of columns stays the same on all pages. I want different widths on page 2 than page one, page 3 different than page 2, etc- how is that done- probably pretty simple I hope- THANKS Gary from Ohio

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Column widths on multipage spreadsheets

    Not simple. Column widths in Excel are the same all the way down a worksheet. You would need to print page 1, resize the columns, print page 2, ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-28-2014
    Location
    Hackney, South Australia
    MS-Off Ver
    MS Office 2003
    Posts
    15

    Re: Column widths on multipage spreadsheets

    You will need to do it one spreadsheet at a time I mean adjusting column widths for your projects.

  4. #4
    Registered User
    Join Date
    09-26-2014
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    2

    Re: Column widths on multipage spreadsheets

    thanks for the input. to clarify- doing a one page spreadsheet at a time means each sheet would have no cell references usable from & to the other pages, correct?
    I'm doing a 6 page spreadsheet that has 25 year loan amortizations, & dozens of variables all throughout the 6 pages & all using variables from the other pages. But the report is basically unviewable when the column widths of the 1st page have to stay the same through the next 5 pages. It seems Excel is too cumbersome to use- am I correct?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] ActiveControl - Return non-Multipage control when Form contains Multipage?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 08:37 PM
  2. Column chart with varying column widths and picture fill help
    By ldewson86 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-12-2013, 05:39 AM
  3. [SOLVED] User Form ListBox Column Widths - How to set widths for unknown number of columns
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2013, 05:24 AM
  4. Column Widths
    By lukela85 in forum Excel General
    Replies: 1
    Last Post: 12-02-2009, 06:20 PM
  5. [SOLVED] One column with different widths
    By Calpitor in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-14-2005, 02:57 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1