Prev: Conditional
Next: Absoute Cell Ref Changes When Inserting New Row in Referenced Shee
From: Padre310 on 1 Apr 2010 13:27
I want to see only the first three columns and nothing else, no other columns.
From: Eduardo on 1 Apr 2010 13:36
Hi,
Select all the other columns, right click on the mouse, Hide

"Padre310" wrote:

> I want to see only the first three columns and nothing else, no other columns.
From: "David Biddulph" groups [at] on 1 Apr 2010 13:37
In Excel 2007, Hide Columns comes under "Hide & Unhide", from the Format
button in the Cells group on the Home tab.
In earlier versions, use the Format menu.
--
David Biddulph


"Padre310" <Padre310(a)discussions.microsoft.com> wrote in message
news:A3BC4333-5944-4124-8AEC-39D403F3EB4B(a)microsoft.com...
> I want to see only the first three columns and nothing else, no other
> columns.


From: Rick Rothstein on 1 Apr 2010 13:40
Type one of the following (as appropriate) into the Name Box (the empty
field to the left of the Formula Bar)...

For XL2003 or earlier ==> D:IV

For XL2007 or XL2010 ==> D:XFD

Then right-click anywhere within the now selected cells and click on Hide in
the popup menu that appears. You may have to use the horizontal scroll bar
to move Columns A thru C back into view afterwards.

--
Rick (MVP - Excel)



"Padre310" <Padre310(a)discussions.microsoft.com> wrote in message
news:A3BC4333-5944-4124-8AEC-39D403F3EB4B(a)microsoft.com...
> I want to see only the first three columns and nothing else, no other
> columns.

 | 
Pages: 1
Prev: Conditional
Next: Absoute Cell Ref Changes When Inserting New Row in Referenced Shee