How to split the spreadsheet, not the screen

[Nathan]

Hi,

I have a question about splitting, and hopefully I'm able to be clear.
Here's what I want to do:

I have a sheet with several tables on the same topic. I want to keep them
all in the same sheet for simplicity (I have numerous sheets within one
workbook). Some of the tables require different column widths. For example,
the information in Column A for Table X requires a different width than the
information in Column A in Table Y. Is there a function to have different
column widths (or other needs) for multiple tables in the same sheet?

Thank you,
Nathan

 

[Susan]

Is there a function to have different

column widths (or other needs) for multiple tables in the same sheet?

in a word, no.

however, i do this all the time by using merged cells. i make all the
column widths = 2 & then merge as many of them as i need to make the
individual cells the right size. i do this mostly to duplicate
government forms (shhhhh!).

keep in mind that VBA hates merged cells & limits what you can do with
them.
hope this helps
susan

 

[Luke M]

Not really. You could of course use multiple columns to form a single "Column
A" in one of your tables, and just format the cells to look like a single
cell, as opposed to two cells.

another idea would be to use the camera tool to arrange snapshots of all
your tables into one common area. First, create all your tables as desired on
a worksheet, using as much space as needed. Now, create another worksheet to
act as your display sheet. Copy a table, go to the display sheet. Now,
holding Shift, go to edit. Select "Paste Picture Link". You now have a
picture of those cells, but you can move it around freely. Repeat for all
your other tables. Note that the pictures will reflect whatever changes are
made to the actual tables. The downside of this is that the pictures are
completely output oriented. You can however double click on any of the
pictures to be taken to the actual data.

 

[Gord Dibben]

Not only VBA that hates merged cells.

Merged cells will cause you grief when copying, pasting, sorting, filtering
and a host of other functions.


Gord Dibben MS Excel MVP