• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

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

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
GMartin
Asked:
GMartin
  • 4
  • 4
  • 2
  • +1
3 Solutions
 
CrazyOneCommented:
Hi George I don't think most of use you use Microsoft Works instead we use Microsoft Office.
0
 
chicagoanCommented:
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
 
ttterkCommented:
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
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

 
ttterkCommented:
Just reread your post--since you have 7.0 it'll work.

Must read ALL the words in future.
0
 
GMartinAuthor Commented:
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
 
CrazyOneCommented:
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
 
chicagoanCommented:
you want to select the cells...
CTRL each cell
0
 
chicagoanCommented:
CTRL LEFT CLICK each cell
0
 
GMartinAuthor Commented:
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
 
chicagoanCommented:
without releasing the CTRL key?
0
 
GMartinAuthor Commented:
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
 
GMartinAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now