« Find SomeOne in SomeThing (excel tip) | Shortcuts Used in Formulas » |
Centre Across Selection (Alignment)
Excel TipsHi there,
This post explains the usage on title of the post. If you know where is this available in excel try doing it by yourself about this feature and post it before proceeding this post. If you are seeing it for the first time or you are not using this feature or you want to learn about this feature, just cotinue with me.
This feature is available in "Format Cells" option. To get Format Cells, use CTRL + 1, the keyboard shortcut -->goto Alignment Tab --> under Text Alignment -->Horizontal --> select the option "Centre Across Selection".
To use this feature you need to select the multiple rows with data in one cell, so that the data is aligned centre among the selection.
...
that's it. magic works!!!'
In interest of our viewers, I am adding the video explaining this tip.
DID YOU USE "CENTRE ACROSS SELECTION"?
If you are using this feature for different purpose, please do share it with us using below comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to support me for maintaining this blog, REGISTER here for free.
SOME IMPORTANT LINKS:
3 Simple and Powerful Shortcuts
Special Symbols on the Keyboard
Camera Tool Has a Shortcut Key
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments