Home |
Search |
Today's Posts |
#1
|
|||
|
|||
suppress printing a repeating value in a column
In an Excel worksheet, how do you suppress printing a repeating value. For
example, one hundred rows have the same date and I want the date value to print on a break only. |
#2
|
|||
|
|||
Excel really isn't made to easily work with page breaks. Page breaks depend on
the printer (which depends on what the user chooses). It can get pretty messy pretty fast. If you're willing to just show the first value and hide the duplicates (no matter where they occur, you could use conditional formatting--like Debra Dalgleish shows at: http://contextures.com/xlCondFormat03.html#Duplicate I've seen users who use a separate column (and hide the original column) so that they could show ditto marks. Say column A contains your dates. Insert a new column B and use a formula like this in B2 (headers in B1): =if(a2=a1,"""",a2) and drag down (and hide column A) ======= Personally, I like to show the information on each line. I find it easier, er, less work. Suppress printing repeating values wrote: In an Excel worksheet, how do you suppress printing a repeating value. For example, one hundred rows have the same date and I want the date value to print on a break only. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Printing after using column auto fit - not working | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |