mbhir"
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled."
Sent: Thursday, February 26, 2015 12:48 AM
Subject: Re: [AI] MS Excel doubts
Hello Jayachandran,
Please try with following steps
1. Type Jan-2015 in cell A1
2. Select the cell
al Message -
> From: "Zujar Shabbir Kanchwala"
> To: "'AccessIndia: a list for discussing accessibility and issues
> concerningthe disabled.'"
> Sent: Wednesday, February 25, 2015 6:05 AM
> Subject: Re: [AI] MS Excel doubts
>
>
>> Sorry
; 9677294410
> - Original Message -
> From: "Zujar Shabbir Kanchwala"
> To:
> Sent: Tuesday, February 24, 2015 9:11 PM
> Subject: Re: [AI] MS Excel doubts
>
>
>> Hi Jayachandran,
>>
>> 1. Get list of worksheets in current workbook - CTRL+ALT
ry 25, 2015 11:46 AM
Subject: Re: [AI] MS Excel doubts
Dear Jayachandran,
Excel fascinates me and Zujar is an expert on it. Have learnt many
things from him.
Answer for query 3:
You type any date in any format you want and then to get following
dates in the following cells just press Control+C
Ignore my email, both of them have given better options!
On 2/25/15, Amar Jain wrote:
> Query no. 1, minor correction being control shift S as against alt..
>
> Query no. 3, are you talking about normal typing? In that case, it
> will be F2 for editing current cell, then press enter and edit the
Query no. 1, minor correction being control shift S as against alt..
Query no. 3, are you talking about normal typing? In that case, it
will be F2 for editing current cell, then press enter and edit the
next cell likewise. I don't remember, but I had used autofill to get
this done once.
--
Amar J
gt; From: "Zujar Shabbir Kanchwala"
> To:
> Sent: Tuesday, February 24, 2015 9:11 PM
> Subject: Re: [AI] MS Excel doubts
>
>
>> Hi Jayachandran,
>>
>> 1. Get list of worksheets in current workbook - CTRL+ALT+S
>>
>> 2. For copying formula:
>
ncerningthe disabled.'"
Sent: Wednesday, February 25, 2015 6:05 AM
Subject: Re: [AI] MS Excel doubts
Sorry Dear! It's CTRL+SHIFT+S that opens the "Move to Worksheet" dialog
box.
If you wanna switch to another sheet then select the desired sheet from
the
list and press EN
.
Best Regards,
Zujar.
-Original Message-
From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf
Of Jayachandran1977
Sent: 24 February 2015 09:47 PM
To: AccessIndia: a list for discussing accessibility and issuesconcerning
the disabled.
Subject: Re: [AI] MS Excel dou
9677294410
- Original Message -
From: "Zujar Shabbir Kanchwala"
To:
Sent: Tuesday, February 24, 2015 9:11 PM
Subject: Re: [AI] MS Excel doubts
Hi Jayachandran,
1. Get list of worksheets in current workbook - CTRL+ALT+S
2. For copying formula:
2.1. Place cursor in source
Hi Jayachandran,
1. Get list of worksheets in current workbook - CTRL+ALT+S
2. For copying formula:
2.1. Place cursor in source cell (cell containing formula)
2.2. Press CTRL+C to copy
2.3. Press CTRL+G to open GoTo dialog box
2.4. Specify target cell range (cells
11 matches
Mail list logo