Return to next row in first column when entering data in Excel
I am creating a list that that uses more columns than can be covered on the
screen. The problem is when the data is entered in the cell in the last
column, I need to return to the next row in the first column. Yet this cell
and row is not visible to click onto. Is there a command like in Acess that
will take me to the end of my list, ready to start another row of data. if
not, are there any suggestions to accomplish this?
Try this. When you enter data in a cell use TAB to go to the next cell and
when you get to the last cell in that row, enter your data and then hit
...Service Version Error
In loading old .pst file to my current outlook, It stopped with one error
message as follows:
"The version of d:\outlook\bakcup\old_recieved_mailbox.pst is different from
that of the Personal folder information service. Call Administrator "
- this msg is translated from korean to english version....
Whoever know the cause of this outlook processing.
Thanks & Regards.
PS: Thank you if someone send the exact answer to my mail,
...How do a set the default to move the cursor to the next column in.
How do a set the default to move the cursor to the next column instead of
down to the next row?
Tools/Options/Edit. Change the Direction dropdown to Right.
In article <84AE61DF-500F-4A23-B9BA-217CA7F0C607@microsoft.com>,
> How do a set the default to move the cursor to the next column instead of
> down to the next row?
You'll find this under Tools>Options>Edit>Move Selection after Enter
<firstname.lastname@example.org@discussions.micros...Next/Previous items buttons
Can you add buttons which will allow users to move to the next or previous
item in a list or view so they don't have to always save and close, just
save, press the next button and carry on without having to figure out which
item is next (sometimes the current item in a list/search does not stay
hilighted and if you have to look through several to find the one you last
worked on, that's a pain.).
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree&qu...Exit For statement in nested For ... Next blocks
I have the block of code below in a Sub that tidies up a copied workshee=
by removing unused rows. It=E2=80=99s contained in a With =E2=80=A6 End =
With block that =
refers to the copied sheet. I=E2=80=99d like to know how the Exit For st=
atement is =
handled if it=E2=80=99s in a For ... Next block that is nested within an=
other For =
=E2=80=A6 Next block. I.e. will it cause the code to exit only the inner=
For =E2=80=A6 =
Next block and proceed with the
If VacRowClear =3D True Then
statement, or will it exit the outer For =E2=80=A6 Next block?
I use...OS version 10.2
In a previous post, I was told that Office 98 for MAC will not work on OS
10.2 and was directed toward getting Office 2004. In the system requirements
for 2004, it says that it is for users who have 10.2.8 or later. Is OS 10.2
upgradable to 10.2.8 or do I need to go with Office X or 2001 for OS 10.2?
Verdone Landscape Architects, Inc.
Heath Kuszak <email@example.com> wrote:
> In a previous post, I was told that Office 98 for MAC will not work on OS
> 10.2 and was directed toward getting Office 2004. In the system requirements
> for 2004, ...HELP!! Publisher wont open file from previous version
I am using Windows 2000 (professional) and running Microsoft Publisher 2000.
A colleague who uses Microsoft Publisher 2003 downsaved a file she had
created to a Microsoft 2000 Publisher file and emailed it to me.
When I try to open it, I still get the error message 'Publisher wont open
file from previous version'.
Are either of you using Norton Anti-virus?
MVP Microsoft [Publisher]
"Working with publisher!!!!!!!!!!!!!!!!!!" <Working with
firstname.lastname@example.org> wrote in message
news:91EE9633-B3C0-4A...CRM Trial Version
Hi Every one
I had installed CRM 3.0 (Trail Version) but for some reason I uninstalled
CRM 3.0. Now I want to installed it again, but when I am trying to enter
the trial keys, CRM says that your CRM trial version is expired now.
How can I reinstall CRM 3.0 trial version?
...How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
How to place a secondary y axis bar in a bar chart next to, not over, two
primary y axis bars?
Have a look at Jon Peltier's page.
> Hello specialists!
> How to place a secondary y axis bar in a bar chart next to, not over, two
> primary y axis bars?
> Best regards,
Andy Pope, Microsoft MVP - Excel
Is this what you want?
...next data record positioning
I am trying to change where the next record is displayed on a report. For
example, if you had a list of months, it will display as follows:
How do I change the next record to flow to the right verses down? Example:
Jan Feb Mar
This looks like a crosstab report based on a crosstab query.
These will work best if you give your months a number (Use Month(YourDate)
and put that as the Column Header. (Your labels can say Jan, Feb etc)
In the Query's design view, click below the white grid, click on Properties
and next to Column Headings type
1,2,3,4,5,6,7,8,9,10,11,...OWA version and license
I am looking to implement OWA and am not sure of the correct route to take.
Exchange 2003 Standard? Exchange 2003 Enterprise? We currently have an
Exchange 2003 Enterprise server for our internal email.
Do I just need a single Server license, since OWA connects as annonymous?
Thanks in advance!
Use Exchange Standard for OWA on your frontend servers. No need to pay for
Enterprise. This will be a separate license from your existing box. If you
are really tight on the budget you could directly connect to OWA on your
backend server. Although this is not recommended.
"Darren" <...multilevel list
I have used multilevel lists before without a problem in Word 2007 but when
I tried to use it today it gave me some issues. I am able to insert the
first bullet of a multilevel list, then i type a line of text, press enter to
advance to the next line and then push tab to advance to a new bullet at an
indented position. However, when I push the tab button all that it does is
indent where my text will begin and the bullet remains the same as the one
above and is not indented at all. I've tried bullet multilevel lists and
numbered lists without any success. Thank y...Dell OEM Version
My new Dell has MS Money 2004 on it. What commercial
version does this correspond to? It says "standard" but
it has Investment & Portfolio capabilities.
it is probably standard...dell would not install higher.
search for money 2004
>My new Dell has MS Money 2004 on it. What commercial
>version does this correspond to? It says "standard" but
>it has Investmen...MSO Project 2007 Prof. Trial version
I downloaded & installed the MSO Project 2007 Professional Trial Version. I
input some fields and then wanted to save but it won't let me. The FILE,
SAVE and FILE, SAVE AS are both grayed out. How do I save my project?
Please reply to email@example.com
Have you "activated" the trial?
On 28/04/10 20:26, Susan wrote:
> I downloaded& installed the MSO Project 2007 Professional Trial Version. I
> input some fields and then wanted to save but it won't let me. The FILE,
> SAVE and FILE, SAVE AS are both...Recovering last saved version?
I accidentally "saved" instead of "save as" after I made
major modifications to a huge file.
Any way to recover the last saved version (before this
if you haven't created a backup- no chance
> I accidentally "saved" instead of "save as" after I made
> major modifications to a huge file.
> Any way to recover the last saved version (before this
...MT2OFX Version 3.2 Released
MT2OFX is a free utility program for translating bank statement
information in any text/CSV format to QIF or OFX for use with MS Money
or many other personal finance programs.
This version adds:
* the ability to read OFC files as input, allowing use of OFC-format
downloads with Money 2005
* the ability to read QIF files as input, making it possible to
translate QIF to OFX or QIF to QIF, all fully scriptable as usual;
* transaction splits to the data model to help with QIF processing
* ability to output to a temporary file which is deleted after the
import has been run
* ability to take tex...Excel 2003 security to previous versions
What I am trying to do is the following:
I have put security by the standaard of excel on several selections with a
pass and selected users of the AD.
In Excel 2003 it works fine the security on selections and on the page.
But I have several Office 2000 users who also needs to work in that same
excel sheet. There it just simply says it is locked/secured and you need to
fill in the password for the whole sheet.
In 2003 you give the password of the selection and you can only edit that
In 2000 if you give the same password for the selection it says it doesn't
recogn...Why not build-in a based subscription in the next generation os?
The main point:
Does it possible if we build in a basic functionality in the operation
system (view it as ppd lic), something like powershell, that means, end users
who got a genuine lic would get a long-time trial (e.g. 1 yr, it's free in
the trial, and it is open for them to give suggestions or feedbacks in the
trial). 1 year later, consumers could have two choices:
1. they are very satisfied with trial and wanna buy genuine software
2. they wanna continue to use the software but in a full-subscription mode
3. they wanna use the software in a specific way - continue to use
...Drop Ship needs to be active as it was in previous versions
The drop Ship miodule is innactive in the current version of GP and appears
not to be included in 9.0 version. In previous versions, this module was
available. I can't believe that no-one requests that this product be still
available. We do over $ 20 million of business that would have the
administrative process lightened by activating this feature.
Will this feature be available again, we were sold on this feature's
advantages and applicability, only to find that it is now gone!!!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestion...Paying upgrade price instead of Full version price...
Is there such of thing as an upgraded version that you can
buy intead of having to get a whole package when you
already own last year's?
Thanks a lot!
...Vista Version, Exchange & Outlook
What version of Vista do I require in order to be able to connect to
Exchange server via Outlook 2003?
I recently purchased a laptop that came with Vista Home Premium
and I am wondering whether I need to upgrade to the Ultimate edition.
domain access necessary to connect via Outlook?
When I set up the mail profile, it finds the mail server and user name
underlines them. When I try to start Outlook, it asks me for my
username and password, then stops responding completely. Everything is
You should be able to connect to either ...Enter key will no longer return to begining of next row
From one worksheet to the next, the enter key will only
activate the cell directly below the current cell. What
Have I done to change the direction? Have checked the
direction selection in Options and as suggested by MS Help
made sure the Down was selected. Doesn't change a thing.
look in Tools | Options | and on the Edit tab check what's in "Move
selection after Enter"
"Sandy" <firstname.lastname@example.org> wrote in message
> From one worksheet to the next, the ent...How to move to next cell by entering data-not using Enter key.
I have posted this as a new user but hought I may get a better repons
here.I am using ms excel to enter data, 1 for Yes and 2 for No, for 30
items/questions listed successively in column A. The data is the
tallied on another excel page. However, I would like to have the entr
of 1 or 2 provide the jump to the next cell down ( each time1 or 2 i
entered) rather than have to always press enter key to go to the nex
cell. Any ideas how to proceed
johnexcel's Profile: http://www.excelforum.com/member.php?action=...Older version incompatability
I work for the Univ of DE 4-H office and have been upgraded to Publisher 2003 (using XP professional). My 4-H staff has older version of Publisher, 2000 to be specific. They can not open anything I have created in Publisher 2003, and believe me I have tried saving documents in all older versions. Nothing works. Earlier in the year Brian, an MVP had to save a brochure for me so I could send it off to those with older versions. Nothing I did could get it to open in earlier version...he asked that I send it to him and he sent it back an hour or so later and everyone could then view it. Is there s...V3c desktop version won't load
I'm having trouble with the v3c (desktop version; Office 2007 on Windows XP
sp2 with IE7). The installation went fine, but when I start Outlook I get
"Your Web browser options are currently set to disable cookies. Microsoft
CRM requires cookies to use the Web client. To enable cookies, see the
online Help for your browser."
My CRM web access is fine. No amount of monkeying with IE settings has made
any difference. I've disabled a/v and firewall, still the same error.
This is a multi-part message in MIME form...