(Msg. 2) Posted: Tue Nov 18, 2008 11:06 am
Post subject: RE: Show Formatting of Columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Since each cell can be formatted differently, it would depend.
But if you know the entire column has been formatted the same, click on the
column header and go to Format/Cells.
If anything but General is highlighted, that is the format of the column.
Then, you can change the formatting if you'd like from there...
"Daren" wrote:
> Hello,
>
> Is there a way to view formatting of columns in a quicker way then just
> going to individual cells and clicking on Format and then cell?
>
>
> Thanks
(Msg. 3) Posted: Tue Nov 18, 2008 11:13 am
Post subject: RE: Show Formatting of Columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
That does work. Is there a function that can show me the formats of the
columns without clicking on each one? Thanks!
"Sean Timmons" wrote:
> Since each cell can be formatted differently, it would depend.
>
> But if you know the entire column has been formatted the same, click on the
> column header and go to Format/Cells.
>
> If anything but General is highlighted, that is the format of the column.
>
> Then, you can change the formatting if you'd like from there...
>
> "Daren" wrote:
>
> > Hello,
> >
> > Is there a way to view formatting of columns in a quicker way then just
> > going to individual cells and clicking on Format and then cell?
> >
> >
> > Thanks
(Msg. 4) Posted: Tue Nov 18, 2008 7:59 pm
Post subject: Re: Show Formatting of Columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You can get some information from =CELL("format",A1)
--
David Biddulph
"Daren" <Daren.RemoveThis@discussions.microsoft.com> wrote in message
news:D8D67CC6-9543-497C-A736-13537B29D153@microsoft.com...
> That does work. Is there a function that can show me the formats of the
> columns without clicking on each one? Thanks!
>
> "Sean Timmons" wrote:
>
>> Since each cell can be formatted differently, it would depend.
>>
>> But if you know the entire column has been formatted the same, click on
>> the
>> column header and go to Format/Cells.
>>
>> If anything but General is highlighted, that is the format of the column.
>>
>> Then, you can change the formatting if you'd like from there...
>>
>> "Daren" wrote:
>>
>> > Hello,
>> >
>> > Is there a way to view formatting of columns in a quicker way then just
>> > going to individual cells and clicking on Format and then cell?
>> >
>> >
>> > Thanks
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office