Home |
Search |
Today's Posts |
#1
|
|||
|
|||
spreadsheet gridlines as graph paper
what are the default settings for gridlines so every cell is exactly 5mm square
|
#2
|
|||
|
|||
AFAIK there is no such setting available. Default Row height is directly
determined by default font size and Column width is indirectly determined by default font size by way of "number of characters". You might be able to dictate the grid dimensions through VBA, but what kind orf meaningful content could a worksheet have if cells were that small? Regards |:) "lebrunn" wrote: what are the default settings for gridlines so every cell is exactly 5mm square |
#3
|
|||
|
|||
Maybe he just wants to create some graph paper. No contents needed in cells.
"CyberTaz" wrote in message ... AFAIK there is no such setting available. Default Row height is directly determined by default font size and Column width is indirectly determined by default font size by way of "number of characters". You might be able to dictate the grid dimensions through VBA, but what kind orf meaningful content could a worksheet have if cells were that small? Regards |:) "lebrunn" wrote: what are the default settings for gridlines so every cell is exactly 5mm square |
#4
|
|||
|
|||
Lebrunn, if you set row height to 18 and column width to 2.43, you will have
graph paper with 1/4" squares. Maybe you can start from there and adjust to get down to 5mm. HTH -- Sincerely, Michael Colvin "lebrunn" wrote: what are the default settings for gridlines so every cell is exactly 5mm square |
#5
|
|||
|
|||
Certainly possible, but the OP asked about changing the "Default", which to
me means every new sheet of every new workbook be generated with 5mm sq. cell dimensions. I think it would be more practical to just buy a ream of graph paper :) Regards |:) "Doug Kanter" wrote: Maybe he just wants to create some graph paper. No contents needed in cells. "CyberTaz" wrote in message ... AFAIK there is no such setting available. Default Row height is directly determined by default font size and Column width is indirectly determined by default font size by way of "number of characters". You might be able to dictate the grid dimensions through VBA, but what kind orf meaningful content could a worksheet have if cells were that small? Regards |:) "lebrunn" wrote: what are the default settings for gridlines so every cell is exactly 5mm square |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gridlines into excel spreadsheet after changing background color | Excel Worksheet Functions | |||
Sort order for graph only and not spreadsheet | Excel Discussion (Misc queries) | |||
printing a graph chart on A4 paper | Charts and Charting in Excel | |||
why do my spreadsheet gridlines only prints half way on the page?. | Excel Worksheet Functions | |||
How can I print a spreadsheet on 11x17 paper in Excel2000. | Excel Discussion (Misc queries) |