Excel has a Set Print Area shortcut button - Does Libre Calc have one?
You can defne one via Tools > Customise > Keyboard: Category Format, function Print Area.
Edit1 regarding the comments below:
Quoting @Nai: "Could you please advise where the clickable toolbar element for Set Print Area is "
I didn’t say there was one - and I don’t know a predefined position.
But you can add a (predefined) function associated with a clickable icon to any toolbar you want.
In this case a reasonable choice should be the ‘Standard’ toolbar where already are some print-related functions.
Tools > Customise > Toolbars
right side: LibreOffice Calc, Standard
left side: Category Format, function Print Area
Insert with the right pointing arrow in the middle
Guide the newly inserted function down with the arrow at the right as far as needed. (Between ‘Print’ and ‘Print Preview’ e.g.)
OK
Read, learn, and experiment a bit about the general handling of LibreOffice.
I would prefer to design sheets including well considered settings concerning the print range(s). The above discussed function is inapt with this respect. See submenu items under Format > Print Ranges. Very useful!
Often needed - e.g. - the features Rows to Repeat and Columns to Repeat.
There are relevant features you cannot sufficiently control by a click here and anotherone there.
That does not create a custom button the same as Excel has,'It needs a button that can go on the toolbar like any of the other buttons so that you highlight the area that you want to print and then hit the Set Print Area button and it is locked in.
You asked for a shortcut. That’s not the same as a clickable toolbar element (icon or text).
By the way: For what good??
You might be better off with ‘Print’ and then ‘Selected Cells’ (meant: a cellrange) for a quick partial printout. This wouldn’t destroy your well considered managemnt of the print areas in general.
Yes - a clickable toolbar element icon is what I was looking for.
It is much easier to highlight the selected area to print, then hit the toolbar icon and then you can do a print preview and make sure that the margins are correct. This is on the basis that you are printing all or part of the worksheet.
Could you please advise where the clickable toolbar element for Set Print Area is
Thank you
Thank you - the detail given above re defining the function is what I needed. I now have the Set Print Area function on the toolbar.
The paragraph about “well considered settings” in my answer was a pleading against clickerism.
If I exceptionally want a print of a selected range, I use ‘Print’ and the choose ‘Selected Cells’. That’s one click (or Ctrl+C) in addition and does not destroy the print-range settings I previously made consciously.
The ‘Define Print Area’ clicked does.
OK I found it - it is called Define Print Area. All I have to do is work out to rearrange the buttons on the task bar