Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/unhide with data below
I have a spreadsheet set up something like this
A B C D E 1 data 2 data 3 totals 4 5 calculations for totals 6 more calculations Sorry...very rough. I have data in columns A to BZ that are totaled in row 49. From row 53 and below, columns A to F, I have additional calculations based on the total sin row 49. Sometimes i do not use every column (data is calculated bi-weekly) and I hide the columns I have not used, since I have to print a report on one page. The problem is, I often do not use columns CDEF, but I can't hide them because of the data in the calculations below. Is there a way to hide the data above and not below? I cannot move the calculations to another sheet, because they need to be printed on the same page, unless there is a way to do that? Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/unhide with data below
That is what I figured. The problem then lies in Printing. The data needs to
be above, and the calculations below, all on one page when printed. Any other ideas? Is there a way to print more than one worksheet on one page, so if I moved the data to another sheet, print both sheets on one page? "Nick Hodge" wrote: Rachael You certainly cannot hide part of a column...all or nothing I am afraid... can you not duplicate the calculations below the other columns, calculations do not need to be below their columns -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Rachael" wrote in message ... I have a spreadsheet set up something like this A B C D E 1 data 2 data 3 totals 4 5 calculations for totals 6 more calculations Sorry...very rough. I have data in columns A to BZ that are totaled in row 49. From row 53 and below, columns A to F, I have additional calculations based on the total sin row 49. Sometimes i do not use every column (data is calculated bi-weekly) and I hide the columns I have not used, since I have to print a report on one page. The problem is, I often do not use columns CDEF, but I can't hide them because of the data in the calculations below. Is there a way to hide the data above and not below? I cannot move the calculations to another sheet, because they need to be printed on the same page, unless there is a way to do that? Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/unhide with data below
On a second sheet, you could link to the cells that you want to print
from the first sheet. Then, print the second sheet. Rachael wrote: That is what I figured. The problem then lies in Printing. The data needs to be above, and the calculations below, all on one page when printed. Any other ideas? Is there a way to print more than one worksheet on one page, so if I moved the data to another sheet, print both sheets on one page? "Nick Hodge" wrote: Rachael You certainly cannot hide part of a column...all or nothing I am afraid... can you not duplicate the calculations below the other columns, calculations do not need to be below their columns -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Rachael" wrote in message ... I have a spreadsheet set up something like this A B C D E 1 data 2 data 3 totals 4 5 calculations for totals 6 more calculations Sorry...very rough. I have data in columns A to BZ that are totaled in row 49. From row 53 and below, columns A to F, I have additional calculations based on the total sin row 49. Sometimes i do not use every column (data is calculated bi-weekly) and I hide the columns I have not used, since I have to print a report on one page. The problem is, I often do not use columns CDEF, but I can't hide them because of the data in the calculations below. Is there a way to hide the data above and not below? I cannot move the calculations to another sheet, because they need to be printed on the same page, unless there is a way to do that? Any ideas? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/unhide with data below
That is what someone else suggested on another board, but it would be too
time consuming to do that each time, since I can't set it up to link all the time, because only certain areas need to be printed each time. If I have it set up to link all the time, then I have the same problem. Besides, even if the data is entered, all the unused columns are hidden, if I copy and paste the data to another sheet with the calculations on it, it will copy the hidden columns as well. I'm still open to suggestions! "Debra Dalgleish" wrote: On a second sheet, you could link to the cells that you want to print from the first sheet. Then, print the second sheet. Rachael wrote: That is what I figured. The problem then lies in Printing. The data needs to be above, and the calculations below, all on one page when printed. Any other ideas? Is there a way to print more than one worksheet on one page, so if I moved the data to another sheet, print both sheets on one page? "Nick Hodge" wrote: Rachael You certainly cannot hide part of a column...all or nothing I am afraid... can you not duplicate the calculations below the other columns, calculations do not need to be below their columns -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Rachael" wrote in message ... I have a spreadsheet set up something like this A B C D E 1 data 2 data 3 totals 4 5 calculations for totals 6 more calculations Sorry...very rough. I have data in columns A to BZ that are totaled in row 49. From row 53 and below, columns A to F, I have additional calculations based on the total sin row 49. Sometimes i do not use every column (data is calculated bi-weekly) and I hide the columns I have not used, since I have to print a report on one page. The problem is, I often do not use columns CDEF, but I can't hide them because of the data in the calculations below. Is there a way to hide the data above and not below? I cannot move the calculations to another sheet, because they need to be printed on the same page, unless there is a way to do that? Any ideas? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |