Ask Your Question

Is text alignment like 'Center across selection (of MS Excel)' available in LO Calc?

asked 2018-11-28 17:06:02 +0100

lonk gravatar image

It is very useful for dragging mouse or down arrow key in order to cover cells vertically in creating formula.

edit retag flag offensive close merge delete


When you refer to a function in a different application, please always provide a link to that application's function reference, so that other could get an idea (or reproduce if they have access to that software) what you mean, even not being familiar to the function.

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-29 10:11:57 +0100 )edit

3 Answers

Sort by » oldest newest most voted

answered 2018-11-29 09:59:35 +0100

maurice1 gravatar image

You can centre text by Ctrl + E, or used the button on the toolbar

edit flag offensive delete link more


Yep, but what "across the selection" means? Does it involve several cells? Vertically, horizontally, or rectangular area? See @Mike Kaganski's comment.

ajlittoz gravatar imageajlittoz ( 2018-11-29 10:15:17 +0100 )edit

answered 2018-11-29 11:24:34 +0100

lonk gravatar image

The function works like this :

edit flag offensive delete link more

answered 2018-11-29 12:26:43 +0100

ajlittoz gravatar image

It works nearly the same as in M$ XL, though commands are not located in the same places.

  • Enter your title in the leftmost cell
  • Extend the selection to the right for the required number of columns
  • Format>Merge cells>Merge cells & center

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

edit flag offensive delete link more


Hmm, the "Merge and center" it the thing with which the "Center across selection" is directly compared in the video, and its differences and advantages are discussed...

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-29 12:40:30 +0100 )edit

I saw that, but I chose to leave OP decide which way to go

ajlittoz gravatar imageajlittoz ( 2018-11-29 13:27:12 +0100 )edit

Thank you, it is very important for the accountant to create the report as well.

lonk gravatar imagelonk ( 2018-11-30 14:48:28 +0100 )edit

Looking forward to seeing in the next version

lonk gravatar imagelonk ( 2019-04-25 08:17:25 +0100 )edit

What made you think it would be in the next version? no developer was interested in this AFAIK.

Mike Kaganski gravatar imageMike Kaganski ( 2019-04-25 08:55:34 +0100 )edit
Login/Signup to Answer

Question Tools


Asked: 2018-11-28 17:06:02 +0100

Seen: 211 times

Last updated: Nov 29 '18