exceltoxl.com

Hi 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:

Switch between the sheets

CTRL + ENTER

Shortcut Key to NameBox

3 Simple and Powerful Shortcuts

Special Symbols on the Keyboard

Camera Tool Has a Shortcut Key

Thanks,