Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Columns in split view
I have a form that has some information in the top 14 rows that is
like a header to a report. Below that I have a list of items that are many columns wide (65+). The problem is that when I print it is too small because of the size to fit all on one page. So I came up with a way to HIDE columns what were unused so I can print a more concise and relavent report. However I need to be able to fix the top 14 rows so any column in that row does not get hidden. So somewhat like splitting the form in to 2 views and only hiding columns in the bottom view. Can something like this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Columns in split view
You cannot hide parts of columns.
All or nothing. Perhaps a text box could be inserted across A1:H14(or whatever) and the relevant always-to-be-printed data copied and pasted into the textbox? You can hide columns behind the textbox. Gord Dibben MS Excel MVP On Sun, 14 Dec 2008 06:32:46 -0800 (PST), gtslabs wrote: I have a form that has some information in the top 14 rows that is like a header to a report. Below that I have a list of items that are many columns wide (65+). The problem is that when I print it is too small because of the size to fit all on one page. So I came up with a way to HIDE columns what were unused so I can print a more concise and relavent report. However I need to be able to fix the top 14 rows so any column in that row does not get hidden. So somewhat like splitting the form in to 2 views and only hiding columns in the bottom view. Can something like this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
view different parts of sheet - split view | Excel Discussion (Misc queries) | |||
Resetting view when hiding detail in outline level | Excel Discussion (Misc queries) | |||
multi split view | Excel Discussion (Misc queries) | |||
Is it possible to view Excel split screen by tab within same file | Excel Discussion (Misc queries) | |||
How do I view cell text without it visually hiding other cells? | Excel Discussion (Misc queries) |