Question about Corel WordPerfect Office X4 Home & Student Edition Full Version Academic License for PC

1 Answer

How can I use a relative address in the @find function? It changes to a fixed address when I stop editing.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 292 Answers

When you include addresses like A2, C10, F15 they are relative addresses .eg: If you have entries like:
in B4 you have saturday
in C6 you have the formula =FIND("a",B4) .....the answer is 2
B4 is a relative cell address, because if you copy the formula across the row, OR up/down the column, the formula changes and the answer changes
To make it an absolute address you have to type a $ in the cell address. If you type the cell address formula as $B4, it means wherever you move to or copy the formula the B will not change
If you type B$4 the row no 4 is ABSOLUTE or fixed.
$B$4, both column B and row 4 are fixed. If you move the formula anywhere the cell reference will not change.
Summary B4 is a relative cell address
$B4 is absolute address (B is fixed)
B$4 is absolute address (4 is fixed)
$B$4 is abso;lute address (Bis fixed, 4 is also fixed)
Hope this answers your question
luciana44

Posted on Sep 06, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do you change your email address on Yahoo?


The Yahoo account email address changed on the Yahoo account. But for this make sure that the Yahoo account signed in to the Yahoo ID in question.

May 07, 2017 | Computers & Internet

1 Answer

I need change my paypal account address and make sure they are using my debit card for my bill..


you first have to change the address at your bank acct. because your paypal address has to match your debit card address. after you change your address related to your bank acct. paypal should email you to notify you of the discrepancy, but if they don't you can log in to your acct and go to personal information and edit your address.

Dec 27, 2014 | PayPal Computers & Internet

1 Answer

Please edit my address to read wagstrickland@gmail.com


Can you be more specific? Do you want to change your gmail address from something else to this address, or are you simply trying to change the display of your address?

Feb 04, 2014 | Google Computers & Internet

1 Answer

Change address


Page Info. If you haven't already changed your URL, you'll see the Edit button when you hover the Facebook Web Address area. Clicking the Edit button will open a small window with a link to Change web address How to Change Your Facebook Page URL Username 2015

Jan 07, 2014 | Facebook Social Network

1 Answer

We have email addresses on the display unit that are no longer valid. How do you a) remove the old email addresses and b) add new email addresses.


Press User Function --> Address --> Address Book --> Select your contact --> Edit
Change the email address on the contact.

Mar 17, 2011 | Toshiba E-Studio 3511 Color Copier

1 Answer

Error in "go home" function. inputed correct


Try this see if it works....

Tools...My Data....Set Home Location

also

To change your Home location, touch Where To...Favorites...select Home from the list. Then touch Edit ....enter your changes , and touch Done

Oct 27, 2010 | Garmin nuvi 1300 Car GPS Receiver

1 Answer

How do I change my WD5000G032-001 external hard drive's IP address?


Very few external disk-drives _have_ an IP-address (the Apple Time-Machine is the exception). For those drives that do,
they obtain their IP-address automatically, by sending a 'request' out through their network-connection. A DHCP ('Dynamic Host Configuration Protocol') server on the network sends an IP-address to it. Most 'home' routers (wired or wireless) include the DHCP-server functionality.

So, the only way to change the IP-address is to configure the DHCP-server to always assign the desired IP-address whenever that specific device sends a 'request' for an IP-address.

Oct 06, 2010 | Western Digital 500GB My Book World...

1 Answer

Email settings


you must have email account, also the POP address, and the SMTP with your username and password ready

Set up email account
1. Select Menu > Messaging > Email > Settings > New account > Add.
2. Enter a name for the email account, for example, Home or Office. Select OK.
3. Select Connect using > Edit and select the data account you created earlier to use with this email
account.
4. Select Email address > Edit. Enter your email address. Select OK.
5. Select Connection type > Edit. Select POP3 or IMAP4. POP3 is the most common.
6. Select Incoming server > Edit. Enter the name or the IP address for the incoming server. Select OK.
7. Select Username > Edit. Enter the incoming server username. Select OK.
8. Select Password > Edit. Enter the incoming server password and select OK. Leave this blank if you
want to be asked for the password each time you check new mail.
9. Select Outgoing server > Edit. Enter the name or the IP address of the SMTP server you use to send
email messages. Select OK.
10. Select Advanced settings.
11. Select Your name (not mandatory) > Edit. Enter your name and select OK. This will appear in outgoing
email messages.
12. Select Signature (not mandatory) > Edit. Create a signature to add to your email messages and
select OK.
13. Select Download S&R. Choose what to download when receiving new email messages:
• Subjects only – receive information such as sender and subject before downloading the whole email.
• Up to size limit – receive the whole email. Select Size limit to set the maximum size to download
when receiving new email messages.
• Subjects & text – Only for IMAP4 users. Receive the subject and text but not attached files.
14. Select Check interval (not mandatory). Choose how often you want the phone to connect to your
email server and check for incoming email messages.
15. Select Push email. Only for IMAP4 users. Select On for full email notification functionality or Off to
disable the functionality. See Using push email for full email notification functionality on page 7.
16. Select Allow connection > Edit. Select Any network or Home network.
17. Select Copy outgoing (not mandatory) > Edit. Select On if you want email messages sent from your
phone to be sent to an additional email address of your choice. This way your sent messages are
copied and can be saved for future reference.
18. Select Encryption > Edit. Choose whether your email messages should be encrypted.
19. Select Outgoing. username. If requested, select Edit enter the outgoing server username.
20. Select Outgoing. password. If requested, select Edit enter the outgoing server password.
21. Select Incoming port. If needed, change the port for the protocol you are using.
22. Select Outgoing port. If needed, change the port for the SMTP protocol.

and the other is

To write and send an email message
1. Select Menu > Messaging > Email > Write new.
2. Select To: to add recipients and select Add. There are three ways to add an intro sentence:
• Select Enter email address. to enter an email address.
• Select Contacts look-up to retrieve a recipient from Contacts.
• Select an email address from the last used recipients.
3. To add more recipients, select To: > Edit select Cc or Bcc and select recipients to add. When finished
selecting recipients select Done.
4. Select Subject: to write the subject.
5. Select Text: to write the text.
6. Select Attachments: and select the attachment to add. Add more attachments the same way.
7. Select Continue.
8. Select Send to send the message or More to view options.
To receive and read email messages
1. Select Menu > Messaging > Email > Inbox.
• Select Send&rec when the inbox is empty or
• Select More > Send & receive to download new messages.
2. Select a message and select View to read it.
To reply to an email message
1. Select Menu > Messaging > Email > Inbox. Select an email message in the inbox. Select More
> Reply and select:
• Yes – to include the original message in your reply or
• No – to exclude the original message.
2. Write your message select OK > Continue.
3. Select Send to send the message or More to view option

Mar 08, 2010 | Sony Ericsson W350A Cell Phone

1 Answer

How do i change a preset destination


if it's not giving you an option to enter in the numbers for the address one of two things might be wrong. 1. the address is incorrect (probably not) 2. Assuming the address is correct, there is a good chance that the address is simply not in the map database. This can be caused because the location is relatively new. In this case, it's time to upgrade your maps.

Dec 10, 2008 | Tomtom ONE 3rd Edition GPS

1 Answer

I just created an e-mail address, but I would like to change the address by inserting 4 letters in the address


u cannot fix the problem,there is no option to edit ur e-mail address ,u can only edit your profile informations.

Aug 15, 2008 | Computers & Internet

Not finding what you are looking for?
Corel WordPerfect Office X4 Home & Student Edition Full Version  Academic License for PC  Logo

137 people viewed this question

Ask a Question

Usually answered in minutes!

Top Corel Computers & Internet Experts

kakima

Level 3 Expert

102366 Answers

photoshop serial

Level 2 Expert

11 Answers

Dan Shibata
Dan Shibata

Level 3 Expert

542 Answers

Are you a Corel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...