Forum Discussion
print first row and other non-consecutive rows
I have a spreadsheet with information on types of plant seeds. Information in row 1 of all columns are standard gardening questions, like "When to plant or transplant?"; "Depth to plant"; "How much s...
The rows to be printed will have to be together, without gaps in between.
There are several ways to do this:
- Copy the rows you want to print to another worksheet, and print that sheet.
- Manually hide the rows that you don't want to print.
- Add a column in which you enter an x or 1 in the rows that you want to print. You can then filter the data on that column; this will hide all other rows. You can exclude this column from the Print Area.
The rows to be printed will have to be together, without gaps in between.
There are several ways to do this:
- Copy the rows you want to print to another worksheet, and print that sheet.
- Manually hide the rows that you don't want to print.
- Add a column in which you enter an x or 1 in the rows that you want to print. You can then filter the data on that column; this will hide all other rows. You can exclude this column from the Print Area.
- Thank you SOOO much! I wish I'd know this much sooner!
