ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how can i group coloum (https://www.excelbanter.com/new-users-excel/265032-how-can-i-group-coloum.html)

yaseen

how can i group coloum
 
how can i group coloum in Excel.

Ms-Exl-Learner

how can i group coloum
 
To Hide Columns:-

Select the Columns

Using Menu:-
FormatColumnsHide.

Using Keyboard Shortcut:-
Cntrl+0

Using Shortcut Menu:-
Do Right ClickSelect Hide.



To Unhide Columns:-

Select the Columns

Using Menu:-
FormatColumnsUnHide.

Using Shortcut:-
Cntrl+Shift+)

Using Shortcut Menu:-
Do Right ClickSelect Unhide.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"yaseen" wrote:

how can i group coloum in Excel.


Ms-Exl-Learner

how can i group coloum
 
Please ignore my previous post.

To Group Columns:-

Select the Columns

Using Menu:-
DataGroup & OutlineGroup.

Using Keyboard Shortcut:-
Alt+Shift+Right Arrow


To UnGroup Columns:-

Select the Columns

Using Menu:-
DataGroup & OutlineUn Group.

Using Shortcut:-
Alt+Shift+Left Arrow

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"yaseen" wrote:

how can i group coloum in Excel.



All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com