Hi I have a spreadsheet showing what events are happening on dates past and upcoming.
Is it possible to do a print keeping the heading but ignore certain lines between that and the next live entry?
HEADING
Jan 1st stuff (Ignore on print)
Feb 3rd stuff (Ignore on print)
Mar 30th Stuff (Print)
Hope that makes it clearer
[Solved] Hide rows when printing
-
- Posts: 2
- Joined: Wed Mar 13, 2024 3:20 pm
[Solved] Hide rows when printing
Last edited by robleyd on Fri Mar 15, 2024 1:55 pm, edited 2 times in total.
Apache Open Office 4.1.14
Re: Hiding lines when printing
The easiest solution is probably to hide the rows you don't want to print. Select some cells in the rows you want to hide then select the menu item Format -> Row -> Hide. When you want to unhide the rows, select cells on each side of the hidden rows and select Format -> Row -> Show.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
- MrProgrammer
- Moderator
- Posts: 4909
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Hiding lines when printing
If you have a column of dates, you could use Data → Filter → Standard Filter to only show rows with future dates. Before using any filter, it is best to use Data → Define Range to tell Calc what cells should be considered as a set of related data so the filter knows what rows in the set to display and, when you are done printing, which hidden rows to re-show. If you need any additional assistance attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach.phil.anthony wrote: ↑Wed Mar 13, 2024 4:18 pm Is it possible to do a print keeping the heading but ignore certain lines between that and the next live entry?
Ten concepts that every Calc user should know, especially 3. Dates in cells
If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
-
- Posts: 2
- Joined: Wed Mar 13, 2024 3:20 pm