+ Reply to Thread
Results 1 to 3 of 3

Shift some columns to align with other columns

  1. #1
    Registered User
    Join Date
    01-29-2024
    Location
    Illinois
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Question Shift some columns to align with other columns

    I have made a small spreadsheet with 14 rows and the first 4 rows has 13 columns and the last 10 rows has 12 columns. I want to center the last 10 rows with the first 4 rows. Can I shift the last 10 rows over without moving the first 4 rows?
    thanks
    Jcreek
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Shift some columns to align with other columns

    Hi,

    If I understood you well, it's not possible.

    If you want it printed like that, think about copying to Word. One of options is to copy as 2 separate tables and then in table options set the same table width for the whole table in both cases.

    BTW: If not needed for some specific reason - try to avoid using old file format xls. Since more than 15 years a standard excel fileformat is xlsx
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-29-2024
    Location
    Illinois
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Shift some columns to align with other columns

    Thank You I will try Word

+ 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] compare 2 columns and shift columns down or up until the line matches
    By BryanRobson in forum Excel Programming / VBA / Macros
    Replies: 40
    Last Post: 11-23-2023, 04:48 AM
  2. [SOLVED] Align Columns
    By StreekyD in forum Excel General
    Replies: 26
    Last Post: 03-20-2019, 07:05 PM
  3. Replies: 5
    Last Post: 10-06-2017, 03:59 PM
  4. [SOLVED] Align 3 columns with 2 columns of matching data
    By loritee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2013, 10:36 AM
  5. Align 3 columns with 2 columns of matching data
    By bearnbillie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 08:33 AM
  6. Formula to align two columns with nearly similar text and attached numeric columns
    By Benefits Recon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 12:03 AM
  7. How to align entries in columns so other columns will follow ?
    By Artur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2005, 04:15 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