Solved

needing instructions for centering data within A1 and B1 cells of spreadsheet

Posted on 2003-11-15
12
566 Views
Last Modified: 2010-04-26
Hi Everyone:

       I am in the process of creating a checklist using the spreadsheet utility built into Microsoft Works 7.0.  At this point, I am needing to know how to center some information which was typed into A1 and carries over into B1 cell.  

       Any information on solving this concern will be appreciated.  I look forward to reading everyone's thoughts on this one.  

       Thank you.

       George
0
Comment
Question by:GMartin
  • 4
  • 4
  • 2
  • +1
12 Comments
 
LVL 44

Expert Comment

by:CrazyOne
ID: 9757293
Hi George I don't think most of use you use Microsoft Works instead we use Microsoft Office.
0
 
LVL 18

Accepted Solution

by:
chicagoan earned 300 total points
ID: 9757449
In excel you would highlight the adjoing cells right click - format - merge and center...

don't know if your version supports these features, might be better asked in the 'apps' topic area

A work around might be to put the half the text in each of the adjoining cells, right justifying A1 and left justifying B1

'your mileage may vary'
0
 
LVL 4

Assisted Solution

by:ttterk
ttterk earned 100 total points
ID: 9757467
Chicagoan is on the right track. In Works 7.0 you select both columns, go to Format>Alignment and select "Center across selection" followed by "OK" or an enter key. This is very much like Excel. I am unsure how much earlier than v.7.0 this ability is available in Works, so I hope yours is fairly recent.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 4

Expert Comment

by:ttterk
ID: 9757468
Just reread your post--since you have 7.0 it'll work.

Must read ALL the words in future.
0
 

Author Comment

by:GMartin
ID: 9757562
Hi,

       ok, I understand everything so far with the exception of one thing.  Could you perhaps give me the steps for selecting both columns?

       Thank you.

       George
0
 
LVL 44

Assisted Solution

by:CrazyOne
CrazyOne earned 100 total points
ID: 9757568
just put your mouse on the header of the column tht is Labeled A and then drag your mouse over to B and then let go.
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757610
you want to select the cells...
CTRL each cell
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757612
CTRL LEFT CLICK each cell
0
 

Author Comment

by:GMartin
ID: 9757672
Hi,

      When I left hold in the Ctrl key and use my left mouse button, it only selects one entry instead of both of them.

     George
0
 
LVL 18

Expert Comment

by:chicagoan
ID: 9757716
without releasing the CTRL key?
0
 

Author Comment

by:GMartin
ID: 9757729
Hi,

      Yes, I hold in the CTRL key while left clicking.  But, I am only able to select either A1 or B1, but, not both.  Basically, I am merely wanting to take the information typed in A1 which carried over into B1 cell and center the information to both of these cells.  In other words, I am needing to merge A1 and B1 and center the info.  I never saw an option called "merge" in Microsoft Works 7.0.  

      In closing, there is probably something I am overlooking, but any further information or tips will certainly be appreciated.

      Thank you

      George
0
 

Author Comment

by:GMartin
ID: 9757765
Hi Guys:

      I decided to create the needed columns and rows using the Table Menu with Works 7.0.  The Spreadsheet option is just too complicated.  I would need individual tutoring on creating a spreadsheet.  

      I do appreciate the feedback.

     George
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Upper back Pain: My back hurt for months. Upper back, mostly my neck, spine and across my shoulder blades. I was getting headaches too, that felt like they were caused by tension in my shoulders, but now I feel fine! I'm sharing this hoping someone…
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question