Hi Zujar Select the entire column by shift + End key and press application key then go to hide option and press enter key. Hope it will help.
On 11/19/10, Zujar Shabbir Kanchwala <[email protected]> wrote: > The following classic method should work for you: > > Press CTRL+G to open GoTo dialog box. Specify the column(s) to be > hidden as below: > > a1:b65536 > > You need to specify the row numbers as 1 and 65536 in start and end > cell address respectively in order to select the entire column. > Press ALT+O followed by C and H. > > I consider this as classic method as this method was used in Excel > 2003 and prior versions. The following is how you can hide column(s) > in Excel 2007: > > Place the cursor in the column to hide. > Press ALT followed by H, O to open Format menu. > Move down to the option named 'Hide/Unhide submenu' or press U. > Press C or select 'Hide Columns' from the submenu. > > hth... > > On 11/19/10, Hozefa Tambawala <[email protected]> wrote: >> Dear friends, >> >> I want to hide some collumns in Excel 2007. How can I do this? I >> search in all tabs but fale to locate any option pertaining to this >> subject. I also tried to find option by pressing Application key, but >> no success. >> >> Warm Regards, >> Have a nice day >> >> Hozefa... >> >> To unsubscribe send a message to [email protected] >> with >> the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> > > > -- > Best Regards, > Zujar... > > An optimist laughs to forget, whereas a pessimist forgets to laugh! > > To unsubscribe send a message to [email protected] with > the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > -- Thanks & Regards Mohammed Tausif Iqbal Advisory Associate Pricewaterhouse Coopers Service Delivery Centre Mobile: 00919836218347 Skype:tausif.iqbal Email:[email protected] To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
