Select edit
insert fill series ( step 1 ) option
On Sun, Feb 1, 2009 at 5:21 AM, yorkeyite wrote:
>
> Ctrl +D try this site
>
> http://www.asap-utilities.com/excel-tips-shortcuts.php
> Y
> On Feb 1, 4:26 pm, Ajay Kumar wrote:
> > The fill handle is very helpful for filling cells with various v
HiI hv a xl sheet whre i want to copy one of the column which contains both
blank & non blank cells). but I want copying only non blank cells(cells
having data) from that column. Could somebody help me in writing a macro for
this.
Regards
Debasish Sahu
Assistant Manager - Geology
ACC Ltd.
Thane -
You can use this tip
While keeping the "ALT" key pressed, press the down arrow key which will
display the list of values. You can select the value using the down or up
keys.
On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote:
>
>
> The fill handle is very helpful for filling cells with various va
ALT + E + I + S
On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote:
>
>
> The fill handle is very helpful for filling cells with various values.
> However, I much prefer to use the keyboard in preference to the mouse. Is it
> possible to utilize the fill handle in some way only by using the keyboa
Ctrl +D try this site
http://www.asap-utilities.com/excel-tips-shortcuts.php
Y
On Feb 1, 4:26 pm, Ajay Kumar wrote:
> The fill handle is very helpful for filling cells with various values.
> However, I much prefer to use the keyboard in preference to the mouse. Is it
> possible to utilize the fi
put now() and in other cell input the number of hours in the same format and
then add the two cells.
On Fri, Jan 30, 2009 at 8:38 AM, Muthu wrote:
>
>
> I will explain my problem with an example.
>
> 30/01/2009 13:30 is the time.I want to add 36 hrs to it.
>
> But I should add it only during the
