OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   New Users (http://www.officefrustration.com/forumdisplay.php?f=7)
-   -   how can i group coloum (http://www.officefrustration.com/showthread.php?t=1118844)

yaseen June 2nd, 2010 06:55 AM

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

Ms-Exl-Learner June 2nd, 2010 07:56 AM

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 June 2nd, 2010 08:02 AM

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 02:41 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com