Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default how can i group coloum

how can i group coloum in Excel.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 506
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 506
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in a coloum franco monte New Users to Excel 8 March 7th 10 07:25 PM
How to count a coloum if two conditions are met Mr Fujisawa Excel Worksheet Functions 5 March 1st 10 02:17 PM
Delete coloum in VB haviv Excel Discussion (Misc queries) 3 September 12th 08 09:29 AM
how to change coloum to row sangeet Excel Worksheet Functions 5 June 4th 07 04:13 PM
Regonise coloum A while adding up coloum B to give a result in C B.H.JIG Excel Discussion (Misc queries) 3 May 3rd 07 01:25 PM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"