On 9/11/2018 7:09 PM, Brian Barker wrote:
At 15:32 11/09/2018 -0400, Vince Bonly wrote:
I have a Calc sheet in which unwanted background fill color is
displayed. The range begins B1307 and C1307 and seems to go the end
(wherever that is). Can anyone suggest an easier method than using
the mouse to scroll to the "end" starting from B1307:C????? Is there
an specific keystroke to jump to the end of a selected column?
At 15:41 11/09/2018 -0400, Vince Bonly wrote:
I have data within the above cells in which the background color is
desired. Is there a jump-to keystroke that gets me to the very last row?
Three techniques:
1.
o Highlight B1307.
o Press Ctrl+Shift+End.
This will select the region from B1307 to the bottom right *occupied*
cell of your sheet. If that selects only columns B and C you can now
remove the background. If there is material in later columns, hold
down Shift and press left-arrow repeatedly to reduce the selection to
columns B and C. Now remove the background.
*But*, you will scream, that doesn't get to the bottom, only to the
lowest used part of the sheet. But that doesn't matter, as when you
print the material nothing below that last used part will print
(unless you have perversely set a print range to make it print). So
the remaining cells with background are no problem.
2.
Alternatively, in the Name Box (to the left of the Input Line), enter:
B1307:C1048576
and press Enter. You now have the required range selected. Remove the
background.
3.
Depending on what backgrounds you have in earlier rows that you do
want, it might be easier to remove the background from the whole of
columns B and C and reset it in those cells or ranges where you
require it.
I trust this helps.
Brian Barker
Thank you, Brian.
Method 1. indeed did not get to the bottom.
Method 2. Worked splendidly !
Method 3. Was obvious to me, but I wanted to avoid resetting the
filled-in cells above the target range of cells.
Regards.
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
