Prev: CURSOR SHAPE HAS CHANGED
Next: Excel properties that update when Excel is accessed without saving
From: Shrikant on 6 Mar 2010 01:01
I am using Excel 2007
In earlier version of Excel, I used to utilise a special function (with icon
of Camera ?) to copy the contents of a range of cells alongwith the formating
to another place in the worksheet, in a sort of 'picture' or 'mirror' so that
the column alignment is for columns above the range copied is NOT done. This
has a special advantage in a complex Form.
Otherwise, when I split a range of cell columns, unfortunately the whole of
the column from top of the workshee to the bootom gets split, thereby
disfiguring the other portion of the form.
How to do this in the Excel 2007 ?
--
Shrikant
From: Roger Govier on 6 Mar 2010 04:32
Hi

Click the small down arrow at the right of the QAT>more Commands>select
All commands from the dropdown>Scroll down to Camera>click the Add button>OK

The camera will work the same as in XL2003
--
Regards
Roger Govier

Shrikant wrote:
> I am using Excel 2007
> In earlier version of Excel, I used to utilise a special function (with icon
> of Camera ?) to copy the contents of a range of cells alongwith the formating
> to another place in the worksheet, in a sort of 'picture' or 'mirror' so that
> the column alignment is for columns above the range copied is NOT done. This
> has a special advantage in a complex Form.
> Otherwise, when I split a range of cell columns, unfortunately the whole of
> the column from top of the workshee to the bootom gets split, thereby
> disfiguring the other portion of the form.
> How to do this in the Excel 2007 ?
 | 
Pages: 1
Prev: CURSOR SHAPE HAS CHANGED
Next: Excel properties that update when Excel is accessed without saving