| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I repeat row heights in the same sheet
I have made a calendar and now due to some setting I need to play around with
the heights of the rows. Once I have done this for the first month I would like to use a function where I can repeat the row heights for the next 11 months - Can anyone help me |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I repeat row heights in the same sheet
If you select the row you want to repeat and then go to format/row/height,
then you can see what height that one row is. Get out of that and then select your 12 (or 11, whichever you prefer) rows and then go back to format/row/height and enter the number. I don't know of a function that would let you do that automatically, unless you wrote some VBA code. If that is what you want to do, you should be able to record a macro to see the code it generates. "Khalil" wrote: I have made a calendar and now due to some setting I need to play around with the heights of the rows. Once I have done this for the first month I would like to use a function where I can repeat the row heights for the next 11 months - Can anyone help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter rows to repeat on sheet tab? | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Hybrid Mode
