Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create formula showing row height in a cell
In a large spreadsheet, I want to be able to quickly see the row height of
each row. My report calls for three possible heights depending on the purpose of that row. How can I create a formula that will show the height of each row? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create formula showing row height in a cell
Create a name, like RowH, and, assuming A1 is active when you define the
name, define it as =Get.Cell(17,Sheet1!a1) (keep the reference relative (no "$") Now, enter =RowH in a cell and the rowheight will be given. If the row height changes, you will have to manually recalculate via ctrl/alt/F9. Bob Umlas Excel MVP "Greg1094" wrote in message ... In a large spreadsheet, I want to be able to quickly see the row height of each row. My report calls for three possible heights depending on the purpose of that row. How can I create a formula that will show the height of each row? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create formula showing row height in a cell
This works perfectly. Thank you very much.
"Bob Umlas" wrote: Create a name, like RowH, and, assuming A1 is active when you define the name, define it as =Get.Cell(17,Sheet1!a1) (keep the reference relative (no "$") Now, enter =RowH in a cell and the rowheight will be given. If the row height changes, you will have to manually recalculate via ctrl/alt/F9. Bob Umlas Excel MVP "Greg1094" wrote in message ... In a large spreadsheet, I want to be able to quickly see the row height of each row. My report calls for three possible heights depending on the purpose of that row. How can I create a formula that will show the height of each row? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
create formula showing row height in a cell
"Greg1094" wrote: In a large spreadsheet, I want to be able to quickly see the row height of each row. My report calls for three possible heights depending on the purpose of that row. How can I create a formula that will show the height of each row? Alternativley, use a custom function Function CellHeight(Optional cell) If IsMissing(cell) Then CellHeight = ActiveCell.RowHeight Else CellHeight = cell.RowHeight End If End Function CellHeight() returns the height of the active cell and CellHeight(G17) returns the height of row 17. Function to be copied into a Worksheet module (Alt + F11, Insert Module) To use it in more workbooks copy it into Your Personal Workbook. Regards Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |