Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
Is there a way to insert and print horizontal lines every nth (5th or 10th,
for example) row to use simply as a guide to reading across a long row of data? I don't want grid lines, where every row appears underlined. I would like the lines to stay put when I insert rows, to automatically maintain every nth row. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
You can use Conditional formatting for this.
Select your range of data to apply the formatting to From the Format Menu, select "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =MOD(ROW(),5)=0 Select your format (shading, borders, etc...) Click OK This will apply the formatting to every 5th row. Change the 5 to 10 or whatever your needs are. HTH, Elkar "Mike F" wrote: Is there a way to insert and print horizontal lines every nth (5th or 10th, for example) row to use simply as a guide to reading across a long row of data? I don't want grid lines, where every row appears underlined. I would like the lines to stay put when I insert rows, to automatically maintain every nth row. |
#3
|
|||
|
|||
Quote:
You can format the lines on the first n lines then select these cells and copy. Select the rest of your data then paste special format. I personally like to shade every other line light blue. You choose what is easiest for yourself and your readers. Some printers do better than others with background colors, you might want to consider whether they will be viewing the file or a printed version. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
Thank you. Works perfectly.
"Elkar" wrote: You can use Conditional formatting for this. Select your range of data to apply the formatting to From the Format Menu, select "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =MOD(ROW(),5)=0 Select your format (shading, borders, etc...) Click OK This will apply the formatting to every 5th row. Change the 5 to 10 or whatever your needs are. HTH, Elkar "Mike F" wrote: Is there a way to insert and print horizontal lines every nth (5th or 10th, for example) row to use simply as a guide to reading across a long row of data? I don't want grid lines, where every row appears underlined. I would like the lines to stay put when I insert rows, to automatically maintain every nth row. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grid Lines
Is there a way to insert and print horizontal lines every nth (5th or
10th, for example) row to use simply as a guide to reading across a long row of data? I don't want grid lines, where every row appears underlined. I would like the lines to stay put when I insert rows, to automatically maintain every nth row. One way is to use Format Conditional Formatting with a formula like =MOD(ROW(),5)=0 and a format that has a lower border. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 grid lines | Excel Discussion (Misc queries) | |||
Grid lines | Excel Discussion (Misc queries) | |||
Partial Grid Lines | Excel Discussion (Misc queries) | |||
printing grid lines | Excel Discussion (Misc queries) | |||
Bold Grid Lines | Excel Discussion (Misc queries) |